This script will run through the foreign keys on tables to produce a hierarchy of the tables in a database.This is useful when you need to purge and repopulate test databases with foreign key contraints
2002-07-24
2,151 reads
Given database, owner, table, and column names, this procedure returns one from among several column attributes such as type definition, defaults, and other types of constraints. E.g., to retrieve the type definition of the 'pubs' database's 'author.address':DECLARE @attrib VARCHAR (500) , @msg VARCHAR (8000)EXEC p_get_column_attribute 'TYPEDEF' […]
2002-07-24
162 reads
Scalar function 'f_contains' counts the number of times the first argument occurs within the second argument.Given: @arg1, @arg2 (both VARCHAR), @cnt INTSELECT @cnt = dbo.f_contains (@f_search_for = @arg1 , @f_container = @arg2)
2002-07-22
413 reads
Scalar function 'f_delimited' slices out of a passed-in string, from a specified position inside the string, that segment of it which is delimited on one or both sides by a specified delimiter.Example: Print out a segment of a 'syscomments.text' column for a stored procedure 'p_proc', representing a line of code (i.e., the segment of 'syscomments.text' […]
2002-07-22
149 reads
Procedure 'p_find_string' allows users to specify any database on a server in searching for a specified character string. Supported for string-searching: table columns, view columns, trigger, function, and procedure code. Produces a report showing: object type, owner, object name, column id (for tables and views) or what line number (for triggers, functions, and procedures), and […]
2002-07-22
172 reads
Let's say you have 2 tables: a Contacts table and a PhoneNumbers table (which stores all the phone numbers for each contact). You are asked to write a query that returns each contact's name and a comma-delimited string of phone numbers for each contact, something like this:FirstName LastName PhoneNumbers--------- -------- --------------------------John […]
2002-07-22
1,075 reads
Using a Having clause I eliminate getting the EVEN rows and getting ovly the odd primary keysBy using Having (count(*) %2) = 0 I will get the even and not the odd.
2002-07-20
356 reads
Introduction:SQL Server 7.0 introduced a new class of functions that return a wide range of property information that isn't readily available in SQL Server 6.5 and earlier versions. These functions have three general classes: TypeProperty, which returns information about a data type; ObjectProperty, which returns information about objects in the current database; and ColumnProperty, which […]
2002-07-19
168 reads
2002-07-19
608 reads
This script will provide the first four values required for estimating the size of a database table. It will satisfy steps one and two in MS estimation process for the amount of space required to store the data in a MS SQL Server v7.0 or v2000 table:1 Specify the number of rows present in the […]
2002-07-19
530 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Comments posted to this topic are about the item SQL Server Vector Support II
Comments posted to this topic are about the item Great Things
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers