MS-SQL Server - Just Date & Ambiguous Column Error

Just Date & Ambiguous Column Error

https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16

SELECT CAST( GETDATE() AS Date ) ;

Ambiguous Column Error

https://learn.microsoft.com/en-us/answers/questions/1091899/ambiguous-column-error-on-users-modifeddate-when-c

Additionally,

How It Works: What is a Sleeping / Awaiting Command Session

https://techcommunity.microsoft.com/t5/sql-server-support-blog/how-it-works-what-is-a-sleeping-awaiting-command-session/ba-p/315486

More Records

https://amit-sqldbasupport.blogspot.com/2023/05/ms-sql-server-more-records.html?m=1

Declare & LIKE

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/declare-local-variable-transact-sql?view=sql-server-ver16

LIKE

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver16

Resize Tempdb

https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-tempdb-database?view=sql-server-ver16

Disk Latency

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-sql-io-performance

Strong Password

https://learn.microsoft.com/en-us/sql/relational-databases/security/strong-passwords?view=sql-server-ver16

Also

WaitStats Permission

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16#permissions

SQL Server 2017 - Update

https://www.microsoft.com/en-us/download/details.aspx?id=56128

CU 29

https://support.microsoft.com/en-gb/topic/kb5010786-cumulative-update-29-for-sql-server-2017-8b3b4122-ed46-4d33-9d80-256c513ae42e

CU 21

https://support.microsoft.com/en-us/topic/kb4557397-cumulative-update-21-for-sql-server-2017-9f280897-8cbb-260c-eb97-e39723ac4b8a

CU 9

https://support.microsoft.com/en-us/topic/kb4341265-cumulative-update-9-for-sql-server-2017-ba44a85e-35e0-46db-bad9-d2202cebd334

Best Regards

T. Amit Vaid S.