SQL Server SELECT

I was recently faced with a difficult performance issue. In an effort to save a client some time and money I convinced them that a view-base...

Lately I've been getting a lot of requests for step-by-step documentation for non-technical end-users. Well actually not just lately. I ...

I've recently begun using Visual Studio 2010 database projects (DBPro). I think it's a great tool and having been a .NET developer f...

A template for what follows can be found on my personal  website . Reports are often an afterthought and commonly believed to be an easy t...

II'm currently working on a Business Intelligence project and depending on who I am talking to we are either building a Data Mart or a D...

GROUP BY and DISTINCT can return the same results when looking for uniqueness in a resultset. Consider the Sales table below. Store     Pr...

A few things to keep in mind when deciding whether you want a unique index or constraint. 1) The index creation options other than FILLFAC...