In a recent project, I need to record audit trail for some tables (for Insert, Update and Delete).Using SQL 2005's XML datatype and the XML support it is very covenienet to use triggers to perform the audit trail requirement. I create one table (Table_Audit) to hold all audit trial data. One stored procedure is created […]
2007-09-20
3,329 reads
This is how I pull record counts for every user table in a DB... some of my tables are very large and this works for table with our without index very fast.
2007-09-20 (first published: 2007-05-24)
2,971 reads
This script will DELETE ALL constraints within the database that you define and in the following order: Foreign Key, Primary Key and then Unique Key.CAUTION:This script does not print out the ALTER TABLE statements, it drop the constraints immediately, therefore backup your database before testing or using this script. I ran the script below and […]
2007-09-19 (first published: 2007-05-23)
4,101 reads
I made some modifications to D Simmon's original sp. 1. I added dynamic feature to query tables in other databases (not linked servers) from one sp. I know dynamic sql isn't preferable in most cases but this is the route I took for this. 2. I enabled table name to be sent with owner qualification […]
2007-09-18 (first published: 2007-05-22)
618 reads
An easy way to created a quick record count of all the tables within a sql server database.
2007-09-18
710 reads
Many times with work with unknown databases, most of the time there is not a clear documentation of the relations between tables, however, with this script we are able to find the parent child relations in just a few seconds
2007-09-18
1,007 reads
2007-09-17 (first published: 2007-05-18)
655 reads
The following script performs log, differential or full backups of a single, or all databases on your SQL Server. It then copies or moves the file(s) over to a network share drive. It also removes old backups from both locations if needed. Don't forget to set the local drive path and network share for each […]
2007-09-14 (first published: 2007-05-16)
19,184 reads
We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/
2007-09-14
3,828 reads
This script was designed to restore a backup of a SQL Server 2000 database from disk file to SQL Server 2005.Unfortunatelly the RESTORE will leave land mines for you to find the hard way, this script was updated to fix all that I have found:Change CONCAT_NULL_YIELDS_NULL ON, PAGE_VERIFY CHECKSUM, Compatibility level to 90, remove the […]
2007-09-14
4,533 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
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