Recently we added a new hard disk array to one of our dedicated RackSpace servers in order to migrate all the database files to it. Here's a quick way to move database and log files to a new location on the same server with very little downtime.

Each time you perform an insert, update or delete operation on a database table it also affects the indexes for that particular table. If you need to bulk load or delete a mass of data from a highly i...

In a single server configuration you might want to use a session state server in order to facilitate restarting Internet Information Services (IIS) without killing all active Web site sessions. In a s...

If you need to literally escape either percent or underscore characters in your T-SQL like clause, then you would escape them with square brackets.