This scripts allows to store all tables names in all databases for the current server, it stores also the creation date, this script can be runned ins SQL Server 2000 or later
2012-07-02 (first published: 2012-06-25)
1,515 reads
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,509 reads
Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.
2012-06-28 (first published: 2012-06-06)
715 reads
2012-06-26 (first published: 2012-06-07)
1,469 reads
This script will search the entire server and give the name and schema of the database where the table exists.
2012-06-25 (first published: 2012-06-09)
1,488 reads
This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.
2012-06-22 (first published: 2012-06-09)
1,997 reads
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,256 reads
2012-06-20 (first published: 2012-05-30)
8,773 reads
A script to help you find the Precision & Scale parts of a decimal value.
2012-06-19 (first published: 2012-06-04)
5,015 reads
Generate a script of insert statements with column names for any table including those with identity columns.
2012-06-15 (first published: 2012-05-22)
3,151 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 Stored Procedures for Server-Level Object...
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
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