T-SQL Query to find SQL database age and number of tables in SQL Server
SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
top of page
-
- Jan 13, 2022
- 1 min
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
9 views0 comments
-
- Jan 11, 2022
- 1 min
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
15 views0 comments
-
- Jan 10, 2022
- 1 min
T-SQL script to get user session count with client IP address
Download a T-SQL script for SQL Server that will aggregate the number of active sessions for each unique IP address. This is useful for dete
66 views0 comments
-
- Jan 10, 2022
- 1 min
SQL Server Missing Index Script
If you ever find yourself in a situation where you're trying to troubleshoot performance on a SQL Server, then it's a good idea to look at
83 views0 comments
-
- Jan 7, 2022
- 1 min
Script SQL Database Permissions for database refresh
Script SQL Database Permissions for database refresh
248 views0 comments
-
- Jan 7, 2022
- 1 min
SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...
186 views0 comments
-
- Jan 7, 2022
- 1 min
T-SQL Script to find out Nth highest salary
It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H
37 views0 comments
-
- Jan 5, 2022
- 2 min
Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
105 views0 comments
-
- Jan 5, 2022
- 1 min
T-SQL Script to generate Six Digit One Time Password (OTP)
This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function
35 views0 comments
-
- Jan 4, 2022
- 2 min
Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
24 views0 comments
-
- Jan 4, 2022
- 1 min
"Invalid Object Name" Error in SSMS for recently created objects
Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"
65 views0 comments
-
- Jan 4, 2022
- 2 min
How to stop logging successful backup messages in SQL Server error logs
This article guides you to stop logging successful backup messages in SQL Server Error Logs.
58 views0 comments
-
- Dec 26, 2021
- 2 min
Generate Blocking tree in SQL Server and Azure SQL Database
Generate Blocking tree in SQL Server and Azure SQL Database
80 views0 comments
-
- Dec 26, 2021
- 1 min
Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
85 views0 comments
-
- Dec 26, 2021
- 2 min
SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'
SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'
91 views0 comments
-
- Dec 26, 2021
- 1 min
SQL Script to check database connections and their status
SQL Script to check database connections and their status
123 views0 comments
-
- Dec 17, 2021
- 1 min
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
17 views0 comments
-
- Dec 13, 2021
- 2 min
SQL Server table Columns with NULL and NOT NULL values
This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...
192 views0 comments
bottom of page