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 [...]
SQL Server
Commenting Your Code Do it, people. I don’t comment enough of my code, but it’s something I keep in the back of my mind all the time.
Fast Running Totals Solution With Ordered CTE I love Mladen’s solution to this particular problem. I usually would use a nasty self join or some kind of hideous [...]
Here are the slides and sample code from my recent presentation “From Tables to Objects” that I gave at the Central Ohio .NET Developer Group.
To those who did not attend, you can skip the rest of this post unless you want some NHibernate and SQL Server resources.
NHForge – this is the project home page [...]
SQL Server
Object Naming Standards Scott Herbert put up an overview of the naming standards that he uses. Like the obnoxious lout that I am, I commented. The point is, of course, to use naming standards. Take a look at Scott’s for an example.
No SQL There’s a big hullabaloo going on about this whole “No SQL” [...]