Category Archives: System Functions and Stored Procedures
-
Does SQL Server do a CHECKDB during an instance restart?
11May 7, 2014 by Kenneth Fisher
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
Continue reading -
Why is there a sysobjects when we already have sys.objects?
2May 5, 2014 by Kenneth Fisher
Once upon a time in a version of SQL far far away we had system tables that were easy to …
Continue reading -
The default autogrowth settings do NOT come from the Model database.
5April 28, 2014 by Kenneth Fisher
I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
Continue reading -
Collation: Temporary objects and variables: Demonstration
4April 21, 2014 by Kenneth Fisher
I had a recent run in with collation problems and it got me started reading about them. As I read …
Continue reading -
Getting a query plan
3February 19, 2014 by Kenneth Fisher
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
Continue reading -
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
2January 29, 2014 by Kenneth Fisher
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
Continue reading -
Negative session_ids
3January 27, 2014 by Kenneth Fisher
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
Continue reading -
The “most_recent_sql_handle” column
1January 22, 2014 by Kenneth Fisher
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
Continue reading -
Transactions: Who, What and Where
1January 20, 2014 by Kenneth Fisher
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I …
Continue reading
SQL Studies 