Start Getting Ready for PASS Summit 2013
Seems so early in the year, but it’s already time to start getting ready for this year’s PASS Summit. There...
2013-02-14
681 reads
StrateSQL
Give Your Valentine Some Discounted Indexing
Looking for that special gift for Valentine’s day and wanting to really change things up? How about getting your loved...
2013-02-13
547 reads
T-SQL Tuesday – Powershell and Perfmon Results – #TSQL2sDay
This month, Wayne Sheffield (Blog | @DBAWayne) is running T-SQL Tuesday on PowerShell. T-SQL Tuesday is a monthly blogging event where a number...
2013-02-12
709 reads
February 2013 – Monthly SQL Server Checklist
February is a short month… and if you are following the Monday’s you know that today’s the second Monday of the...
2013-02-11
665 reads
Last Weeks Top 10 “Reading” Links #19
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-11
463 reads
Reblog: February 1 to February 7
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-08
891 reads
Determining Filegroup for a Table
Have you ever needed to figure out which filegroup your tables are located within? If you had to do this,...
2013-02-06 (first published: 2013-01-29)
4,744 reads
Last Weeks Top 10 “Reading” Links #18
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-02-04
488 reads
Ask the Unicorn: Why is it Important to Know Tables in Filegroups?
Earlier this week, I wrote a quick blog post on a throw-away script I had written. The blog post was DETERMINING...
2013-02-01
617 reads
Reblog: January 25 to January 31
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-01
911 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;