In order to find all the tables without indexes just run the following query in the Query Editor:
Tag Archives: table
Sql Server Interview question: Data deletion / Size reduction
Question: When you delete data from a table, is SQL Server reducing immediately the size of that table? Continue reading Sql Server Interview question: Data deletion / Size reduction
How do you find the index size of a table?
We can use the following query to find the size of the index. Continue reading How do you find the index size of a table?
#SqlServer interview question: What are table-valued parameters?
Table-valued parameters is a feature introduced in SQL Server 2008. In earlier versions of SQL Server it was not possible to pass a table variable into a stored procedure as a parameter.
In SQL SERVER 2008 we can use table-valued parameters to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing in multiple parameters. Continue reading #SqlServer interview question: What are table-valued parameters?