Jack has largely nailed it. ORM tools speed up development, but at the cost on the database side of things. Using the tool straight, no modifications, you get lowest common...

sward (8/4/2009)

---

Hi, I tried to find a good ordering field but have nothing.

I'm not really sure what you could use to get this using Top 1. Am i...

I can't support .rar compression files at work (don't ask). Can you zip the files?

Through the graphical user interface? If you're running a trace through TSQL, it's not running on your local machine, it's...

Steve Jones - Editor (8/4/2009)

---

I didn't think it was a good design, and not sure it really saved space, but I knew it would generate discussion. Lots of people, especially...

Exclusive locks are occuring because data is being manipulated, inserted, deleted or updated. Where's the issue?

Queries don't automatically use multiple processors to run. MAXDOP defines a limit on how many processors can be used, not on how many will be used. SQL Server also uses...

Sorry, only the ones that are associated with the index that was rebuilt.

Didn't you just ask this question under a different topic?

Please don't do that. It makes conversations harder to track.

Actually Steve, if I'm understanding the question, I think the answer is...

Yes. When the index rebuilds, as oppose to reorganize, the statistics are updated and the procedures referncing those statistics are all marked for recompile.

Well, instead of MAX and an aggregate function, I'd suggest using TOP 1 and an ORDER BY if you can supply a column that can be ordered in such a...

Because I know that a bunch of you will qualify:

http://scarydba.wordpress.com/2009/08/03/sql-server-standard/%5B/url%5D

Please consider taking part.

Inline UDF's are not usually a problem because, as you can see in the execution plan, they'll resolve out to a standard set of operations, like a view (unlike the...

It looks basically OK, but I'm curious why you're aggregating the data & selecting the max value. Are there multiple entries with the same key value? That's a bit of...

You wouldn't by chance be running the Profiler GUI against this server? If so, I'd suggest turning that off and using scripts to create a server-side trace routine. I say...