Takes a simple string of delimited values, and returns a table type of the values stripped out. This can be easily incorporated in existing SQL statements utilising standard joins. Classic example of a UDF returning the TABLE data type.
2003-08-10
429 reads
Displays the hit ratio of the buffer, procedure and log caches. Does not check for div by zero as I am lazy. Tested on SS2k (any SP).
2002-01-15
903 reads
Using the the MSDB backup tables, will generate the basic disk RESTORE commands for a database. It will include the Full, differential and all associated log recovery commands for you. Run the stored proc in Query Analyser then copy/alter the output to recover your DB. Great if using EE is not your cup of tea. […]
2002-01-03
383 reads
Basic summary of all successful backups to date in descending date and ascending DB name order.
2002-01-03
553 reads
For all tables in the current database, it will script the DBCC command to reset the identity seed to 1 for all columns using them. Very handy for data migration.
2002-01-01
848 reads
Here are two stored procedures for enabling and disabling all keys (primary and foreign) for a specified database. It makes sure the database specified is not the system databases and the users session is at the DB to have its keys enables/disabled.
2001-09-19
847 reads
Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code […]
2001-08-09
3,570 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers