Yeah, I can't spot any differences either. Hmmm.... Estimates & actuals are off, more than a little bit. I know you updated the statistics, but did you try using WITH...

Take a look at the sys.dm_exec_query_stats DMO. You should be able to get a count from that assuming the statement is still in cache.

It does 1/3 the number of reads, but increases the time? No, that's not one I've seen. Can you post both actual execution plans? I know you say they're identical,...

I've never seen a hard & fast ruling on this one. I generally go between 1/10 and 1/5 of the size of the database and then watch things from there....

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I miss anything...

I would say no, Microsoft doesn't have a simple list of coding standards. But, if you want some Microsoft endorsed list of best practices, I'd check out the Static Code...

If you have different ANSI settings on the connections, you'll have different plans. If you're calling the query one way from the app (parameterized query, stored proc) and a different...

Marco V (1/4/2012)

---

So as a summary to conclude this case for me.

to run through the data it goes between 20 and 30 seconds (maxdop 1 is going abit faster).

i also...

I would not suggest installing SQL Server if you're going to be changing the server name, etc. Get the server set up and configured, then install SQL Server. You'll have...

What about just using the query window and typing 'UPDATE dbo.MyTable SET ColumnA = 42 WHERE ColumnB = 42'?

The gui in SSMS can support what you're doing, but it's a...

Ninja's_RGR'us (1/4/2012)

---

Grant Fritchey (1/4/2012)

---

Statistics might be out of date. A nested loop on 53million rows is pretty frightening. You have full optimization, so the optimizer thinks this is the right...

Statistics might be out of date. A nested loop on 53million rows is pretty frightening. You have full optimization, so the optimizer thinks this is the right way to go,...

You could try capturing the statements using trace events. You just need to be careful because that will capture lots of information. Either turn it on then turn it off...

GilaMonster (1/3/2012)

---

You can't really do it in much less unless you're doing what too many of the MCTs...

Divine Flame (1/3/2012)

---

I need to give a training on SQL Server 2008 Database Administration and I have to do it in next couple of days. It will be a two...