Solid State Disks and SQL Server
An interesting result from a recent test of SSDs in SQL Server by Wes Brown. A surprising discovery is important for anyone thinking about using SSDs to know.
2012-03-09 (first published: 2010-04-08)
36,280 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-29
2,259 reads
Fundamentals of Storage Systems, IO Latency and SQL Server
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
2011-03-01
3,045 reads
Giving Back, SQLMeetings.com Is Going Live Soon
I’ve been pretty quite since the PASS Summit and with good reason. Every year we have a chapter leader meeting....
2010-12-10
618 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-24
2,200 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-19
2,937 reads
Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-15
4,053 reads
Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
2009-12-11
3,898 reads
Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
2009-11-27
3,278 reads
Fundamentals of Storage Systems - The Basics of Spinning Disks
Your servers are only as fast as the slowest part, hard drives.
To feed other parts of the system we have...
2009-09-28
2,687 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