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.

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more

7 comments, 107 reads

Posted in SQLStudies on 16 April 2014

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about 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.

You’ve… Read more

0 comments, 61 reads

Posted in SQLStudies on 14 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about 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.

You’ve… Read more

0 comments, 85 reads

Posted in SQLStudies on 10 April 2014

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. Add that to the comment “Mess with your co-workers” and I was hooked on this one. T-SQL Tuesday this month is hosted by Matt Velic (b/t)… Read more

4 comments, 732 reads

Posted in SQLStudies on 8 April 2014

Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move even farther into the cloud. Microsoft’s new CEO Satya Nadella announced this morning

“We felt that by creating such an elaborate prank it would soften the blow. Microsoft will no…

Read more

4 comments, 225 reads

Posted in SQLStudies on 1 April 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, 79 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, 870 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, 99 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, 108 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, 104 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

0 comments, 106 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, 389 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, 79 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, 134 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, 245 reads

Posted in SQLStudies on 3 March 2014

Impersonating a server level permission

Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s really easy to shoot yourself in the foot here, so be careful!

Impersonation allows you to grant a user the ability to mimic another user and gain access to all… Read more

2 comments, 1,008 reads

Posted in SQLStudies on 26 February 2014

What’s the difference between a temp table and a table variable?

I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the most complete answers to this question I have ever seen. In fact it’s probably one of the most complete answers possible. I highly recommend that you read it. In… Read more

2 comments, 273 reads

Posted in SQLStudies on 24 February 2014

Finally added a (t) to my (b)

I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter. @sqlstudent144

Howdy #sqlfamily. Say hi if you get a chance!


Filed under: SQLServerPedia Syndication, Uncategorized

Read more

0 comments, 115 reads

Posted in SQLStudies on 20 February 2014

Getting a query plan

Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware that there are two different types of query plans. There are Estimated and Actual query plans (also called Execution Plans). Estimated and Actual query plans have the following differences:

An… Read more

0 comments, 481 reads

Posted in SQLStudies on 19 February 2014

DBA Myths: An index on a bit column will never be used.

Not true. (Or I guess probably wouldn’t be posting about it would I?)

Probably the first thing I should point out is that just because you can doesn’t mean you should. I can only think of a few very edge cases where an index on just a bit column would… Read more

4 comments, 1,608 reads

Posted in SQLStudies on 17 February 2014

Older posts