Get Splitted Value From the String Format Specifie
Functuion Which returns splitted values from the string format specified in example
2007-09-21
280 reads
Scripts
proc to order xp_enumerrorlog
this is a quick stored procedure I put together when trying to find a log for a particular day (xp_enumerrorlogs returns the archive is as a varchar, so 1 is followed by 11, 12 etc rather than 2) sp_display_errorlogs with no parms returns output in archive id order. if the parm 'size' is passed in, […]
2007-09-21
835 reads
Reset Identity Columns
After migrating an Oracle database to SQL 2005, all the identity values were not properly set. This script goes through and sets them all to 1 greater than the max value in the identity column.
2007-09-21 (first published: 2007-05-24)
482 reads
A Simply way to implement Audit Trail in SQL 2005
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,350 reads
Get record count for every table in a DB (1 Step)
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,984 reads
Delete constraints - SQL Server 2005
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,114 reads
_Select Update
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)
631 reads
Database count using system tables
An easy way to created a quick record count of all the tables within a sql server database.
2007-09-18
717 reads
Find Parent Child RelationShip
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,026 reads
2007-09-17 (first published: 2007-05-18)
666 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers