Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 155, comments - 2679, trackbacks - 64

My Links



Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.



Post Categories




January 2008 Blog Posts

Why use Google when a better, more accurate, and more powerful "search engine" exists?

Raise your hand if you've ever done this: At a programming forum that you regularly visit, you see a post asking for help The post describes a situation that you may not intimately familiar with, or that you know has been covered elsewhere many times, and it is clear a quick Google search will find a good answer. So, you think of some good key words, perform a few quick searches, examine the results, and determine which of your findings is a good...

posted @ Thursday, January 17, 2008 2:56 PM | Feedback (28) | Filed Under [ Miscellaneous ]

Rewriting correlated sub-queries with CASE expressions

Here's a very common situation that is very easy to optimize and simplify, submitted via the mailbag.

posted @ Wednesday, January 09, 2008 8:42 AM | Feedback (3) | Filed Under [ CrossTabs / Pivoting Data Efficiency Joins/Relations ]

Interesting Database Modeling Dilemma

Let's say you have a database that contains Companies, Products and Stores. Products and Stores are unique to each company -- i.e., they are not "shared" across companies. read more...

posted @ Monday, January 07, 2008 10:52 AM | Feedback (13) | Filed Under [ Database Design ]

Powered by:
Powered By Subtext Powered By ASP.NET