SQL Server with Mr. Denny:

SQL Server


September 17, 2009  11:00 AM

Dates can easily be the hardest datatype to work with.



Posted by: Denny Cherry
Index Performance, Index Scan, Index Seek, Indexing, T/SQL

The datetime data type can be one of the hardest to work with when it comes to index optimization.  Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value.  Most people handle this via a convert function around the date...

September 14, 2009  5:24 PM

SQL Server Clustering Guide & Webcast Links



Posted by: Denny Cherry
iSCSI, SQL Server 2008, Starwind, Webcast

A white paper which I wrote for Starwind Software is now available.  The link to register for the webcast (October 21, 2009) has also been

Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 11, 2009  7:43 AM

South Bay .NET User Group, thanks for having me over.



Posted by: Denny Cherry
Extended Stored Procedure, In Person Events, Indexing, South Bay .NET User Group, Stored Procedures

Tonight I spoke at the South Bay .NET User Group.  I had a blast talking with them.  They are a great group of programmers. Continued »


September 9, 2009  1:55 AM

Whitepaper on why database maintenance is important



Posted by: Denny Cherry
Index Performance, Performance Problems, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, Statistics, White Paper

Today I'm publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy.


September 7, 2009  11:00 AM

Speaking at the South Bay .NET Users Group



Posted by: Denny Cherry
In Person Events, Indexing

On September 10th, 2009 I'll be speaking at the South Bay .NET Users Group in Torrance, CA. I'll be giving two presentations at the meeting.  First I'll be giving my "SQL Server Indexing for the Client Developer", and second I'll be giving my "What do all Those Undocumented Stored Procedures...


September 1, 2009  6:31 PM

SQL Server 2008 Clustering Article in SQL Server Magazine



Posted by: Denny Cherry
Article, Clustering, SQL Server 2008, SQL Server Magazine, Windows 2008

For those of you who haven't check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on...


August 31, 2009  6:26 PM

Difference between an Index and a Primary Key



Posted by: Denny Cherry
T/SQL

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  12:50 PM

Damn rollback scripts are a pain



Posted by: Denny Cherry
sys.tables, T/SQL

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 13, 2009  11:21 AM

Auto Close is almost as bad as auto grow



Posted by: Denny Cherry
Performance Problems, SQL Server

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



Posted by: Denny Cherry
Auto Grow, Performance Problems, SQL Server

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...


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: