Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: March 2014

Default nullability of a new column

Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? I always did. Turns out I was wrong.

When you don’t specify NULL vs NOT NULL it will usually default to NULL. Here are some exceptions where it will default… Read more

0 comments, 199 reads

Posted in SQLStudies on 31 March 2014

Default nullability of a new column

Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? I always did. Turns out I was wrong.

When you don’t specify NULL vs NOT NULL it will usually default to NULL. Here are some exceptions where it will default… Read more

0 comments, 98 reads

Posted in SQLStudies on 31 March 2014

Collation: Expression

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Once you have… Read more

0 comments, 62 reads

Posted in SQLStudies on 26 March 2014

Collation: Expression

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Once you have… Read more

0 comments, 1,062 reads

Posted in SQLStudies on 26 March 2014

Collation: Location

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Where do we find… Read more

0 comments, 73 reads

Posted in SQLStudies on 24 March 2014

Collation: Location

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Where do we find… Read more

0 comments, 208 reads

Posted in SQLStudies on 24 March 2014

Thank you!

I won’t be able to make it to the PASS Summit this year but I still consider myself part of the community. The #sqlfamily. I was reading an interesting twitter conversation this morning about submissions for speaking slots at the Summit and rejection and what it means to those who… Read more

0 comments, 189 reads

Posted in SQLStudies on 19 March 2014

Collation: Definition

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out. First things first… Read more

2 comments, 286 reads

Posted in SQLStudies on 19 March 2014

Start with stupid

True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked out a computer. I spent half an hour watching him hit the keys repeatedly, check every cable, shake the mouse and in general get really agitated. He eventually came back… Read more

1 comments, 175 reads

Posted in SQLStudies on 17 March 2014

:CONNECT in SSMS

Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from within a SQLCMD script. What they may not realize is that this command (and other SQLCMD commands) can be used in a query window by turning on SQLCMD mode. There… Read more

7 comments, 571 reads

Posted in SQLStudies on 13 March 2014

T-SQL Tuesday #52: Keep your head down!

It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has asked us to “Argue against a popular opinion”. Now I do have a concern about this subject. I am frequently sarcastic and frequently people don’t realize… Read more

1 comments, 298 reads

Posted in SQLStudies on 11 March 2014

Characters you should never ever use in an object or schema name!

You can put pretty much any character you want into an object or schema name by enclosing the name in []‘s. This does not however mean that you should. There are two specific cases that I’ve seen that are in general a bad idea.

I’ve seen names that actually have… Read more

0 comments, 210 reads

Posted in SQLStudies on 5 March 2014

Using SQLFiddle

SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one of 13 different DMBSs (as of this posting) including two different versions of SQL Server (2008 & 2012).

www.sqlfiddle.com

First you set up your work environment and “Build Schema”.

Then… Read more

0 comments, 516 reads

Posted in SQLStudies on 3 March 2014