Capture the SQL behind SSMS reports with a filtered Extended Events ring buffer, inspect batch text, and remove the session afterward.
Stale Statistics: Detecting and Updating Them
Detect stale statistics with update properties, review modification thresholds, and schedule targeted refreshes with recorded outcomes.
SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size
Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647
Authentication Mode Greyed Out in SSMS: Read the Real Value
An authentication mode greyed out in SSMS means the Security page can’t show the value it reads. This post reads the real mode with SERVERPROPERTY, with the registry value SSMS uses and with the error log. It also explains what the two valid values mean and how a bad value is repaired.
SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326
In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.
SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC
In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC. Let us read more…
How to Decode @@OPTIONS Value? – Interview Question of the Week #268
How to decode @@OPTIONS value? Session-level SET options live in the @@options variable, and this script turns that number into readable settings.