Today we are going to learn about how Using Stored Procedure in SELECT. However, the easiest method to run the stored procedure.
SQL SERVER – Using Stored Procedure in SELECT Statement
A very popular question I often receive during my Performance Health Check is about how to use stored procedures in SELECT Statement.
Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173
Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.
SQL SERVER – Same Result Same Query Plan – Different Entry in Cache
The question I was asked was about a query that had the same result same query plan but the different entry in the cache, is that possible.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’
Reading Excel, a reader got Msg 15281: SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’. Enabling Ad Hoc Distributed Queries fixes it.