Database performance information
Recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on instance dm_os_performance_counters dm_database_encryption_keys
April 2021
Find all comments in SQL server for all kind of objects
This script return record if we used comment using extended properties. Objects and Columns Indexes Parameters Schemas Database XML Schema Collections Database Files Data Spaces USER Partition function Remote service binding Route Service Contract Message type Plan guide Assembly Certificate Need to be change class tinyint Identifies the class of item on which the property …
Find all comments in SQL server for all kind of objects Read More »
Database documentation within a database
Here are the sample scripts show how to write comment on each database object using SQL queries. Adding comments to a table Adding comment to column inside table Other Refrence
Foreign Key scripts
We need to have ready scripts when we need to clean all data with reseed identities. Please make changes in this as per your requirements. Drop temp table Create temp table with Foreign Key (FK) values Generate foreign key drop scripts from temp table Generate foreign key scripts from temp table. Other References:
Database Snapshots (SQL Server)
The database snapshot feature is made available in all editions starting with SQL Server 2016 SP1. A database snapshot is a read-only, static view of a SQL Server database (the source database). The database snapshot is transactionally consistent with the source database as of the moment of the snapshot’s creation. A database snapshot always resides on the …
SSIS CSV Import error when a special character in the text column
Whenever you find any problem in importing a CSV file using the SSIS package. Here the way which we can try to resolve when the string in the double equation in the CSV file. Sample files [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202092. The component returned a …
SSIS CSV Import error when a special character in the text column Read More »
Pivot table
The following syntax summarizes how to use the PIVOT operator. Sample Query Complex PIVOT Example UNPIVOT Example
