From MSDN : MOST , but not ALL, modification

BINARY_CHECKSUM(*), computed on any row of a table, returns the same value as long the row is not subsequently modified. BINARY_CHECKSUM(*)...

Lynn Pettis (4/17/2014)

---

Yep, told you that would happen earlier.

Now, what date and time...

Thanks a lot, I did not know about SET DATEFORMAT

Arjun Sivadasan (3/27/2013)

---

Hi Federico, I gave this a try.

We have daily tasks running in our system. Every day at a specific time, we truncate certain tables and repopulate them. We...

mishaluba (2/7/2013)

---

Thank you for the article! Note that if you are using SQL 2012 there is now a way to invoke SSIS package from T-SQL without having to resort...

philcart (2/7/2013)

---

nick.mcdermaid (2/6/2013)

---

SQL Agent is tricky because:

1. If you have only one SQL Agent job being your 'host' you can't run mutliple jobs in parallel

2. If you want to have...

BULK INSERT on Windows OS is not pipelined : first you need to save all to a file, then Bulk Insert from the file.

SSIS use C# to achieve pipelining .

philcart (2/5/2013)

---

Sorry you lost me on a few fronts.

1) you reference another article stating, "The method SSIS Data Pump represents the most effective way to load large amount of data...

chadmjordan (2/2/2013)

---

Part of our current daily db maintenance is a sql script that reads through all indexes in a db and determines if they need a reorg or rebuild, or...

It depends how many rows and how many bytes per row you are going to insert.

If you start making DWH / ETL with SqlServer, you will probably face this...

You can try by yourself to compare .. as I have written, Insert Into is fully logged operations, requires more restrictive lock on target table and makes heavy use of...

Thanks to Alexander for the fix.

About performance metrics :

in general, my update statistics runs N times faster than built-in sp_updatestats , where N is number of threads ....

Good correction !

I suppose...

Release the semaphore : just end the transaction that is holding the semaphore by a commit ( or rollback, is the same since no data are modified) ...