Read Session-Specific data from the memory-optimized temp tables
In the article Use Memory Optimization for Faster temp table performance, we explored how you can leverage memory-optimized tables to...
Category: Others
117 articles
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 new events. It does not...
SQL Server 2017 Cumulative Updates (CU)s
This page lists all Cumulative Updates(CU) for SQL Server 2017 that have been released by Microsoft. I will update this...
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 queries on SQL Server instances...
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 procedure. While running a SQL...
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 and number of tables. You...
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 descriptions? The transaction log for...
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, database configurations, query, index, and...
Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error
When utilizing the sp_msforeachtable procedure to rebuild an index on all tables within a database, the undocumented stored procedures iterate...
Troubleshoot SQL agent on Linux not starting
If the SQL Server Agent service on Linux is not starting due to hostname issues, it could be related to...