Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,241 reads
Scripts
Show database size info across an instance
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,957 reads
Generate Create View statements for database tables.
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,117 reads
Execute T-SQL Scripts in Parallel
Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.
2013-08-13 (first published: 2009-08-28)
17,529 reads
usp_tableReference
Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.
2013-08-12 (first published: 2013-08-02)
1,130 reads
Dynamically Drop a User From Your SQL Instance
Dynamically drop a user from each database on an SQL instance by their server login SID, then remove there server login as well. Plus some helpful printable information when ran.
2013-08-09 (first published: 2013-07-16)
915 reads
Simplest way to search any string in db objects
Easiest way to search for a string in any object within the database.
2013-08-08 (first published: 2013-07-29)
2,313 reads
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,662 reads
2013-07-31 (first published: 2008-07-15)
1,611 reads
2013-07-30 (first published: 2013-06-12)
1,531 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
ALAMAT KONTAK BCA KCU SITUBONDO Telp:08218154392
WA CS (08218154392) Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur...
Alamat Kontak Bank BCA KCP Setiabudi Telp:08218154392
WA CS (08218154392) Jl. Dr. Setiabudi No.146, Hegarmanah, Kec. Cidadap, Kota Bandung, Jawa Barat...
Alamat Kantor BCA KCU Wahid Hasyim Telp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers