As you're loading data into the table, the statistics are only getting updated if you cross a particular threshold. The rules are:

* First row on an empty table

* If less...

OK. For a lock control system as outlined,...

opc.three (3/18/2013)

---

For clarity READ_COMMITTED_SNAPSHOT is just a mode of the READ_COMMITTED isolation level with...

The best sources apart from the Books Online at the Microsoft Developers Network is to hit the books. Kalen Daleney's SQL Server 2008 Internals is just excellent. You can also...

If you can make changes to your architecture, you might want to look into partitioning the data. That makes it very easy to move data out of one database...

Best suggestion I can make is to measure the number and size of your current transactions. Get a sense of the amount of data that is actively being modified and...

Are you getting a specific error? Are you connecting to a default instance or a named instance? Try both. Also try just supplying the IP address instead of the server...

Jeff Moden (3/14/2013)

---

foxxo (3/14/2013)

---

http://googlereader.blogspot.com.au/2013/03/powering-down-google-reader.html

Sign up to the petition to keep it:

https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader

I use it daily to keep track of several SQL blogs and it keeps RSS feeds synchronised between my phone,...

It does put considerable additional load on the tempdb, so be sure you're ready to handle that. The amount depends on the level of data changes you're dealing with. Other...

ratheesh4sql (3/13/2013)

---

planning to do the partitioning for the main table with region wise.....So that we can split the data into a different file group and the data accessible also will...

Thanks! That was a lot of fun. And I didn't make Adam angry more than once or twice, so...

Jonathan Kehayias (3/15/2013)

---

Grant Fritchey (3/13/2013)

---

Ha! Don't hold your breath. I still haven't...

Should we show him how to work the site?

Sergiy (3/13/2013)

---

Grant Fritchey (3/13/2013)

---

But a few years ago, I did do a series of tests, not from ODBC, but through ADO.NET, and we saw serious performance degradation when using single...

shannonjk (3/13/2013)

---

That is odd that the merge should be faster than the hash, since if I add hash to the join (i.e LEFT HASH JOIN) it executes in half the...