SQL Server SELECT

THIS POST REQUIRES AN UPDATE WITH CHANGES MADE TO SQL AZURE For anyone that doesn't know what SQL Azure is, it's essentially SQL S...

Download .rss script Most people that work with SSRS (2005, 2008, 20080 R2) are aware of two ways to deploy Reporting Services catalog ite...

I was recently troubleshooting a severe query performance issue when I ran into a query plan that used a nested loops join to combine data f...

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