Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
SQL SERVER – Free Performance Tuning Videos
Let me share today some of the Free Performance Tuning Videos for SQL Server. Yesterday I wrote a blog post about COVID-19, Working From Home.
COVID-19, Working From Home and Performance Tuning
I would like to quickly share, how I am managing with Covid-19, Working from Home (WFH) and managing my Performance Tuning consulting service.
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
SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?
I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?
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…