Section provides some SQL Server scripts examples. To start with SQL Server development, learn by the example with practical scripts and cases is effective.
It includes SQL scripts, T-SQL examples and object creation like tables, views, stored procedures, and functions.
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 …
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 …
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 …
How to Download SQL Server Management Studio 18 (SSMS), the latest version? To connect to a SQL Server database in order to query tables or views. Or to develop a full database project, SSMS is the most used software, and it’s a free tool! How to get and install SQL …
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 proof of concepts. Nevertheless, it is not for use in a production environment. How to download the …
Create a SQL Server index to improve the performance of queries on tables and clustered views. To create an index, use this example and adapt it to the project requirements. Indexes are the first recommended step to performance optimization in SQL Server. How to create a simple SQL Server index …
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 with indexes, whether an index is A clustered or a non-clustered one. This query offers you a …
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 …
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. …
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 …
2017 - 2021 - Expert-Only.net - SQL Server queries © All rights reserved.