Return of Index Analysis Part 5
Let’s Anaylze An Index!Alright, up to the last of the changes I’ve made to the index analysis query that I...
2010-10-25
1,528 reads
StrateSQL
3-Weeks to PASS Summit 2010 Countdown -
Only 3 more weeks until the PASS Summit and it’s time for another countdown post. I’ve done a few of...
2010-10-23
749 reads
SQL Saturday 58 Next Week
Wow! Minnesota’s SQL Saturday event is next week already. We still have a lot to do to be ready. Some...
2010-10-22
554 reads
Return of Index Analysis Part 4
Let’s Anaylze An Index!We’ve got through the first three parts of this continued series on the Index Analysis query last...
2010-10-22
609 reads
SSWUG Fall 2010 Virtual Conference Starts Today!
Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today. It’ll go on from today through Friday – if might...
2010-10-20
574 reads
SSWUG Fall 2010 Virtual Conference This Week
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a...
2010-10-18
557 reads
4-Weeks to PASS Summit 2010 Countdown – Lunch
There are now 4 weeks until the PASS Summit and a few times now I’ve discussed ( 1, 2, 3 ) some...
2010-10-14
773 reads
Finding Missing Values from an Array
Missing NumbersToday a developer came up to me and wanted help solving a problem he was running into with a...
2010-10-13
1,036 reads
Return of Index Analysis Part 3
Let’s Anaylze An Index!Time for part three of my continued Index Analysis query. The previous posts in this series are:...
2010-10-13
968 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
889 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;