Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


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


I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even though it’s pretty basic most people I talk to have never heard of it. The format is

dividend % divisor = remainder

DECLARE @remainder INT
DECLARE @dividend INT = 10…

Read more

5 comments, 153 reads

Posted in SQLStudies on 14 April 2016

The risks of Delayed Durability

It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about our favorite SQL Server feature. Great topic, but a really difficult choice. There are so many great features of SQL Server.
Some of my favorites include: Read more

0 comments, 906 reads

Posted in SQLStudies on 12 April 2016

Name the schema when you create an object (or else)

This is one of those frequently ignored best practices.

When you create an object, specify the schema where it will be created.

I should also point out

When you reference an object (in a query for example), specify it’s schema.

I know I have a tendency to forget this myself.… Read more

1 comments, 171 reads

Posted in SQLStudies on 6 April 2016

Complex/Conditional ORDER BYs

Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed. Sometimes though it’s faster and easier to let SQL handle the sorting for you. And that’s fine. SQL is very good at sorting.

Simple sorts are pretty easy. In the… Read more

1 comments, 198 reads

Posted in SQLStudies on 4 April 2016

Hidden code in AdventureWorks

I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t wait until the time I usually post.

So if you take the x character of the first character column of each table (where x is object_id % len(column) ), merge… Read more

4 comments, 213 reads

Posted in SQLStudies on 1 April 2016

When should I test?

To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the question posted here. It’s a big question so let’s break it down a bit.


You have a system and are about to upgrade some or all of it.… Read more

1 comments, 172 reads

Posted in SQLStudies on 30 March 2016

Why you shouldn’t use SELECT *

I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?) and I was pleased with how the answer turned out. In particular one piece (expanded a bit) seemed like it would make a good blog post.

To start with here… Read more

1 comments, 168 reads

Posted in SQLStudies on 28 March 2016

I’m presenting for the Pass Security Virtual Chapter!

Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. If you are interested in SQL Server database security and have little to no experience with it then this is the session for you! Heck even if you do… Read more

1 comments, 168 reads

Posted in SQLStudies on 23 March 2016

TOP 1 killed my performance; Rob Farley helped me resurrect it.

tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if you are in a hurry. If you have the time however, it’s a great walk through of tuning a query.

I had a great time today. I was handed a… Read more

10 comments, 3,833 reads

Posted in SQLStudies on 21 March 2016

What permissions do I need?

Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it can be a little confusing to be honest. Most of the time though it’s all there in front of you in black and white.

Where you might ask? Books on… Read more

0 comments, 191 reads

Posted in SQLStudies on 16 March 2016

Pulling data from a non-clustered index

This is one of those things that I found very interesting but figured I’d probably never really use. Of course then I needed it recently and it came in quite handy.

A while back Steve Stedman (b/t) started the database corruption challange. In the very… Read more

1 comments, 171 reads

Posted in SQLStudies on 14 March 2016

You don’t need to be a sysadmin

Hey, I need sysadmin access to ServerA.

Ok. Why do you need sysadmin?

Well I need to be able to read and write to all of the tables on DatabaseA.

No problem. I’m going to add you to the db_datareader and db_datawriter roles on DatabaseA. Done.
So, why do you… Read more

10 comments, 1,839 reads

Posted in SQLStudies on 10 March 2016

Ever wonder what that goofy query in the header means?

It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited us to talk about Text. Text. What an interesting subject. So much of our jobs is all about searching for and manipulating text.

When I… Read more

4 comments, 840 reads

Posted in SQLStudies on 8 March 2016

How do I grant someone the ability to create a stored procedure?

The question of How to grant the ability to create/alter stored procedures and views came up today on It’s actually a question I’ve pondered in the past. There are two major methods to do this.

The Scalpel

If you’ve looked at the permissions available in SQL Server you’ll have… Read more

1 comments, 1,834 reads

Posted in SQLStudies on 2 March 2016

Blogger questions: How often should I blog?

What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again) and there is one thing that seems to come up over and over again.

How often should I blog?

Let’s start with how often I blog. I post twice a… Read more

9 comments, 572 reads

Posted in SQLStudies on 29 February 2016

Powershell script to create multiple SQL Server Connections

As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is better than sp_who. Particularly when you have a large number of connections. Well in order to do that I need a large number of… Read more

1 comments, 275 reads

Posted in SQLStudies on 24 February 2016

You are not logged on as the database owner or system administrator.

I had one of my developers ask me why he keeps seeing the following warning when he tries to modify a table:

Well just like it says he doesn’t have dbo access so he might not be able to save his changes.

Let’s start by creating a user with the… Read more

0 comments, 188 reads

Posted in SQLStudies on 22 February 2016

Take caution when altering a column using TSQL

When developing in SQL Server you are eventually going to have to modify a column or two (at least). And if you use T-SQL to make the modifications (and I would recommend it most of the time) there is something you need to watch out for.

First remember that when… Read more

1 comments, 3,524 reads

Posted in SQLStudies on 17 February 2016

varchar(1) VS char(1)

The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?)

varchar(1) Really? It’s going to be one of those kinds of days.

It started a rather amusing conversation over using varchar(1) vs char(1) and I thought it might be helpful to go over… Read more

3 comments, 1,054 reads

Posted in SQLStudies on 15 February 2016

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts. Because of that I’m not going to talk about the correct methods of dealing with a transaction log full error. What I want to discuss is why… Read more

3 comments, 243 reads

Posted in SQLStudies on 10 February 2016

Newer posts

Older posts