A lot of table pivoting scripts use cursors to reach the desired results, but SQL scripting was developed to be utilized in a data set environment rather than sequential step-thru scripting.Normally, there are 3 types of Table Pivoting - 1) column explicit 2) column implicit and 3)single column. COLUMN EXPLICIT will place the row value […]
2003-05-29
457 reads
The excellent script contributed by G.R. Preethiviraj Kulasingham (Preethi) Sri Lanka (contributed 2/20/03, modified 5/22/03) identifies duplicate indexes for the database on which the script is run. It requires User Defined Functions, a feature restricted to SQL Server 2000.This version achieves similar results without using UDFs or creating any other permanent objects. It therefore works […]
2003-05-28
804 reads
Use SQL's own method to get the current DBName, no function needed.
2003-05-27
1,120 reads
This script creates the table ProfilerEventClass and populates it with the EventClasses and EventNames.This table is useful when working with trace tables, to get the event names by joining the tables on EventClass.
2003-05-25
606 reads
Retrieve the name of the current database for use with bcp and other procedures that require database name. This will help increase the portability of code and less maintenance required when migrating code to new database/server.
2003-05-22
245 reads
This script will create scripts for every database object. This makes it easy to check them in to VSS.Usage : DMOScriptDatabase 'Databasename','Directoryname'
2003-05-19
652 reads
This script will create scripts for every Table. This makes it easy to check them in to VSS.Usage : DMOScriptTables 'Databasename','Directoryname'
2003-05-19
938 reads
This script is actually based on a script by epol29. That was titled 'Script to count the number of Yes/No in the string', which I found to be an awsome script.Anyway, this script uses the same logic to deterimine if all of the characters in a field are the same. For example, 1111111, aaaaaaaa, 4444, […]
2003-05-19
185 reads
This script will list all the databases on your server (SQL2000 only) as well as their sizes and some key properties. Very useful for keeping rogue developers under control 🙂
2003-05-17
823 reads
This script forms a temporary table containing database and object names and IDS as well as object types for all databases for the server on which this scrip is executed. It is intended to serve as an interim step for additional server wide analysis.
2003-05-16
187 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