My Thoughts on the Intel Sandy Bridge Chipset Recall
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I...
2011-02-03
1,661 reads
Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...
2011-01-24
2,725 reads
SQL Server Index Tuning for Mere Mortals
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...
2011-01-11
2,969 reads
SQL Server Workload Types and Hardware Selection
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2011-01-03
2,280 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-17
4,097 reads
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-11
2,035 reads
How Old Are Your Database Statistics?
Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...
2010-09-02
3,375 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-30
3,661 reads
Experiments with Data Compression in SQL Server 2008
Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...
2010-02-26
2,250 reads
Are You Running the x86 Version of SQL Server 2005/2008?
If so why? Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008,...
2010-02-03
3,616 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers