No Caps for SQL Saturday : Speaker Edition
A few weeks back, I got into a conversation about whether PASS should put the boot down on events and...
2012-05-17
999 reads
StrateSQL
“Thou Shall Not Shrink the Database” #TSQL2sDay
This month, Chris Shaw (Blog | @sqlshaw) is leading the charge on the T-SQL Tuesday. This event is basically a blogging...
2012-05-08
996 reads
May 2012 – Monthly SQL Server Checklist
They say, “April showers bring May flowers.” But what if it doesn’t bring May flowers? What if instead you get...
2012-05-08
833 reads
Can You Dig It? – Determining Index Plan Usage
She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...
2012-05-04
1,435 reads
Changing Priorities
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
708 reads
SQLFriends in Minneapolis
Ever wanted to hang out and talk about SQL Server over lunch? Maybe get a chance to ask those questions...
2012-05-02
615 reads
April 2012 – Monthly SQL Server Checklist
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
885 reads
SQLCLR: Good? Or Evil? #MemeMonday
Is SQLCLR good or evil? Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...
2012-04-10
1,130 reads
April #Meme15 Assignment
Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...
2012-04-09
817 reads
Re-blog – March 23 – March 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-30
1,865 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers