Are You a Chessplayer?
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,037 reads
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,142 reads
On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...
2012-12-17
9 reads
On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals.
Today’s topic...
2012-12-17
1,083 reads
SQL Server Training in 2013–SQL Server 2012 New Features
As we approach the end of 2012 – The release year for SQL Server 2012 many of you as we approach...
2012-12-17
960 reads
On the Fourth Day…
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for one of our favorite databases. That database being the...
2012-12-16
6 reads
On the Fourth Day…
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for...
2012-12-16
890 reads
PASS Data Arch VC presents: Intro to Master Data Services by James Serra
Please join this Thursday Dec 20th 2012 at noon central for Business Intelligence expert/consultant James Serra talking Master Data Services....
2012-12-16
532 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks...
2012-12-16
839 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus
talks about Bookmark Lookup Deadlocks in...
2012-12-16
1,515 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