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: February 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,240 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, 523 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, 184 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, 618 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,838 reads

Posted in SQLStudies on 17 February 2014

T-SQL Tuesday #51: Doubledown disaster

Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.

It’s always a gamble when buying a new piece of software. You pay your money, you throw the dice and you hope that you didn’t just buy a POS (Piece Of non-functioning Software). However there are… Read more

3 comments, 920 reads

Posted in SQLStudies on 11 February 2014

Check your SQL Agent history settings before it’s too late!

A little while back I was doing some research into a failed job and ran into a slight problem. The Agent history settings were such that I was only seeing the last 2-3 runs of the job. This job is run “on demand” and I really wanted to see the… Read more

3 comments, 220 reads

Posted in SQLStudies on 10 February 2014

Transactions: What commands aren’t allowed?

Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put inside a transaction. There are a handful of commands that won’t work inside a transaction. CREATE, ALTER and DROP DATABASE for example. The full list of commands can be… Read more

0 comments, 2,809 reads

Posted in SQLStudies on 5 February 2014

Transactions: Creating a single restore point across multiple databases.

This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple databases. If you have read up much on either the BEGIN TRANSACTION or RESTORE statements you will probably have noticed the MARK option. If you mark a transaction in the… Read more

0 comments, 520 reads

Posted in SQLStudies on 2 February 2014