This appears to be a system procedure..but it isn’t!
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,042 reads
Blog Posts
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,848 reads
T-SQL UPPER(): Change an all lowercase string to uppercase
The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...
2011-04-05
1,713 reads
Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,699 reads
#Meme Monday
Use extended events; they work – and make you appear magical.
– “Write a SQL blog post in 11 words or less”...
2011-04-04
631 reads
A SQL Server Hardware Nugget A Day – Day 4
Day 4 of this series is about the upcoming AMD “Bulldozer” family of processors that is due to be released...
2011-04-04
387 reads
A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
700 reads
Developing with SQL Server: Three ways to get at data
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections,...
2011-04-04
2,443 reads
Find tables which are most commonly used in Stored Procedures
When you start working on a new project, one of the important tasks as a database developer is to get...
2011-04-04
109 reads
Isolating SQL Server from other systems
In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...
2011-04-04
2,159 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers