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-07
3,475 reads
Glenn Berry
Microsoft DreamSpark for Students
If you are a college or high school student, you can get a very valuable assortment of free software from...
2011-01-04
1,303 reads
Lots of Intel Sandy Bridge News Today
Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information...
2011-01-03
848 reads
TPC-E Benchmark Analysis by CPU Type
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,279 reads
The Importance of Windows Power Plans for Server Performance
This is a subject I have written about a couple of times before, here and in much more depth here. ...
2010-12-29
1,150 reads
Updated SQL 2005 and 2008 Diagnostic Queries
Since it is almost January 2011, I thought I would post the January 2011 versions of the SQL Server 2005...
2010-12-29
2,276 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...
2010-12-28
2,919 reads
A Collection of Good Information About Controlling VLFs in SQL Server
Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the...
2010-12-27
557 reads
Intel Sandy Bridge Processor Machines Coming Soon!
If you are in the market to buy or build a new laptop or desktop computer, you might want to...
2010-12-22
712 reads
SQL Server 2005 SP3 Cumulative Update 13 Released
Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday,...
2010-12-22
851 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
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers