SQLDIY: Index Fragmentation Levels
Indexes, indexes, indexes my kingdom for an index! Well, something like that. Indexes are the single most important structure in...
2011-07-07
1,272 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2
Adding In Others For Contrast
In our first part we introduced Pliant and the LS 300 drive. In part 2 we...
2011-07-06
2,957 reads
SQLDIY: Statistics Information Including Last Update
One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the...
2011-07-05
1,005 reads
SQLDIY: Gathering A Data Dictionary
In this installment we are looking at assembling a basic data dictionary from the column level meta data stored in...
2011-07-01
995 reads
The Austin Fall Classic, SQLSaturday is Coming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have...
2011-06-30
1,458 reads
The Austin Fall Classic, SQLSaturday is Comming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have...
2011-06-30
1,544 reads
SQLDIY: Tracking Space Usage At the Index Level
I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the...
2011-06-29
1,430 reads
Understanding Benchmarks
That Means What?
Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means...
2011-06-29
2,112 reads
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
563 reads
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait...
2011-06-27
1,056 reads
Blogs
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Tip: Expanding a SQL statement
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Forums
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers