Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,711 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,468 reads
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM....
2011-10-11
679 reads
Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...
2011-10-04
787 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,396 reads
How to monitor number of VLF’s in your database
A few weeks back we did a blog post about a file grow bug that has been fixed with SQL...
2011-09-20
1,621 reads
T-SQL Function: EOMONTH
We have all been in a situation where we had to get the last day of the month with T-SQL....
2011-09-13
5,764 reads
Blog Series: T-SQL Enhancements
Three months back in this blog post – T-SQL Enhancements in SQL Server Denali (2011) – we promised to do a series...
2011-09-06
990 reads
New LOGICAL functions in SQL Server Denali
IFF Function
If you are an old Access or Excel “developer” you know this one. This is not a function I...
2011-09-06
2,957 reads
T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I...
2011-08-30
4,627 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;