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,304 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,304 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,016 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is one of those things that on hindsight was a stupid problem, but...
Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...
Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....
OK so I have a customer with a hosted website with eCommerce options. Essentially...