Answer Posted / Arvind Kumar Tripathi
Filtered indexes in SQL Server 2008 offer several benefits, including improved query performance by reducing the number of rows that need to be scanned and processed, reduced storage usage due to smaller index sizes, and reduced fragmentation caused by frequent insertions and deletions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to provide default values to function parameters?
What is sql server query analyzer?
How do I start sql server 2017?
What is normalization and what are the advantages of it?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
When should you use an instead of trigger?
Why we use the openxml clause?
What is sql or structured query language?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why and when do stored procedure recompile?
Why use identity in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are the source of constraints?
do you know how to configure db2 side of the application? : Sql server database administration
