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?...
197 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...
417 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,327 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,594 views0 comments
-
Dec 8, 20212 min read
DATETIMEOFFSET SQL Server
The DATETIMEOFFSET can manipulate a single point in time value (DateTime Value) with the offset value. The offset specifies the value of...
130 views0 comments
-
Dec 8, 20211 min read
Difference between #table and ##table in SQL Server
SQL Server uses #table for Temporary table and ##Table for the Global Temporary Table. Let's understand the difference between these...
231 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
Restore database in SQL Server Always On Availability Group
In this blog, we will look at how to restore a database participating in SQL Server Always On Availability Group using the T-SQL scripts....
3,636 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...
90 views0 comments
bottom of page