Execution Plans – Table, Clustered Index and Non-Clustered Index Scan
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,320 reads
Blog Posts
Goals – 9 month checkup
Nine months down, three to go*. It’s time once again to see where I’m at with the goals I set...
2012-04-02
976 reads
Mirroring Support for SharePoint 2010 Databases
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,230 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log...
2012-04-02
859 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along –...
2012-04-02
12 reads
Parallel Data Warehouse – Slowly Changing Dimension
Most of my day-to-day work is currently centered around Microsoft’s Massively Parallel Processing Appliance call PDW (Parallel Data Warehouse). Many...
2012-04-02
1,853 reads
Rebuilding System Databases
Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...
2012-04-02
816 reads
SQL Saturday #131 – Phoenix Schedule Posted
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
940 reads
SQL Server 2012: SSAS enhancements
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in...
2012-04-02
2,697 reads
SQL Server Log Backups
While presenting a session on Common Backup Problems both at SQL Saturday in Orange County and at SQL Connections in...
2012-04-02
1,060 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers