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,...
2011-06-04
20,296 reads
What is SSMS Addin
SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...
2011-06-03
712 reads
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...
2011-06-03
917 reads
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...
2011-06-03
499 reads
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...
2011-06-03
6,195 reads
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...
2011-06-03
1,010 reads
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...
2011-06-03
997 reads
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...
2011-06-03
2,832 reads
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...
2011-06-02
684 reads
Windows 8 demo
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
674 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers