Three Undocumented SQL Server 2014 Full-Text Search Stored Procedures SQL Server 2014 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog […]
Author: Alexander Chigrik
Five undocumented SQL Server 2014 distributed queries stored procedures
Five undocumented SQL Server 2014 distributed queries stored procedures SQL Server 2014 supports the following five useful undocumented distributed queries stored procedures: – sp_catalogs_rowset – sp_catalogs_rowset2 – sp_catalogs_rowset_rmt – sp_linkedservers_rowset – sp_linkedservers_rowset2 sp_catalogs_rowset The sp_catalogs_rowset distributed queries stored procedure returns the database name for the specified database if the current user has access for this database. Syntax sp_catalogs_rowset [ @catalog_name […]
Undocumented SQL Server 2014 extended stored procedures (Part 2)
Undocumented SQL Server 2014 extended stored procedures (Part 2) In this article, you can find the description of some useful undocumented SQL Server 2014 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a […]
Undocumented SQL Server 2014 extended stored procedures (Part 1)
Undocumented SQL Server 2014 extended stored procedures (Part 1) In this article, you can find the description of some useful undocumented SQL Server 2014 extended stored procedures. sp_MSgetversion This extended stored procedure can be used to get the current version of Microsoft SQL Server. Syntax: EXECUTE sp_MSgetversion For example, to get the current SQL Server version, you can run: EXEC […]
Troubleshooting SQL Server 2014 System Stored Procedures
Troubleshooting SQL Server 2014 System Stored Procedures If you have problems with SQL Server 2014 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many system stored procedures bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the […]
Troubleshooting problems with locking in SQL Server 2014 (Part 2)
Troubleshooting problems with locking in SQL Server 2014 (Part 2) If you have problems with SQL Server 2014 locking, review this troubleshooting checklist to find potential solutions. 1. Encapsulate transactions within SQL Server stored procedures. This can reduce network traffic, because your client will send to server only the stored procedure name (perhaps with some parameters), and reduce the amount […]
Troubleshooting problems with locking in SQL Server 2014 (Part 1)
Troubleshooting problems with locking in SQL Server 2014 (Part 1) If you have problems with SQL Server 2014 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many locking bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the time […]
Troubleshooting Upgrading to SQL Server 2014
Troubleshooting Upgrading to SQL Server 2014 Should you have problems with upgrading to SQL Server 2014, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2014, you should have the following hardware: – Intel or compatible platform with processor speed: 1.0 GHz minimum for a 32-bit x86 implementation and a 1.4 […]
Troubleshooting SQL Server 2014 Indexes (Part 3)
Troubleshooting SQL Server 2014 Indexes (Part 3) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 666. This is the error message text: “The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID %I64d.” To resolve this problem, you can […]
Troubleshooting SQL Server 2014 Indexes (Part 2)
Troubleshooting SQL Server 2014 Indexes (Part 2) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. The error occurs when you try to create indexed view on a partitioned table that has a clustered columnstore index. This is the error message text: “Internal Query Processor Error: The query processor could not […]