This script creates a stored procedure that shows you a list of all the users that are locking objects on the database with mode X. It shows a full and detailed description on the user and object locked.
2001-09-06
1,475 reads
This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user […]
2001-09-06
4,602 reads
This stored procedure, updates the schema version of user table(s), which in turn marks the Stored Procedures and Triggers for recompile.
2001-09-05
1,427 reads
Display any stored procedures using input and output parameters. I took the view, PARAMETERS that ships with SQL 2000 and cleaned it up a bit.
2001-09-04
1,267 reads
2001-09-04
551 reads
There may be cases where you want to work with delimited strings in T-SQL. Following two examples will cover most of the stuff that you will face while working with strings.
2001-09-01
3,202 reads
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,237 reads
This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,144 reads
2001-08-26
1,429 reads
2001-08-22
415 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers