SQL Server with Mr. Denny

December 17, 2009  11:00 AM

CXPacket isn’t the cause, it is a symptom

Denny Cherry Denny Cherry Profile: Denny Cherry

All to often when people deal with parallel queries they see that some threads of the query have a wait type of CXPacket so they assume that the parallel execution plan is causing a problem, but it probably isn’t.

Continued »

December 14, 2009  11:00 AM

Beware of Diskeeper 10 on your servers

Denny Cherry Denny Cherry Profile: Denny Cherry

Everyone likes nice defragmented SQL Servers.  However if you use Diskeeper to do so be very careful before you upgrade to the new version 10, or if you are going to upgrade to the new version 10 you’ll need to make a small change to your configuration on each SQL Server.

Continued »

December 10, 2009  11:00 AM

Transaction Log files are not safe to delete

Denny Cherry Denny Cherry Profile: Denny Cherry

All to often I see people online saying that they detach a database then delete the log file to shrink it.  This is a very dangerous operation which can leave you with a corrupt database that you can’t do anything with. Continued »

December 7, 2009  11:00 AM

What you can and can’t do with SAN replication

Denny Cherry Denny Cherry Profile: Denny Cherry

SAN replication is a very power tool which will let you get real time (or near real time) backups of your database on another location on your storage array, to another storage array at the local site, or to a remote storage array at another site.

However like all technologies there are some things which it is really good at, and some things which it can’t/shouldn’t be used for.  (Everything here is going to be SAN vendor dependent.  This includes features, modules you have to buy, terminology, and probably some other stuff I’m not thinking of.) Continued »

December 3, 2009  11:00 AM

Dual HBAs (or iSCSI ports) should be a requirement for every server

Denny Cherry Denny Cherry Profile: Denny Cherry

Proper network design is very important to ensuring the highest availability between your storage array and your server.  This design is important weither you are using a Fibre Channel SAN or an iSCSI SAN.  The basic design is the same. Continued »

November 30, 2009  11:00 AM

OPENXML can be a beast sometimes.

Denny Cherry Denny Cherry Profile: Denny Cherry

Our application includes some search functionality which is pretty complex to deal with.  In a nutshell the user can select multiple values from a couple of lists on the website and use those listed to filter down the rows which are being searched.  These lists are passed into the SQL Server as a couple of XML documents.  We recently had a larger customer call and complain that the search was slow.  I fired up profiler and grabbed the query.  They were right, 6 minutes is a long time for a query to take. Continued »

November 26, 2009  11:00 AM

Windows 2008 R2 Active Directory Enhancements

Denny Cherry Denny Cherry Profile: Denny Cherry

What server upgrade would be complete without some Active Directory enhancements?  This release is no exception.

One of the best enhancements (in my opionion) is that Active Directory now has a recycle bin.  Continued »

November 23, 2009  11:00 AM

Moving a standalone instance to a cluster while keeping the name and IP

Denny Cherry Denny Cherry Profile: Denny Cherry

A little while back I posted about how to move a standalone instance to a clustered instance using a different name and IP, but what do you do when you need to keep the same name and IP address?  This is a much more complex procedure to complete. Continued »

November 18, 2009  11:00 AM

Slide decks for the San Gabrial Valley .NET User Group and SoCal Code Camp

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve got 4 presentations and two different events so I’m posting everything in a single post.

On Wednesday I’ll be presenting at the San Gabrial Valley .NET User Group.  I’ll be giving my SQL Service Broker presentation.

Then this weekend at the SoCal Code Camp I’ll be giving three presentations.  The first one is Reading the SQL Server Execution Plan, the second is SQL Server Indexing for the Client Developer and the third is Storage for the DBA.

Feel free to download the slide decks ahead and time.


November 16, 2009  11:00 AM

Not all multi-pathing software is created equal

Denny Cherry Denny Cherry Profile: Denny Cherry

Once you’ve setup a good redundant network design you need to invenst in some goo multi-pathing software to ensure that you are making the most of the redundant network that you have created. Continued »

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: