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
407 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
660 reads
2001-08-22
373 reads
2001-08-22
722 reads
Optimize Character Field Usage
This stored procedure was designed to scan all your character based columns in a particular database and show the minimum, maximum and average data length. As well as give an efficiency rating of the data stored. Input: None Output: Table name, Column name, Defined datatype and length, Average length of data for that column, Minimum […]
2001-08-10
1,669 reads
Blogs
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Common Mistakes in SQL Server – Part 2
The Identity property creates an incremental value for the specified column automatically, which is...
Forums
Identifying the process that is backing the databases to virtual device
We have about 20 SQL Servers. We use Net backup or Native backup for...
SQL Migration - Identifying Connections - Best approach
I have one SQL Database server which is old version and planning to migrate...
Restore With Standby; A Review and A Lesson Learned
Comments posted to this topic are about the item Restore With Standby; A Review...
Ask SSC