Last Weeks Top 10 “Reading” Links #17
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-28
960 reads
StrateSQL
Reblog: January 18 to January 24
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-25
1,051 reads
5 MCM Readiness Indexing Videos You Should Watch
Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification. In the process of...
2013-01-23
1,389 reads
Last Weeks Top 10 “Reading” Links #16
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-21
741 reads
2013 Polar Plunge #SQLPlunge
Next month… on March 2… I’m going to jump into a lake in Minnesota. Now it’s cold in Minnesota. In...
2013-01-18
631 reads
Reblog: January 11 to January 17
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-18
587 reads
STATS_DATE() Doesn’t Indicate The Validity of Statistics
From time to time, you might have caught yourself in a conversation similar to the following:
Fred: Hey folks, we have...
2013-01-17
1,264 reads
Last Weeks Top 10 “Reading” Links #15
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-14
572 reads
Reblog: January 5 to January 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-11
5,262 reads
Six Degrees of SQL Saturday Fargo
Do you know anyone that lives in or around the great white north that is Fargo, North Dakota? If so,...
2013-01-11
672 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;