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.
2010-09-21
9,104 reads
David Baffaleuf
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.
2010-07-20
6,956 reads
Blogs
Daily Coping 27 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
Forums
Tlog migration
Hi Expert, In tlog migration, from 1 server to another where there is no...
RegisterAllProvidersIP = 0 and timeout in failover
Good morning all , I have an alwayson instance with a multisubnet listener I...
Tempdb increasing crazily
These days, the Tempdb of my one's SQL server increases crazily, sometimes only abount...
Ask SSC