SQL Server Performance Blog where milliseconds matter

Hi Guys, Welcome back for this midweek post! Performance has always been our favorite topic and then even today we see how to read the data faster using the table partitioning! Are you ready? ...as my Mexican friends would say ... vamonos!   What is the table partitioning? Table partitioning is a data organization scheme where the table data is divided into multiple storage objects called partitions. When a table becomes large it might be useful to partition the data and this is done following a rule. For example, if we had a huge list of people we could think of creating a partition for each initial letter of the name . The first partition would contain all the people whose name starts with the letter A, the second partition would contain all the people who start with the letter B, and so on. The nice and interesting aspect is that when we search the table for a person starting with the letter A we will only read the data from the first partition. All other partitions would not ...