SQLServerCentral - Guest Columnist: David Baffaleuf

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 | 7,698 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,576 reads

Items 1 to 2 of 2