SQL Server Partition
Create a SQL Server 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 …
Month: August 2020
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 …
SQL Server Index
Clustered index in SQL Server
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 …
SQL Server Downloads
Download SQL Server Management Studio 18 – SSMS
How to download the latest version of Microsoft SQL Server Management Studio or SSMS ? The latest version of SSMS is SSMS 18. SSMS allow users to connect to a SQL Server database …
SQL Server Downloads
Download SQL Server 2019 developer edition for free
Where to download the SQL Server 2019 developer edition? It’s the free edition and contains the full set of available features. It also provides a real option for evaluation for developments, tests and …
SQL Server Index
Create an index in SQL Server
Create an index in SQL Server to improve the performance of queries on tables and also in clustered views. Two types of index exists, the clustered and the nonclustered one. To create a …
SQL Server Index
How to list all SQL Server indexes?
How to list all SQL Server indexes? It can be very useful to display all database indexes. Indeed, to have an idea at a glance at how this SQL Server database is optimized …
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 …
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 …
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 …
