How many times the T-SQL inside the CTE is executed?
Introduction
Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...
2011-12-19 (first published: 2011-12-15)
11,571 reads
How to change the SQL Server service account
It’s easy. First you click here:
Then you find the SQL Server 2008 or 2008 R2 program group
Open those and then...
2011-12-15
21,845 reads
Will You Buy Refurbished? Part 2
Yesterday I shared the small adventure of buying a refurbished laptop. While I was at Compusa looking at laptops I...
2011-12-15
863 reads
PASS Board of Directors – Who I’m Voting For
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...
2011-12-15
673 reads
#meme15 – Why Do You Blog?
Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15. The overall topic of #meme15 will be social networking, obviously...
2011-12-15
618 reads
SQL Saturday 99 – SSWUG Interview
Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-15
811 reads
Why I blog #Meme15
I’d seen various #meme tweets on twitter but it wasn’t until I saw this blog by John Sansom (Blog|Twitter) that...
2011-12-15
480 reads
PowerPivot Data Connection Error
PowerPivot report returns the following error from Excel Services:
The data connection uses Windows Authentication and user credentials could not be...
2011-12-15
1,318 reads
Execute Permissions
Written by Ian Treasure
Gethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach...
2011-12-15
1,390 reads
Why Did You Start Blogging?
That’s easy, because Brent Ozar (Blog|Twitter) challenged me to……
Finding time to keep up with awesome blog content can be tough....
2011-12-15
657 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
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...
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