SQL Server 2008 Service Pack 2 Released
Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack...
2010-09-30
1,687 reads
StrateSQL
PASS Summit Schedule
Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit. You...
2010-09-30
1,553 reads
To Be There Or Not To Be There
Are you ready for Seattle? Have you registered for the PASS Summit? Hopefully with some good reasons you will be...
2010-09-28
675 reads
Index Black Ops Part 4 – Index Overhead and Maintenance
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-09-27
1,121 reads
Is It that Time Again?
Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases...
2010-09-23
497 reads
Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,443 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
429 reads
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
817 reads
Share Your Experiences at #SQLSAT58
Ever thought about sharing your experiences with SQL Server to more than just your immediate peers and colleagues? Up here...
2010-09-20
627 reads
September PASSMN Meeting This Week
Enjoying the fall here in Minnesota? The leafs are changing a bit and temp has been dropping. Has that left...
2010-09-20
503 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;