T-SQL script to find out SQL Server Logs directory
SQL Server error logs are essential for troubleshooting issues, checking out any warning or errors raised by various SQL Server...
Category: Others
117 articles
SQL Server Performance Troubleshooting: Navigating Common Issues
In the realm of data management, SQL Server stands as a pillar of reliability and efficiency. However, even the most...
T-SQL Query to find Supported Compatibility Level Values in SQL Server
The question came up on the forum – how do I find all the possible values for a specific compatibility_level...
SQL Server MeMORY Optimized Table Variables for faster performance
SQL Server memory-optimized tables are a great way to improve performance for table variables. In the previous articles, Use Memory...
SQL Server Execution Plan – Displays Estimated and Actual number of rows
SQL Server Execution Plan – Displays Estimated and Actual rows. This article focuses on getting the information by looking at...
Fix error “Agent XPs disabled” in SQL Server
This article explains the steps to fix the SQL Server agent error “Agent XPs disabled” using T-SQL scripts. Error details...
How to Use a Cross Join in SQL Server: A Beginner’s Guide
In SQL Server, a cross join is also known as a cartesian join or a cross product join, and it...
SQL Server – How to comma-separated values into different columns
This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query. Recently, someone asked...
How to Specify SET ROWCOUNT value in SQL Server Management Studio (SSMS)
I recently faced an issue where my query returns only five, whereas the table contains 542 records. The select statement...
Extract SQL Server Instance details using SERVERPROPERTY() function
The SERVERPROPERTY() function of SQL Server allows you to retrieve the information related to that instance. Let’s check out this...