That day one of my junior colleague rushed to me and sought my assistance. He failed to drop an user. It showed - "The database principal owns a schema in the database, and cannot be dropped." I took him to our office kitchen, had tea, and explained the issue.
[More]
Today, I am going to explain you Clustered Columnstore Index and some related concepts. As a Database enthusiastic, you should know it.
[More]
Today I am going to show you how to import data from a CSV file using Transact-SQL BULK INSERT and the OPENROWSET(BULK...) statement.
[More]
Let's examine the error handling step-by-step.
[More]
This article explain how to store crucial data in SQL server securely.
[More]
A temporal table is an user designed system-versioned table which keeps the full history of data changes of a table.
[More]
Explaining the PIVOT table.
[More]
Generating random value for DATETIME field within a range
[More]
Filling up missing dates in query output using CTE
[More]
Recently, I was in need to generate a report to find out how many customer calls daily within 10 AM
[More]