SQL Server - sqlncli11.lib Related Hyperlink

sqlncli11.lib

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/using-the-sql-server-native-client-header-and-library-files?view=sql-server-ver16

Additionally,

1. How to Rename an object...

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-ver16

2. We can catch the wait stats for 3 Very Important WaitTypes

select * from sys.dm_os_wait_stats where wait_type in

('ASYNC_NETWORK_IO','PAGELATCH_SH','CXPacket')

 

We can also learn about below few other wait types

RBIO* wait types

BUFFERPOOL_SCAN Waitypes

get current date.... select getdate()

3. ROW_NUMBER (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16

4. KeyLookup and High CPU Queries

https://learn.microsoft.com/en-us/sql/relational-databases/showplan-logical-and-physical-operators-reference?view=sql-server-ver16

5. Create or delete a server alias for use by a client

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver16

Best Regards

Amit Vaid