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

Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database...

Everyone knows that SQL Server creates a Clustered Index  when we add a Primary Key  if there is no Clustered Index  already exist in the ...

I have written few posts on Index Fragmentation and how they can be checked. External Fragmentation occurs as a result of Page-Split  and ...

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...

Let's talk about something common for all database management systems without talking something specific to SQL Server. This is the in...

I noticed that values of a column related to newly inserted records which is an identity property enabled column in one of the tables, sud...

He is the Brain Basher or the interview question of the week. This is something every database engineer should know and it is not limited ...

My first post related to GUID discussed the main issue we face when using GUID as the key, specifically as the Clustered Key . Here is ano...

While analyzing a database related to one of the companies, I noticed that the key of most tables is based on GUID (uniqueidentifier) that...