Tag Archives: language sql
-
Characters you should never ever use in an object or schema name!
Leave a commentMarch 5, 2014 by Kenneth Fisher
You can put pretty much any character you want into an object or schema name by enclosing the name in …
Continue reading -
Transactions: What commands aren’t allowed?
Leave a commentFebruary 5, 2014 by Kenneth Fisher
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put …
Continue reading -
Transactions: Creating a single restore point across multiple databases.
Leave a commentFebruary 3, 2014 by Kenneth Fisher
This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple …
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 -
Guid vs Identity columns (Ints)
11January 13, 2014 by Kenneth Fisher
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary …
Continue reading
SQL Studies 