try using the bcp utility. bcp out the table into the flat file, drop the table and recreate it on the second filegroup, then bcp in the file into the table. use the batch param so that it wll commit on a set number of rows. hope this help.
2003-06-17
Hmmm... Could you call the Notification Service at the end of your batch instead of resorting to a trigger? Perhaps log the changes in another table and then let the Notification cycle through the changed records. Alternatively, could the client applications query the changed records in batches? Or, and obviously I don't know much of […]
2003-06-17
I'll go with Antares686 suggestion, thus version II Select Calc.StudentNr,Calc.ColSum/Calc.FieldCnt From ( Select StudentNr, ( ISNULL((CASE When ST1Q1 = 'N' Then Null ELSE ST1Q1 End),0) + ISNULL((CASE When ST1Q2 = 'N' Then Null ELSE ST1Q2 End),0) + ISNULL((CASE When ST1Q3 = 'N' Then Null ELSE ST1Q3 End),0) + ISNULL((CASE When ST1Q4 = 'N' Then Null […]
2003-06-17
May not be the best solution but should work for you calculation try ( ISNULL((CASE When ST1Q1 = 'N' Then Null ELSE ST1Q1 End),0) + ISNULL((CASE When ST1Q2 = 'N' Then Null ELSE ST1Q2 End),0) + ISNULL((CASE When ST1Q3 = 'N' Then Null ELSE ST1Q3 End),0) + ISNULL((CASE When ST1Q4 = 'N' Then Null ELSE […]
2003-06-17
Hi tyang, quote: Is there a way to find who modified the table, when the record had been deleted? are you looking for the user who deleted the record? You can use CURRENT_USER or USER_NAME() to get this. Cheers, Frank
2003-06-17
One of our apps uses several databases. We use a 2-nodes active/active cluster with one instance of SQLServer on each node, and the various databases balanced between the 2 nodes (call it "static" load-balancing). In case of a hardware failure of one node, the instance goes on the 2nd server, providing failover protection.
2003-06-17
use transaction replication. refer the complete replication configuration process from BOL..
2003-06-16
1 reads
What are most people runnning - active/active or active/passive and why?
2003-06-16
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-16
Hi Noel, quote: What is the best program : 1. a perfectly written program, written with the best design methodology, with optimal performance, making use of the best technology for the job, taking into account all the pitfalls of the language, having a high degree of readibility and maintainability that does not do what the […]
2003-06-16
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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