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,515 reads
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,515 reads
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
7,105 reads
By SQLPals
How To Gain Access To SQL Server When No DBA ...
By Steve Jones
Flyway is a command line tool with lots of options and parameters. Working with...
Gurus, there is a table which is very slow to query , it has...
Hi. I have a query that returns few rows (out of 7 table join,...
By Stewart "Arturius" Campbell
We are working on a project to migrate a client from a version of...