Monthly Archives: November 2016

SQL Server: Discuss Execute(SQL) At LinkedServer

Abstract This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run dynamic complex queries  across heterogeneous data source. There are many instances that OpenQuery/OpenRowSet and four-part qualifier calling might not … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

SQL : How to Find Unused Indexes details

The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track  index usage details of the database. This DMV gives an information about an index which is being updated but not used in any seeks, scan or lookup operations. The below query list … Continue reading

Posted in SQL, Uncategorized | Tagged , , , | Leave a comment