SQL Server with Mr. Denny:

August, 2009


August 31, 2009  6:26 PM

Difference between an Index and a Primary Key

Denny Cherry Denny Cherry Profile: Denny Cherry

There seams to be some confusion between what a Primary Key is, and what an Index is and how they are used. The Primary Key is a logical object. By that I mean that is simply defines a set of properties on one column or a set of columns to require that the columns which make up the primary key...

August 26, 2009  3:34 PM

Clearing the Windows page file and its effect on server performance

Denny Cherry Denny Cherry Profile: Denny Cherry

I just published a new article over on SearchSQLServer.com about "Clearing the Windows page file and its effect on server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 26, 2009  12:50 PM

Damn rollback scripts are a pain

Denny Cherry Denny Cherry Profile: Denny Cherry

Writing release scripts for a database is easy.  What ever new objects you want you create you create, and what ever objects you need to change you change.  Piece of cake.  Rollback scripts however are a bit trickier since you need to know what everything should look like after the script is...


August 20, 2009  6:34 PM

Adding column to take taking to long? You’re probably assigning a default.

Denny Cherry Denny Cherry Profile: Denny Cherry

When you create a column on a database, and you put that column on the right of the table the column shouldn't be added almost instantly.  However if you are assigning a default value to the column and setting the column to now allow NULL values the operation will take quite a lot longer.  This...


August 17, 2009  11:33 AM

Learn to use the COPY_ONLY flag for one off backups

Denny Cherry Denny Cherry Profile: Denny Cherry

Taking a full backup when doing major database upgrades is a great idea.  However if you are taking differential backups this one off full backup will break the differential backup chain.


August 13, 2009  11:21 AM

Auto Close is almost as bad as auto grow

Denny Cherry Denny Cherry Profile: Denny Cherry

In theory the auto close setting is a great idea. Free up resources for other databases to use when all the users are finished with the database. In practice, its not so great.  If a single user connects and disconnects over and over (like say a single user using your website or even a few...


August 10, 2009  11:08 AM

Auto Grow is the bane of my existence

Denny Cherry Denny Cherry Profile: Denny Cherry

OK, that's not entirely true, but it's pretty damn close.  The auto grow feature of SQL Server shouldn't be counted on.  It should be disabled, or at least used on as an emergency basis only. Having the auto grow setting enabled will cause your database to grow when ever it needs to, not when...


August 7, 2009  5:22 PM

Slide Decks from OC SQL Users Group

Denny Cherry Denny Cherry Profile: Denny Cherry

Last night I presented two presentations for the Orange County SQL Server Users Group.  I started with my Virtualization presentation and my


August 6, 2009  11:02 AM

What do you mean I can’t access my own database when trying to attach it?

Denny Cherry Denny Cherry Profile: Denny Cherry

When you detach a database from Microsoft SQL (I'm talking SQL Server 2005 and up here) the SQL Server automatically changes the NTFS permissions on the file so that only the user who told the SQL Server to detach the file has access to them.  SQL Server does this to ensure that an unauthorized...


August 4, 2009  11:44 PM

Speaking at the Orange County SQL Users Group This Thursday

Denny Cherry Denny Cherry Profile: Denny Cherry

This Thursday I'll be speaking at the Orange County SQL Server Users Group.  The group meets at the New Horizons Computer Learning Center in Anaheim, CA which is at 1900 S. State College Blvd Suite 100. It's right behind Angles stadium, you can't miss it. We haven't decided on a topic yet,...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: