Monthly Archives: November 2016

SQL Server: Discuss Execute(SQL) At LinkedServer

Posted on November 9, 2016 by Prashanth Jayaram

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 Execute AT Linked Server, Linked Server Error, MSDTC, Open Query, SET FMTONLY OFF; SET NOCOUNT ON;, The transaction manager has disabled its support for remote/network transactions. | 1 Comment

SQL : How to Find Unused Indexes details

Posted on November 1, 2016 by Prashanth Jayaram

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 →