SQL Server 2019 Builds — Build Description Release Date URL to KB Article— 15.0.1000.34 CTP 2.0 9/24/2018— 15.0.1100.94 CTP 2.1 11/7/2018— 15.0.1200.24 CTP 2.2 12/6/2018— 15.0.1300.359 CTP 2.3 3/1/2019— 15.0.1400.75 CTP 2.4 3/26/2019— 15.0.1500.28 CTP 2.5 4/23/2019— 15.0.1600.8 CTP 3.0 5/22/2019— 15.0.1700.37 CTP 3.1 6/26/2019— 15.0.1800.32 CTP 3.2 7/24/2019— 15.0.1900.25 RC1/RC1 Refresh 8/29/2019— 15.0.2000.5 RTM …
sys.dm_db_xtp_index_stats (Transact-SQL) – SQL Server | Microsoft Docs
Possible System Memory State values:* Available physical memory is high* Physical memory usage is steady* Available physical memory is low* Available physical memory is running low* Physical memory state is transitioning sys.dm_os_sys_memory
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
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 »
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
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:
