hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
528 reads
Scripts
hx_dbMaintancePlans
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
358 reads
2001-08-22
713 reads
hx_GetPKLessTables
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
411 reads
2001-08-22
540 reads
2001-08-22
697 reads
hx_OLEDBproviders
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
hx_ShowFixedDriveSpace
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
648 reads
2001-08-22
365 reads
2001-08-22
704 reads
Blogs
Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
Daily Coping 3 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 2 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Foreign key in the column values of another table
I have trouble in writing a SQL query. I have a data table with...
How to increase performance to load a factless date-date-interval table
Hi all, I am currently having performance issues by populating one of my factless...
Linked Server Error
Hi Experts, I am getting the following error when i am trying to test...
Ask SSC