TSQL-Scripts
TSQL-Scripts copied to clipboard
SQL-Server-projects
:frog: Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.
The script has been improved with several enhancements: • Added error handling using TRY...CATCH to catch and display issues during execution. • Improved string handling with NVARCHAR for better Unicode...
The improved version of the script focuses on enhancing readability, maintainability, and safety. First, the script was reformatted with consistent indentation and clear section comments to make it easier to...
IMPROVEMENTS MADE 1. Error Handling with TRY...CATCH: o Added error handling to catch and display any issues during execution. 2. Improved String Handling: o Used NVARCHAR for better Unicode support....
Improvements Made: 1. Used SYSNAME instead of VARCHAR(50) for database names — it’s more semantically accurate and flexible. 2. Formatted timestamp using FORMAT() for readability. 3. Better username extraction using...
Optimizations: ✅ Better Recursive CTE Processing: Avoid unnecessary joins in wbs_relate. ✅ Using FORMAT for Dates: Improves readability and avoids unnecessary conversions. ✅ Using NVARCHAR Where Needed: Prevents implicit conversion...
Metadata
Owner
Metadata
:frog: Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.