Tag Archives: MSSQL

Indexing Tool : Missing Index Dynamic Management Objects (DMO)


Indexing Tools:Missing Index Dynamic Management Objects (DMO)

Advertisements

Table Variables


http://odetocode.com/articles/365.aspx Microsoft introduced table variables with SQL Server 2000 as an alternative to using temporary tables. In many cases a table variable can outperform a solution using a temporary table, although we will need to review the strengths and weaknesses of each in this article.Table variables store a set of records, so naturally the declaration […]
Read More »