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,304 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
968 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,218 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
855 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
6 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,850 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
810 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
937 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,689 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,047 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers