What Is Using The Most Space In Your Database ?
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database...
2009-10-14
800 reads
Glenn Berry
New Dell PowerEdge R710 Database Server
My long awaited new database server arrived today! It has two, quad-core Xeon X5550 processors, 72GB of DDR3 RAM, and...
2009-10-09
1,789 reads
SQL Server Announcements From Microsoft
Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for...
2009-10-09
892 reads
What a backed up Database Mirror looks like
One thing you need to be careful about with SQL Server 2005/2008 Database Mirroring is making sure that you don’t...
2009-10-09
1,319 reads
A DBA’s Fantasy
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,393 reads
Very Useful SQL Server 2008 High Availability White Paper On MSDN
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL...
2009-10-08
778 reads
Updated SQL Server 2008 Diagnostic Information Queries
Here is the October 2009 version of my SQL Server 2008 Diagnostic Information Queries. They are very useful for gathering...
2009-10-07
1,795 reads
More SQL Server Benchmarks From AnandTech
AnandTech has another I.T. oriented post up comparing the performance and value of two-socket servers to four-socket servers. The gist...
2009-10-06
805 reads
A Tale of Two Utility Companies
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have...
2009-10-05
611 reads
How to Diagnose and Correct a “Runaway” Transaction Log
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I...
2009-10-05
8,563 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers