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

SQL Server stored procedure

Alter a SQL Server stored procedure

How to alter an existing stored procedure in a SQL Server database? Simply use the alter command instead of the create command one to modify an existing SQL procedure. In this example let’s add

SQL Server Abbreviations

XMLA stands for XML for Analysis

XMLA stands for XML for Analysis stands for Extensible Mark-up Language for Analysis. It’s a language built on top of XML language. It allows data access from standard multidimensional data sources. Client applications accesses