Tag Archives: T-SQL
-
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 -
Collation: Correction -> Expression, Column, Database
Leave a commentApril 10, 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 -
T-SQL Tuesday #53: Why so serious
8April 8, 2014 by Kenneth Fisher
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. …
Continue reading -
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
SQL Studies 