I wrote this to allow me to send a priority list of int ids.This takes a "," seperated list of integers and puts them into a table, along with an [insorder] field that allows you to sort them.eg 2,6,3,1,7 becomesints insorder ---- --------1 72 13 56 37 9Depending on what […]
2003-09-01
106 reads
SQL2000 only.We use the attached script to schedule a SQL Agent job that sets up a Profile trace looking for long queries, and hourly imports them into a table. This way we can historically (but with some degree of real time) look to see what queries put a load on the system. We then allow […]
2003-08-23
1,505 reads
This a script to compare two parallel data streams, in my case production and QA. Two extracts were created and a mapping table was created as a look-up between old and new recordids. A final table TestResults was created to hold the results of the comparison. The comparison table names and join syntax are controlled […]
2003-08-21
180 reads
A stored procedure and two functions that given a path, a date and a file extension will do one of the following:-Delete all files of the supplied extension in that directory before a certain date.-Delete everything before the last full backup.I use this because disk space is tight and maintenance plans seem to delete old […]
2003-08-21
743 reads
This script will display the defragmentation of table(s) all indexes of selected tables and display a table/list of the DBCC SHOWCONTIG. It will aslo will report if there are tables in the list that can't be found in the current database. Run the script in the database where the tables you want to check are.Check […]
2003-08-21
827 reads
This script to designed to kill all connections for all users to a specified database. This is used in conjunction with an automated QA/Dev database restore/refresh process run as a DTS job.
2003-08-21
753 reads
This script will record all the rows in all tables of the database it's run on. Then, at each execution, it will compare the rows to what they originally were and display those that are different (inserts or deletes):
2003-08-20
328 reads
This uses info in backup tables to display growth of datafiles (LDF and MDF) and actual datagrowth (backupsize) over a period of time. Replace parameter values with name of your database and date from when you want info displayed. Results are best viewed in grid.
2003-08-20
423 reads
This function takes a pattern to be searched for, a string that the pattern will be removed from and a flag to determine whether all instances of the pattern should be removed.This is sort of an expanded version of a function I wrote to remove multiple spaces from a string.
2003-08-20
214 reads
SQL 2000's sp_MSForEachDB and sp_MSForEachTable are useful procedures for performing operations against multiple objects; however, they aren't always extremely efficient, because internally they use cursors to do their work.These 2 sprocs, sp_ForEachDB and sp_ForEachTable, perform many of the same tasks as their Microsoft-shipped twins, but run faster because they dynamically build the SQL string without […]
2003-08-19
2,317 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Communication, For Incidents and Life
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item Building a Support Ticket Triage...
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers