SQL Server 2022 STRING_SPLIT Function

SQL Server memory pressure can cause a lot of problems. This is a list of queries you can run to troubleshoot memory pressure problems. Read

Here is a SQL Server script that will get you the database backup history for a server. It is a significant troubleshooting step to determin

Do you get the error "SHOWPLAN permission denied in database 'DBName'"? This error is due to SQL Server permissions. Find out how to fix SQL

CREATE DATABASE: CREATE DATABASE is a fundamental SQL command that you need to know in order to work with databases.

This article helps you to fix SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly Specified Database.

Did you face the error - "VIEW SERVER STATE permission was denied on object 'server', database 'master' while executing the DMV. Read More

Case statements are used to provide instructions to be executed based on conditions. Case statements can be used in SELECT, INSERT, UPDATE,

Want to know how to convert a Unix timestamp to a SQL Server timestamp or vice-a-versa? This article shows you how to do it using T-SQL. Rea

SQL Server Extended Events to track PAGE SPLITS in SQL Database