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,352 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,116 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
718 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)
667 reads
Blogs
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
Forums
Alamat Telp BCA KCU SIDOARJO (+62) 838-4945-0961
Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Layanan BCA KCU TASIKMALAYA Telp:0817°82°5533
Telp/Wa 62817825533 Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kota Tasikmalaya, Jawa Barat 46124
Layanan BCA KCU PURWAKARTA Telp:0821°8200°203
Telp/Wa 628218200203 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta,...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers