2003-01-14
119 reads
Scripts
UDF to find Service Pack version
This UDF returns the Service Pack versionprint dbo.ServicePackversion()
2003-01-14
141 reads
SP to determine database file growth at intervals
I wrote this SP to be run from a job every night. Change the myDB reference to be a database on your system for DBA use.I just set up a job to run:Exec sp_CatchFileChangesThen I run in another step:Select * from mydb.dbo.tbl_sysaltfiles_3and output to a log file.Alternatively you could insert into another table with a […]
2003-01-13
336 reads
Inherriting objects from an updated MODEL database
If new objects are created in the model database then these new objects only get created for new databases.Similarly, if objects are removed from user databases then getting them back into the database can be a pain.The following two stored procs copy objects from model to the current database if they do not already exist.
2003-01-10
64 reads
Calculate Earth global distances
I wrote this sp to be able to calculate the distance between two locations on the earth if the latitude and longitude is known for each. Could be useful for GPS work or maps.Usage:If I know the following city locations:Sydney 151.2 E 33.87 SCanberra 149.15 E […]
2003-01-09
830 reads
Check if batch is running.
WARNING: This is resource intensive. Don't use except as a last resort.I wrote this to be able to find if a TSQL batch is running already on a SQL Server. I use this rarely when I have to know to prevent running something twice.Usage:DECLARE @RC intDECLARE @SQLBatch nvarchar(255)-- Set parameter valuesEXEC @RC = [master].[dbo].[sp_RunningCheck] @SQLBatch […]
2003-01-09
444 reads
Convert Degrees Minutes Seconds to Decimal UDF
I wrote this function to work with my sp_EarthDistance stored procedure.It converts the regular degrees/minutes/seconds representation of angles to a decimal number.Remember to use '' instead of ' within a string to be treated a character and not an end quote.Sydney location 151¦12'0 "E 33¦52'0 "S and in […]
2003-01-09
863 reads
Search All Columns in All Tables for a string
This procedure can search all columns in one or all tables for a specified string. Prints out the TableName.ColumnName that the string is found in...-- Example Calls-- EXECUTE spFindTextInColumns MyTable, 'tcart' --search a specific table-- -- EXECUTE spFindTextInColumns default, 'tcart' --search all tables BUG FIX : (2003/01/20) Changed SELECT @columnName […]
2003-01-09
993 reads
Get row counts and space used for every table
Use the sp_MSforeachtable stored procedure to run the sp_spaceused stored procedure for every table in a database
2003-01-08
143 reads
Updating Changed Passwords for warm Servers
One of the challenges weve faced is changing passwords in a warm server to reflect changes made to the live server. The initial transfer of users and passwords was performed by the sp_help_revlogin script provided by Microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;246133. The difficulty with this script was once the users are in place, you cant sync changed […]
2003-01-08
186 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers