
Execute SQL Server procedure with parameters
How to execute a stored procedure with parameters? Depending on the implementation of the SQL Server code, call the procedure with all parameters or only one. First you have to set the value …
How to execute a stored procedure with parameters? Depending on the implementation of the SQL Server code, call the procedure with all parameters or only one. First you have to set the value …
How to split a text after a particular character with SQL Server… like for example a file name: “file.txt” to separate the file name from its extension. Indeed, it is obvious that splitting …
Microsoft SQL Server database is slow, or the available disk space is getting abnormally small? To solve this problem, it is sometimes enough to empty the SQL Server transaction log and reduce the …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.