Fall Speaking Schedule
I just got back from speaking at SQL Saturday #51 in Nashville, which was a lot of fun. I’ll write...
2010-08-23
801 reads
Glenn Berry
Proper Usage of MAXDOP Setting When Compressing Indexes in SQL Server 2008/2008 R2
I am a pretty big fan of SQL Server Data Compression, especially the enhanced version found in SQL Server 2008...
2010-08-17
2,310 reads
SQL Server 2005 SP3 Cumulative Update 11 (CU11) Available
Microsoft has released Cumulative Update 11 for SQL Server 2005 SP3, which is Build 9.0.4309. There are only four fixes...
2010-08-17
824 reads
SQL Server 2008 R2 RTM Cumulative Update 3 (CU3) Available
Microsoft has released Cumulative Update 3 for SQL Server 2008 R2 RTM, which is Build 10.50.1734. I count 29 fixes...
2010-08-17
888 reads
SQL Server 2008 and R2 Diagnostic Information Queries
It has been a couple of months since I have posted an update to my “SQL Server 2008 and R2...
2010-08-16
1,691 reads
Speaking at 24 Hours of PASS on September 15, 2010
I will be one of the presenters for the 3rd installment of the 24 Hours of PASS: Summit Preview, which...
2010-08-11
777 reads
Using the Windows Experience Index as a Shopping Tool
One easy to use and useful tool that you can use to compare relative performance between different machines that are...
2010-08-11
1,512 reads
Windows Azure Platform One Month Pass
According to all of their public pronouncements and the flurry of recent activity, Microsoft seems extremely serious about Windows Azure...
2010-08-06
995 reads
Testing Native Backup Compression in Combination with SQL Server 2008 R2 Data Compression
SQL Server 2008 introduced native backup compression and data compression as features that were only available in the Enterprise Edition...
2010-08-04
3,819 reads
A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,987 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;