Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
What is N in nvarchar? – Interview Question of the Week #301
Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.
SQL SERVER – Datatype Decimal Explained – Datatype Numeric
Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works.
SQL SERVER – Two Advantages of Sort in TempDB Options
A client of Comprehensive Database Performance Health Check asked me the advantages of enabling Sort in TempDB Options. Let us learn.
SQL SERVER Management Studio – Grid vs Text Output
they asked me questions if I know how to fix it. Well, it is actually very simple and we need to learn about Grid vs Text Output.
SQL SERVER – Move a Table From One Schema to Another Schema
My client of Comprehensive Database Performance Health Check wanted to learn the trick to Move a Table From One Schema to Another Schema.
SQL SERVER – List All Dates Between Start and End Date
We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).