June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
All Articles xsym-600x600

SQL SERVER – Quick Note on CROSS APPLY

Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server

Yesterday I wrote article about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. I had used CROSS APPLY in the query. I got email from one reader asking what is CROSS APPLY. In simpler words, cross apply is like inner join to table valued function which can take parameters. This particular operation is not possible to do using regular JOIN syntax You can see example of CROSS APPLY in my article here.

Read More

SQL SERVER – 2005 – Last Ran Query – Recently Ran Query

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table
How many times we have wondered what were the last few queries ran on SQL Server? Following quick script demonstrates last ran query along with the time it was executed on SQL Server 2005. SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest…
Read More
All Articles openrowset-490x400

SQL SERVER – Fix : Error 15281 SQL Server blocked access to STATEMENT OpenRowset/OpenDatasource of

Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Server Security

Error 15281
Msg 15281, Level 16, State 1, Line 3
SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Ad Hoc Distributed Queries’ by using sp_configure. For more information about enabling ‘Ad Hoc Distributed Queries’, see “Surface Area Configuration” in SQL Server Books Online.

Read More