Script to compare 2 tables
This procedure will compare the two tables Table1 & Table2 and will display the value which is present in Table1 but not present in Table2.
2006-06-15 (first published: 2006-05-30)
433 reads
Maintenance and Management
Database Console Command : DBCC page undocumented
DBCC page was decommissioned in 7.0 according BOL. Parameters have being changed, but the call itself remains. Following script shows some reverse engineering results.
2007-06-25 (first published: 2006-05-29)
425 reads
Script to get details of enabled jobs
This script will give detials for all the enabled job including their steps/command/schedule.
2007-06-18 (first published: 2006-05-26)
896 reads
SS2K - sp_helprevlogin`
Old version, archived, that works on ss2k. Updated version works on ss2k5. NOTE: This is a Microsoft developed script, not from the contributor (Steve Jones)
2007-06-27 (first published: 2006-05-04)
896 reads
Get DBObjects with Specified Owner
A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]
2007-06-21 (first published: 2006-01-30)
299 reads
Know the JOBNAME and JOBOWNER
As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.
2006-11-21 (first published: 2006-01-30)
143 reads
Get maintenance plans info and It's by effect jobs
I have been wonder how to get info (by query NOT EM) of all the Maintenance Plans and it's by effect jobs plus schedule. I also see people asking the same questions in different forums. Finally, I start exploring myself (with helps from others of course), here's the result.You can run it as a ad-hoc […]
2006-01-27 (first published: 2006-01-12)
305 reads
SQL 2000 Data & Log file info for all DB's
Returns information about all the data / log files on a server, such as total file size, % used & free, etc.Can be set to filter out db's you don't want to monitor.When edited to allow the "update usage", numbers reported will be more accurate.Note: if you edit to allow update usage and intend to […]
2006-01-12 (first published: 2005-12-27)
369 reads
DIff between Max length of value in CHAR type Colu
This Script finds the maximum length of a value in Character type Column.(CHAR,VARCHAR,NVARCHAR) and finds the difference between the Total lenghth and maximum value inserted
2006-01-13 (first published: 2005-12-27)
363 reads
List user's permissions
With this script you can see the permissions that every user-defined role and every user without a dbrole has.The list could get very large and hard to manage, but it helped me to build the roles of an app that didn't had any role defined.Hope it'll be usefull to someone
2006-01-02 (first published: 2005-12-08)
719 reads
Blogs
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...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Forums
Alamat Kontak Bank BCA KCP Santa Telp:08218154392
WA CS (08218154392) Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta...
ALAMAT BCA KCU BANYUWANGI Telp:08218154392
WA CS (08218154392) Jl. Jenderal Ahmad Yani No.24-26, Panderejo, Kec. Banyuwangi, Kabupaten Banyuwangi, Jawa...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers