2001-08-22
708 reads
Scripts
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
409 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
663 reads
2001-08-22
374 reads
2001-08-22
723 reads
Idle Spid Time
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
940 reads
DBCC SHOWCONTIG in all Tables
Use this script to see showcontig for all tables in the context of the database in which its called. Very handy to schedule during off peak hours prior to any re-indexing to see how bad things are and re-build certain indexes sooner than you thought for peak performance.
2001-08-20
4,081 reads
Script to Zip a Backup File
A handy dandy proc that can be used to zip up a backup file to location specified. Also called from a backup script to automate the compression of all backups using PKZip command line utility. Make sure pkzip is in the path and found by the shell prior to using this script.
2001-08-20
3,715 reads
Script to Search SQL Error Log For a String
This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III
2001-08-13
1,897 reads
Show Fragmentation Before and After Reindex
This will show the fragmentation and stats before and after a reindex of a specified table. Run in the context for the db that holds the table the proc will get passed and re-index. Complile in master since the master is checked first for any SP that is prefixed with SP_ and you can call […]
2001-08-13
4,015 reads
Blogs
T-SQL Tuesday #174: Your Favorite Job Interview Question
My blog has been quiet lately. I recently wrapped up a master’s program (more...
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
T-SQL Tuesday 174 - Your Favorite Job Interview Questions
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
SSIS Connecting to Azure SQL Managed Instance w/ MFA
We've been testing out Azure SQL Managed Instance and created SSIS packages to run...
Summarizing Raw Sales Data with Group Summaries and Final Summary
Greetings, I need to transform data returned in a query from several tables as...
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers