TempDB Destroyer
One of my previous posts, I covered how to create a really big database with just garbage data in it....
2012-12-29
1,151 reads
SQL Server 2012 Standard Edition Licensing Limits
As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be...
2012-12-29
7,550 reads
SQL Server 2012 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-28
998 reads
2012-12-28
7 reads
Reblog: December 21 to December 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-28
1,118 reads
PASSMN Presentation Materials
Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN). The turnout was quite excellent...
2012-12-28
743 reads
Index Analysis Post Christmas Update
Last week I mentioned that I had put up a few new versions of my index analysis script. Turns out...
2012-12-28
710 reads
My RSS Reader…The Great Clean Up
If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been...
2012-12-28
938 reads
SQL Server Cumulative Update
Microsoft today announced the latest round of SQL Server Cumulative Updates
SQL Server 2012 CU 5 – You can get more information...
2012-12-28
837 reads
Closing the Results Window in SSMS
This is a guest post by David Postlethwaite.
I’ve been wondering how to do this for years. At SQL Bits and...
2012-12-28
1,052 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers