-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: October 2014

Playing with the log – Before the first full backup

The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from… Read more

1 comments, 1,204 reads

Posted in SQLStudies on 29 October 2014

A script to list the DTS connection information for every package on the instance.

For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest of us who are still dealing with DTS packages I’m going to do a couple of posts on the subject. To start with here’s a script for collecting all… Read more

0 comments, 400 reads

Posted in SQLStudies on 27 October 2014

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures.

In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can be some combination of coach, assistant coach… Read more

1 comments, 6,170 reads

Posted in SQLStudies on 22 October 2014

Update to “The clustered index columns are in all of the non clustered indexes.”

I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. So I did some additional testing, confirmed a few things with Paul Randal (b/t)… Read more

5 comments, 5,846 reads

Posted in SQLStudies on 20 October 2014

UNION vs UNION ALL

You might be wondering why I’m going into such a simple subject. Well the way I see it there are four options here.

  • You already know the difference, it seems really obvious and you are probably wondering why I’m mentioning it.
  • You think you know the difference but it turns…

Read more

6 comments, 1,994 reads

Posted in SQLStudies on 16 October 2014

TSQL Tuesday #59: My Hero, My Inspiration, My Wife

TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t) is hosting and wants us to talk about Heroes.

I have to admit this isn’t something I think about much. I have… Read more

0 comments, 935 reads

Posted in SQLStudies on 14 October 2014

Required reading before upgrading SQL Server.

I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q & A someone asked about jumping from SQL 2005 up to 2014. This immediately got me to thinking about the Breaking Changes pages that Microsoft puts… Read more

4 comments, 1,068 reads

Posted in SQLStudies on 8 October 2014

You can’t use aggregate/windowing functions with CROSS APPLY

One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well recently I was working on performance tuning a rather annoying query (which I will blog about in more detail later) and one of the steps I took was an… Read more

10 comments, 8,545 reads

Posted in SQLStudies on 6 October 2014

Intro to Auditing in SQL Server on SQL Shack

I had an article published yesterday on http://www.SQLShack.com.

Intro to Auditing in SQL Server.

It’s worth reading if I do say so myself. In it I go through several different methods for generating data that might be required by an auditor. I range from adding auditing columns to each… Read more

0 comments, 701 reads

Posted in SQLStudies on 1 October 2014