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,084 reads
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,084 reads
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
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
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
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
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
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
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
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
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
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers