SQL Server SELECT

I often find myself needing a list of columns from a table or a view for a query, documentation, troubleshooting, etc. Easy enough to drag a...

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...