The NOT FOR REPLICATION option goes before the AS keyword. If you really have it after the AS, you should have gotten an error when creating the trigger. Verify this first before we get any further into the problem. Jay Madren
2003-05-02
1 reads
The processes that extract data from production database, transform and load them into your DW depend on your business requirements. See "Extracting Data from Operational Systems", "Cleansing and Transforming Data", "Loading Data into the Data Warehouse Database" in BOL to familar with the ETL concept and tools before you start.
2003-05-02
See "Autocommit Transactions", "Implicit Transactions" and "SET IMPLICIT_TRANSACTIONS" for explaination and examples in BOL
2003-05-02
A nice suggestion and one that I know people try to follow, but it can get difficult. I know as an author I often am trying to solve a particular problem and may not realize there is another use. We've seen that usually someone will comment on how they used a similar solution to solve […]
2003-05-02
Im surprised there is such a big disparity between backup vs bcp, maybe I just never looked. One idea is to break it up into separate publications, maybe separate pub for each large table, one pub for all small tables. That way the snapshot will go faster and the log won't grow as much. Lot […]
2003-05-02
1 reads
That was what I was afraid of... BTW, the snapshot takes about 8-9 hours, but a Baskup/Restore takes 2-3 hours, and that's after optimizing the snapshot using -UseInprocLoader and multiple BCP threads. I've also considered doing a detach-->copy-->attach, this would only take about 2 hours. Also the snapshot is logged when it is applied, so […]
2003-05-02
1 reads
Sorry, I forgot about that. Like I said, I didn't test it . This will work, as I did test it: Update Table1 Set phone2 = phone from Table1 inner join (Select Table2.keyvalue, min(addtlphone) phone from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue where addtlphone > phone1 group by Table2.keyvalue) T on Table1.keyvalue=T.keyvalue Update Table1 Set […]
2003-05-02
1 reads
Can't have an aggregate in an update statement. I'm trying to think if a self join with the inner join would work but I'm not getting it yet. Suggestions? Thanks!
2003-05-02
1 reads
Great help, Thanks! I think I can see how to generate the similar code for the ALTER TABLE - I know the xtype to search for is '175' and replace with '167'. Just hadn't thought of the idea of generating update commands via a literal and variable string concatenation...clever! Thanks again! J.C.Michael "You can never […]
2003-05-02
I haven't tested this, but something along these lines should work: Update Table1 Set phone1 = min(addtlphone) from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue Update Table1 Set phone2 = min(addtlphone) from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue where addtlphone > phone1 Update Table1 Set phone3 = min(addtlphone) from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue where […]
2003-05-02
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers