Paul Randal started this chain post. He tagged Steve Jones who, in turn, tagged Jack Corbett who finally tagged me. I’m pretty sure everyone who nominally makes sense has already been tagged at this point thus leaving Jack to scrape the bottom of the barrel.
Like Jack, I think I could approach this in a number [...]
SQL Server
Kendal Van Dyke: Delegation: What It Is And How To Set It Up – The title says it all, folks.
wmarow’s disk & disk array calculator – Storage calculator. This wouldn't be terribly fascinating, except I know the performance characteristics of our I/O subsystem and when I plug in the variables, this is pretty close [...]
Starting today, and ending on Friday, October 16th, you can submit a blog post, or series of blog posts, to the 2009 Log Reader Awards.
What is it?
You’re probably asking yourself “What’s a Log Reader Award?” Well, dear reader, a Log Reader Award is an award created by bloggers (myself, Andy Warren, and Brent Ozar) to [...]
SQL Server
Developers, use Profiler to profile yourself John Sterrett goes over how to use profiler to profile your own SSMS session.
Toys and Tools Mike Hillwig put together a list of great SQL Server tools.
The ABCs of Management Studio Shortcuts Glory be to keyboard shortcuts
Development
ASP.NET MVC 2 Preview 2 New MVC hotness has been released. Yes, [...]
SQL Server
Optimizing Queries That Access Correlated datetime Columns DATE_CORRELATION_OPTIMIZATION is some good stuff. If you have an InvoiceDate column that happens to be close to the OrderDate column in a related table, and this setting is on, the compiler will generate what could be a much better optimization plan.
Difference between an index and a primary [...]
