Tag Archives: system functions
-
What is this default trace you speak of?
4June 12, 2014 by Kenneth Fisher
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
Continue reading -
Escaping from a runaway Logon trigger
11May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading -
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 -
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 -
Finding active DTS packages
9November 27, 2013 by Kenneth Fisher
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
Continue reading -
Finding the metadata for a query
2November 25, 2013 by Kenneth Fisher
You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
Continue reading
SQL Studies 