top of page
Increase or Decrease the number of error log files and their size in SQL Server
Increase the number of error log files and their size in SQL Server
-
Dec 30, 20211 min read
50 views
0 comments
Configure the Minimum and Maximum memory for SQL Server Instance
Configure the Minimum and Maximum memory for SQL Server Database instance
-
Dec 30, 20211 min read
40 views
0 comments
T-SQL script to Recycle SQL Server error logs manually
T-SQL script to Recycle SQL Server error logs manually
-
Dec 30, 20211 min read
51 views
0 comments
Generate Blocking tree in SQL Server and Azure SQL Database
Generate Blocking tree in SQL Server and Azure SQL Database
-
Dec 26, 20212 min read
225 views
0 comments
Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
-
Dec 26, 20211 min read
281 views
0 comments
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'
-
Dec 26, 20212 min read
187 views
0 comments
SQL Script to check database connections and their status
SQL Script to check database connections and their status
-
Dec 26, 20211 min read
255 views
0 comments
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
-
Dec 17, 20211 min read
33 views
0 comments
Microsoft SQL Server 2022 is here!!!
Microsoft SQL Server 2022 features and links
-
Dec 15, 20211 min read
180 views
0 comments
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...
-
Dec 13, 20212 min read
247 views
0 comments
SQL Server - Find Business Days Between Dates
Recently, my client asked me to calculate the date difference, excluding only Sunday. How do you calculate days using the T-SQL script?...
-
Dec 10, 20211 min read
198 views
0 comments
Find databases list where user has access in SQL Server
Recently our client wanted to know if there's a way for him to figure out which additional databases his user has access to. When we...
Rajendra Gupta
Nov 25, 20211 min read
109 views
0 comments
bottom of page