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
416 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
669 reads
2001-08-22
384 reads
2001-08-22
729 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,679 reads
Blogs
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video...
T-SQL Tuesday #185–Being a Video Star
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
Building Resilience: Leadership Insights from Sports
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
Forums
Snapshot Replication: Pre-application script to check prerequisites
Is it possible to write a script that checks a subscriber's environment for prerequisites...
t-SQL help..
I have the following...anyone can point me the right direction to rewrite this code?...
install sql express
I yesterday dowload a sqlexpress and intalled on one of a testing database for...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers