top of page
rajendra gupta
Jul 12, 20224 min read
SQL Server Queries to troubleshoot Memory pressure on SQL instance
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
12,076 views0 comments
rajendra gupta
Jul 12, 20221 min read
SQL SERVER script to get Database Backup History
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
5,147 views0 comments
rajendra gupta
Jul 12, 20221 min read
Fix SQL Server error: SHOWPLAN permission denied in database ‘DBName’
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
18,958 views0 comments
rajendra gupta
Jul 9, 20222 min read
Fundamental SQL: SQL Query examples for CREATE DATABASE
CREATE DATABASE: CREATE DATABASE is a fundamental SQL command that you need to know in order to work with databases.
258 views0 comments
rajendra gupta
Jul 8, 20221 min read
SQL Server Error 18456: failed to open the explicitly specified database
This article helps you to fix SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly Specified Database.
24,016 views0 comments
rajendra gupta
Jul 8, 20221 min read
SQL Server Error VIEW SERVER STATE permission was denied on object 'server’,databasE'Master'
Did you face the error - "VIEW SERVER STATE permission was denied on object 'server', database 'master' while executing the DMV. Read More
10,626 views0 comments
rajendra gupta
Jul 5, 20222 min read
Learn about Case Statement in SQL Server
Case statements are used to provide instructions to be executed based on conditions. Case statements can be used in SELECT, INSERT, UPDATE,
81 views1 comment
rajendra gupta
Jul 5, 20221 min read
Convert Unix Timestamp in SQL Server (T-SQL)
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
10,123 views0 comments
rajendra gupta
Jun 30, 20222 min read
SQL Server Extended Events to track PAGE SPLITS in SQL Database
SQL Server Extended Events to track PAGE SPLITS in SQL Database
660 views0 comments
bottom of page