Dhai (A Numeric 2.5)
When we listen Dhai it reminds us about new CTP 2.5.
Additionally,
A Performance DHAI
D - DMVs are useful.
sys.dm_db_log_info
sys.dm_io_virtual_file_stats
H - Hashbytes Performance Fix
A - Auto Create Statistics
I - Index Maintenance (Scheduled/Adhoc)
&
Best Regards
T. Amit Vaid S.
2 comments:
Partition Boundary
https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-partition-functions-transact-sql?view=sql-server-ver16
Using SQL Server Management Studio
To configure the remote access option
1. In Object Explorer, right-click a server and select Properties.
2. Select the Connections node.
3. Under Remote server connections, select or clear the Allow remote connections to this server check box.
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-ver16
Understand and resolve SQL Server blocking problems
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/understand-resolve-blocking
Post a Comment