Isolation Levels in SQL Server
Do your eyes start to cross whenever you think about isolation levels? Mine did, too. Here's how I keep it all straight.
2019-04-03
32 reads
The Non-Cluttered Index
Distributed Replay Utility – The Search for the Cure
The Complaint(s) When I was young, I went to nursing school. In school, we were taught that in order to come up with a proper diagnosis, the doctor first...
2019-04-01
36 reads
The Distributed Replay Utility: Replaying for Real (Where Could It Possibly Go Wrong)?
The Short Answer? (In at least a couple of places) When I first learned about the DRU, I was very excited about the possibilities. I began to play with...
2019-03-28
8 reads
Capture/Replay a Sample Workload on the Distributed Replay Utility
Part I: Capture a Workload Make a backup of the database(s) in question, as it will be necessary for the replay. Using the TSQL Replay template, fire up Profiler...
2019-03-26
61 reads
Improving Performance of the Distributed Replay Utility on SQL Server 2012
Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...
2019-03-24
188 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;