Time economy is key when you create a SQL Server partition.
SQL Server Partition

Create a SQL Server table partition

How to create a table partition in SQL Server? Let’s consider a large table with Sales data. So, this table have a column that stores the year of the sale and the table stores millions of lines. Let’s consider also that some reports reads this data to display yearly totals

SQL Server Partition

What is a SQL Server table partition?

A SQL Server table partition allows to physically split the data of one table on the disk. This data division allows to access directly one unique partition instead of all the data from the table. First, why all large tables should have partitions? When accessing hundreds of million lines, it

blank
SQL Server Index

SQL Server clustered index definition

What is a SQL Server clustered index ? The definition of a SQL Server index is a structure, i.e. a file, stored physically in a disk. It’s similar to the master data file and the log data file that composes a database. Basically, to find the associated lines or rows

blank
SQL Server Index

How to rebuild a SQL Server index?

Maintain the indexes is vital to keep a database up to speed with optimal performance. To rebuild an index, use the command to alter and rebuild. Technically speaking, the query rebuilding the index delete it and then creates it again. This operation reorders the index rows in adjacent pages and

blank
SQL Server Index

How to reorganize a SQL Server index?

How to reorganize a SQL Server index? This operation defragments the lower level of the indexes by reordering the pages physically, from left to right. The reorganize operation also compacts the pages of the index. To better understand this, imagine a book of recipes with the pages not ordered anymore.

blank
SQL Server Index

How to disable a SQL Server index?

How to disable a SQL Server index? To disable an index for performance reasons, use this code and adjust it to your index and table names. For instance, let’s consider a large sales table, with million lines. Let’s consider that the table has a non-unique and non-clustered index on the

blank
SQL Server Index

How to drop a SQL Server index?

This article is on how to drop a SQL Server index from an existing table on a given database. It can be a relational or a transactional database. For instance, learn here why you need an index optimization plan on databasejournal. How to drop a SQL Server index? To drop