Reblog: March 8 to March 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
713 reads
StrateSQL
Last Weeks Top 20 “Reading” Links #23
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-11
559 reads
Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month,...
2013-03-11
565 reads
Reblog: March 1 to March 7
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-08
629 reads
Index Analysis March Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure...
2013-03-07
714 reads
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,435 reads
Last Weeks Top 10 “Reading” Links #22
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
585 reads
March 2013 – Monthly SQL Server Checklist
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
804 reads
Five Virtual Labs for the SQL Server 2012 DBA
Wouldn’t it be nice if you had a chance to try out the features of SQL Server? Maybe give them...
2013-03-01 (first published: 2013-02-21)
4,257 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
926 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...
Automatically generate tabular model partitions
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
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;