Have you ever wanted to check that a server exists before using it. Here is a solution that use SQLDMO from within TSQL to get the status of a SQL Server service. It also works for 2000 instances. I have named it sp_ServerStatus for it to be based in master.This returns the status integer and […]
2002-11-14
620 reads
Do you want to use OPENXML with an xml document in a table, this procdure will do it for you.Pass in the SQL that will return the column of data, it will return the document handle which can then be used with OPENXML.ExampleDROP TABLE TabCREATE TABLE Tab (doc ntext)INSERT INTO Tab VALUES ('' + REPLICATE('' […]
2002-11-14
549 reads
This function and stored procedure can be used to easily identify if a file, directory or parent directory exist. It wraps the functionality of xp_fileExist but gives easy access to the directory and parent directory exist values.To use it the function pass in the file or path and either 'IsFile', 'IsDir' or 'HasParentDir' it will […]
2002-11-13
3,892 reads
The procedure copies one stored procedure from one database to another one
2002-11-12
733 reads
INSTR searches string for substring. --> position is an integer indicating the character of string where SQL Server begins the search. -->If position is negative, SQL Server counts and searches backward from the end of string. occurrence is an integer indicating which occurrence of string SQL Server should search for. The value of occurrence must […]
2002-11-12
1,378 reads
This stored proc has helped me a lot when I needed to restore db, reconfigure replication, and do other database jobs. SQL server KILL command can only act on a single spid. This sp compiles KILL commands in a cursor to kill a group of spids based on database name, login name, host machine name […]
2002-11-11
6,220 reads
Occassionally you might want to convert a binary number into some printable string. This would allow you display some meaning fully numbers hex characters, instead of just some unreadable garbage. This script takes a binary field, of basically any length, and converts it, character by character, to a character string. The character string will contain […]
2002-11-07
485 reads
This is a VBS script that will extract images from a Microsoft SQL database and create a individual file for each image. The script utilizes two important utilities: isqlw and textcopy (both standard executables that come with Microsoft SQL Server).
2002-11-07
1,739 reads
2002-11-05
604 reads
Below is a SQL Server 2000 query to return all columns that are primary keys to tables in a database
2002-11-01
242 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers