Tag Archives: code language
-
Default nullability of a new column
Leave a commentMarch 31, 2014 by Kenneth Fisher
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? …
Continue reading -
Collation: Expression
Leave a commentMarch 26, 2014 by Kenneth Fisher
I had a recent run in with collation problems and it got me started reading. As I read I started …
Continue reading -
Collation: Location
Leave a commentMarch 24, 2014 by Kenneth Fisher
I started reading about collations after I had a recent run in with them. As I read I started to …
Continue reading -
Collation: Definition
5March 19, 2014 by Kenneth Fisher
I had a recent run in with collation problems and it got me started reading. As I read I started …
Continue reading -
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 -
What’s the difference between a temp table and a table variable?
3February 24, 2014 by Kenneth Fisher
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the …
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
SQL Studies 