Read Session-Specific data from the memory-optimized temp tables
Callum In the article Use Memory Optimization for Faster temp table performance, we explored how you...
Others
Export Windows applications logs in CSV format using SQL Server query
The Windows application logs are used by various applications such as SQL Server to write...
SQL Server 2017 Cumulative Updates (CU)s
This page lists all Cumulative Updates(CU) for SQL Server 2017 that have been released by...
SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests
You can use the dynamic management view sys.dm_exec_requests to get the status of currently running...
T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored...
T-SQL Query to find SQL database age and number of tables in SQL Server
The following T-SQL statement helps find the SQL Database age based on the created date...
A handy guide for Troubleshooting SQL Server Error 9002 – The Transaction Log for Database is Full
Are you getting the following SQL Server error 9002 for SQL Database with the following...
Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database
Many factors contribute to the performance of a database, such as server configuration, database design,...
Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error
When utilizing the sp_msforeachtable procedure to rebuild an index on all tables within a database,...
Troubleshoot SQL agent on Linux not starting
If the SQL Server Agent service on Linux is not starting due to hostname issues,...