SQL Server with Mr. Denny:

SQL


December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance



Posted by: Denny Cherry
Clustering, SQL

This question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum. There's no way to easily flip a standalone SQL Server instance to a clustered instance.  However moving a standalone...

December 17, 2009  11:00 AM

CXPacket isn’t the cause, it is a symptom



Posted by: Denny Cherry
SQL

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.


December 14, 2009  11:00 AM

Beware of Diskeeper 10 on your servers



Posted by: Denny Cherry
SQL, Testing

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.


December 10, 2009  11:00 AM

Transaction Log files are not safe to delete



Posted by: Denny Cherry
Recovery, SQL

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.


November 30, 2009  11:00 AM

OPENXML can be a beast sometimes.



Posted by: Denny Cherry
OPENXML, Performance Problems, SQL, Table Variables

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


November 23, 2009  11:00 AM

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



Posted by: Denny Cherry
Clustering, Migration, SQL

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


October 29, 2009  11:00 AM

Auto shrink is just pure evil



Posted by: Denny Cherry
SQL

If you don't agree with the above statement please keep reading.  I'm write, and it's important, I promise. In order for the auto-shrink feature to be really effective it has to move data from the end of the file to the middle/front of the file so that it can chop off the tail end of the...


October 26, 2009  11:00 AM

I’ve got some money for an upgrade, what should I upgrade?



Posted by: Denny Cherry
RAM, Server Hardware, SQL

So you are going along your normal day, and your boss comes up to you and tells you "We've got a few thousand bucks left in this years budget, what would you like to upgrade?"  Assuming that new 26" monitors for your workstation are out of the question, the boss is probably talking about a server...


October 22, 2009  11:00 AM

How do you know when it’s time to refactor that database design?



Posted by: Denny Cherry
Social Commentary, SQL

Software developers love re-factoring code.  And why shouldn't they.  It's quick (sometimes) and when done correctly it'll reduce the amount of code, and speed up application response time.  DBAs like re-factoring code as well.  We get the same benefits when done correctly.  Re-factoring the...


October 19, 2009  11:00 AM

Hey sysadmins, quit trying to virtualize everything!



Posted by: Denny Cherry
SQL, Virtualization, VMware

Please forward this to the systems admin in your life that wants to take your big SQL Server, and cram it into a Virtual Machine against your wishes. So you've got your kick ass virtualization project moving along nicely, but you've hit a snag.  The DBAs are fighting back saying that they don't...


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: