Author: Alexander Chigrik

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 oledb stored procedures

Undocumented SQL Server 2017 oledb stored procedures SQL Server 2017 supports the following useful undocumented oledb stored procedures: sp_oledb_language sp_oledb_ro_usrname sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_language The sp_oledb_language database engine stored procedure returns the official language name and alternative language name for each language presents in the instance of SQL Server 2017. Syntax sp_oledb_language Return Code Values None. Result Sets Column name…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 job stored procedures

Undocumented SQL Server 2017 job stored procedures SQL Server 2017 supports the following useful undocumented job stored procedures: sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_MSget_jobstate The sp_MSget_jobstate stored procedure returns the job state for the specified job. Syntax sp_MSget_jobstate [ @job_id = ] ‘job_id’ Arguments [ @job_id = ] ‘job_id’ Is the job identifier. job_id is UNIQUEIDENTIFIER, with no default. Return…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 distributed queries stored procedures

Undocumented SQL Server 2017 distributed queries stored procedures SQL Server 2017 supports the following 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 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 = ] ‘catalog_name’ Arguments [ @catalog_name = ] ‘catalog_name’…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 Database Engine Stored Procedures

Undocumented SQL Server 2017 Database Engine Stored Procedures SQL Server 2017 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_objectfilegroup sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname = ] ‘dbname’ The database name to…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Some tips to use System Monitor with SQL Server 2017

Some tips to use System Monitor with SQL Server 2017 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2017. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. To start System…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2017 Profiler Optimization Tips

SQL Server 2017 Profiler Optimization Tips SQL Server 2017 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and optimize…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Useful undocumented SQL Server 2017 extended stored procedures

Useful undocumented SQL Server 2017 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2017 extended stored procedures. xp_availablemedia This extended stored procedure returns available drives and free space in bytes on these drives. In comparison with xp_fixeddrives, the xp_availablemedia extended stored procedure returns not only the hard drives, but all available…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2)

Useful Undocumented SQL Server 2017 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2017 DBCC Commands (Part 1)

Useful Undocumented SQL Server 2017 DBCC Commands (Part 1) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC CONFIG This command shows the server’s level DS_CONFIG information. The DBCC CONFIG returns the same DS_CONFIG information as the DBCC RESOURCE returns,…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register