Answer Posted / Anima Gupta
"Sparse columns in SQL Server (also known as column-store indexes) are a way to store data more efficiently in tables. Instead of storing all values for every row, only the non-null values are stored, which can significantly reduce storage space for tables with many null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is the difference between for xml raw and for xml auto?
What is self contained sub query?
Why and when do stored procedure recompile?
List the ways in which dynamic sql can be executed?
what is spatial nonclustered index
What are the different SQL Server Versions you have worked on?
How to convert character strings into numeric values?
What is a view in sql?
What is a scheduled job or what is a scheduled task?
What is the difference between upgrade and migration in sql server?
What kind of problems occurs if we do not implement proper locking strategy?
What is clustered index
How efficient you are in oracle and SQL server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
