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
422 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
897 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
377 reads
Basic summary of all successful backups to date in descending date and ascending DB name order.
2002-01-03
543 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
837 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
833 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,555 reads
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....
Hi everyone I have a PowerShell script that is run by Execute Process Task...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers