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: December 2013

The 12 days after release

On the first day after release my developer gave to me

  • a performance problem on a crucial query

 

On the second day after release my developer gave to me

  • 2 deadlocked queries
  • and a performance problem on a crucial query

 

On the third day after release my developer… Read more

3 comments, 319 reads

Posted in SQLStudies on 24 December 2013

SSMS Shortcuts and more

I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs. Not sure if they are the same for everyone but for me it included Grant Fritchey’s SQL Server Execution Plans 2nd Edition which I highly recommend. It also included a… Read more

0 comments, 208 reads

Posted in SQLStudies on 23 December 2013

Transactions: Rolling back part of a transaction.

In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way to the top level. If that is the case then can we roll back an inner transaction and still maintain and commit the rest of the transaction? Yes as… Read more

0 comments, 253 reads

Posted in SQLStudies on 19 December 2013

Transactions: Rolling back a nested transaction

Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID). And if we use an explicit transaction (created by BEGIN TRANSACTION) and we make a mistake we can always roll the transaction back. Unfortunately rolling back a transaction and committing… Read more

0 comments, 787 reads

Posted in SQLStudies on 17 December 2013

T-SQL Tuesday #49: Wait for it

It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. As in, why am I having to wait for my query to finish. Or more specifically what is my query waiting for. Waits are a popular subject. You can… Read more

3 comments, 239 reads

Posted in SQLStudies on 10 December 2013

Undocumented functionality in FORMATMESSAGE

I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is an interesting read in and of itself) and noticed something interesting in the OP’s example.

FORMATMESSAGE('Procedure input %s is wrong', @ProcParam)

That’s pretty cool. I remember using… Read more

0 comments, 446 reads

Posted in SQLStudies on 9 December 2013

Insert into a table using only default values

A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value without having to specify an actual value. Well along that same note, what do you do if you want all of the columns to use their defaults? Or if you… Read more

3 comments, 219 reads

Posted in SQLStudies on 4 December 2013

Why do DBAs like to say “It Depends” so much?

Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice that “it depends” is almost always followed by a series of questions. This is very similar to the Chaos theory that as I understand it basically says that if you… Read more

0 comments, 180 reads

Posted in SQLStudies on 2 December 2013