Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,621 reads
Scripts
2012-07-03 (first published: 2012-06-21)
1,395 reads
Make a list of all tables in all data bases with creation date
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,532 reads
SQL 2005 - List Primary Key Columns
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,523 reads
Logshipping Backup Files Management
Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.
2012-06-28 (first published: 2012-06-06)
729 reads
2012-06-26 (first published: 2012-06-07)
1,492 reads
Script to Search Through all Databases for a Table Name
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,504 reads
The joy of sp_spaceused
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)
2,015 reads
Delete Duplicates in SQL 2000, SQL 2005, SQL 2008 or Higher
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,273 reads
2012-06-20 (first published: 2012-05-30)
8,801 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
LAYANAN BCA KCU PRABUMULIH Telp/Wa 08388333589
Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121
Alamat Telp BCA KCP Siliwangi (+62) 838-4945-0961
Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141
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...
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