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...
top of page
-
Dec 10, 20211 min read
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?...
196 views0 comments
-
Dec 10, 20211 min read
Find SQL Server Statistics Updated Date
This SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...
413 views0 comments
-
Dec 10, 20211 min read
When my SQL Server database was restored ?
When my SQL Server database was restored ?
39 views0 comments
-
Dec 10, 20211 min read
Get a list of supported Time Zones in SQL Server and Azure SQL Database
Do you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...
31 views0 comments
-
Dec 10, 20211 min read
Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371
This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...
2,292 views0 comments
-
Dec 9, 20212 min read
SQL Script to fix Orphan users in SQL Server database
This blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...
2,577 views0 comments
-
Dec 6, 20211 min read
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 You might see...
1,021 views0 comments
-
Dec 6, 20212 min read
Extract SQL Server Instance details using SERVERPROPERTY() function
Extract SQL Server Instance details using SERVERPROPERTY() function
319 views0 comments
-
Dec 4, 20214 min read
Learn SQL Server Select statement
The SQL SELECT statement is the workhorse of data access. It is the standard way to retrieve data from a SQL database. In this tutorial,...
35 views0 comments
Rajendra Gupta
Dec 1, 20212 min read
SQL Server 2019: "String or binary data would be truncated"
This article explains in-depth what the error message "String or binary data would be truncated" means and how you can identify which...
133 views0 comments
Rajendra Gupta
Nov 25, 20211 min read
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...
89 views0 comments
Rajendra Gupta
Nov 25, 20213 min read
How to Suspend and Resume an Availability Database in SQL Server Always On Availability Group
One of the fantastic features of Always On Availability Groups is that you can take one of the replicas for a database offline for...
4,778 views0 comments
bottom of page