Dinesh's Blog :::: Being Compiled ::::

Update: If you need the script for the same with financial year elements, read the new post . Date dimension is the most common dimensio...

I would say, this is the most confusing property in the Microsoft SQL Server. Most misunderstand it and most do not know how it works. Alt...

Every SQL Server database has two type of files added; Data file and Log file and same goes for system databases as well. You can change t...

SQL Server uses 3 protocols to make the communication between client and the server. Initially there were 4 protocols but now it supports ...

We use either Checksum or Hashbytes  for generating a value for finding changes of records when need to transfer records from one source t...

I had a requirement for getting the record count of all tables in one of client databases that had many tables with over 10 millions recor...

I have written two posts on HDInsight + SSIS based on Azure Feature Pack and they speak about how to creating a HDInsight Cluster and proc...

Let's talk about a very common scenario that you do with all solutions. If you need to implement a business logic using a database obj...

Here is a useful script. If you need to find out tables that have Identity property enabled, you can simply query the sys.tables  Catalog ...

Few months back, this was experienced by one of my clients and I was asked the reason for this. Although I wanted to make a post on it, I ...

Columnstore index is designed for retrieving large number of records much faster with aggregations and grouping. With SQL Server 2016, we ...

Licensing is always complex and sometime we cannot figure out the number of licenses we have to buy for the production. It is always bette...

Few days back, I wrote a post titled as  SQL Server Default and Rule objects - Should not I use them now? that discussed two objects that...

While we were discussing on data types to be used and null-able columns, a question was raised, asking whether the space is used for NULLs...

Here is a modern interview question on SQL Server. In addition to general questions on administration and maintenance, Azure based questio...

In order to make sure that the database contains high quality data, we ensure data integrity with our data that refers to the consistency ...

Temporal table was introduced with SQL Server 2016 and it is designed to capture and store changes of data in tables. In other words, simi...

When we have to store a datatime value (or date), in most cases, application accepts the value as a datetime and send the value to SQL Ser...

Fill Factor is a setting that uses with Indexes for determining how much free space remains on each leaf-level page for future operations ...

Have you faced this? Assume that you have created a Sequence object for generating values sequentially for tables which data type is set a...

Temporary tables are nothing new and we have been using this for long time. There are two types of temporary tables; Local that starts wit...

I had a requirement today to change the schema of set of tables to new schema but I did not find a direct method to change the schema of a...

You know that we can create multiple administrator accounts in SQL Server if it is a on-premises instance or an instance configured in a V...