SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: David Baffaleuf

SQLServerCentral.com profile

   Items 1 to 2 of 2   

fn_fixeddrives() : an alternative for xp_fixeddrives

The idea is to create a SQLCLR table valued function that returns all information on drives in a UNIX df-like style.  Read more...
By David Baffaleuf 2010/09/21 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 8,765 reads

Turn on CHECKSUM after an upgrade

When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.  Read more...
By David Baffaleuf 2010/07/20 | Source: SQLServerCentral.com | Category: page_verfify
Rating: |  Discuss |   Briefcase | 6,902 reads
   Items 1 to 2 of 2