Maximum recursion possible with CTE in SQL Server 2005/2008

In my last blog about Tally Tables, we talked about the use of
recursive CTEs to generate Tally Tables. Following that,...

Analysis Services Operations Guide Released

The Analysis Services team has been working overtime lately to provide added community support for the traditional UDM-based OLAP engine...

Avoiding OR Conditions with Joins

Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...

PerformancePoint 2010 source control

While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...

Re-blog – May 27-June 2

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

SQLSaturday #77 Pensacola Florida Event Preview

Sometimes, even if I’m not attending, some SQLSaturdays stand out to me, and catch my interest. I guess it’s a...

Use PowerShell to Add a Login to a Database Role in all Databases

Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...

What is SSMS Addin

SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...

Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable

CREATE...

June 2011 Version of SQL Server 2008 Diagnostic Queries

Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information...