December 10, 2009 11:00 AM
Posted by: Denny Cherry
Recovery,
SQLAll 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
Posted by: Denny Cherry
OPENXML,
Performance Problems,
SQL,
Table VariablesOur 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
Posted by: Denny Cherry
Clustering,
Migration,
SQLA 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
Posted by: Denny Cherry
SQLIf 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
Posted by: Denny Cherry
RAM,
Server Hardware,
SQLSo 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
Posted by: Denny Cherry
Social Commentary,
SQLSoftware 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
Posted by: Denny Cherry
SQL,
Virtualization,
VMwarePlease 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...
October 15, 2009 11:00 AM
Posted by: Denny Cherry
Index,
SQL,
T/SQL,
Unique IndexIf you work with any of the other big database platforms you've probably noticed that SQL Server's implementation of a unique index is "different" than the others. Until now there hasn't been a way to fix that without using a trigger. Until now...
October 13, 2009 9:33 PM
Posted by: Denny Cherry
In Person Events,
PASS,
SQLI posted a survey over on Security Fight Club to get some input from the SQL community. I need to know what color I should die my hair for SQL PASS. The survey will be open until shortly...
