tsqltools
tsqltools copied to clipboard
SQLadmin
Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier
Hi, Nice scripts.! I colleague of mine found you project and asked me to have a look at this, I couldn't run the scripts due a syntax error on my...
Improvements Made: 1. Variable Initialization: Initialized variables with default values where applicable. 2. Consistent Variable Naming: Used PascalCase for variable names and improved readability. 3. Error Handling: Added error handling...
Improvements Made: 1. Consistent Variable Naming: Used PascalCase for variable names for consistency. 2. Initialization: Combined variable declaration and assignment where possible. 3. Logic Enhancement: Streamlined the construction of SQL...
Improvements Made: 1. Consistent Variable Naming: Used PascalCase for variable names for consistency. 2. Initialization: Combined variable declaration and assignment where possible. 3. Logic Enhancement: Streamlined the construction of SQL...
Improvements Made: 1. Consistent Variable Naming: Used PascalCase for variable names for consistency. 2. Initialization: Combined variable declaration and assignment where possible. 3. Logic Enhancement: Removed redundant operations and streamlined...
Key changes: • Cursors fetch both schema and table name. • Avoids repeated subqueries inside loops. • Proper error handling and cursor cleanup. • Cleaner, more efficient, and easier to...
Notes • QUOTENAME: Safely handles server and database names that may contain special characters. • Error Handling: The TRY...CATCH ensures any runtime errors are caught, and resources are still cleaned...
Additional Suggestions • Parameterize: If you plan to reuse this script, make parameters easily configurable at the top. • Documentation: Add more comments and section headers as needed. • Validation:...
You are assigning a query to @SOURCE_SQL_DBNAME and then running sp_executesql to insert into a table variable: SELECT @SOURCE_SQL_DBNAME = 'select name from ' + @SOURCEDBSERVER + '.master.sys.databases where database_id>4'...