R4R
Right Place For Right Person TM

What are Sparse Columns?

previous previous previous
Question:
What are Sparse Columns?

Question:What are Sparse Columns?


Answer
A sparse column is bassically a tool of the data base which is use for the decrease physical storage amount which is used in a database.Sparse columns also be use for the redusing work Its reduce the space requirements for null values at the cost of more overhead to retrieve no null values. They are the normal columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve no null values.

By:UMANG
Date:

What are Sparse Columns?

Post Your Answers


User Name:
Answers:

Related Links

  1. What does TOP Operator Do?
  2. What is CTE?
  3. What is MERGE Statement?
  4. What is Filtered Index?
  5. What are the Advantages of using CTE?
  6. What is CLR?
  7. What are synonyms?
  8. What is LINQ?
  9. What is Isolation Levels?
  10. What is the EXCEPT clause?
  11. What is the NOLOCK?
  12. What is the RaiseError?
  13. What is Xml Datatype?
  14. What is Data Compression?
  15. What is the mean of Row Compression?
  16. What is the Page Compression?
  17. What is the mean of Dictionary Compression?
  18. What do you mean by DBCC Command?
  19. What is Catalouge Views?
  20. What is Pivot and Unpivote?
  21. What is the Filestream?
  22. What is the Dirty Read?
  23. What is SQLCMD?
  24. What do you mean by Table Sample?
  25. What is an Aggregate Function?
  26. What is the ROW_NUMBER()?
  27. What is the Ranking functions?
  28. What is the mean of ROW_NUMBER() OVER?
  29. What is the RANK() OVER?
  30. What is the DESK_RANK() OVER?
  31. What is the UNION?
  32. What is the mean of UNIONALL?
  33. What is the mean of Root Node?
  34. What do you mean by Branch Node?
  35. What do you mean by Leaf Nodes?
  36. Explain Active/Active and Active/Passive cluster configurations?
  37. What are slowly changing dimensions (SCD)?
  38. What is the SCD1 ?
  39. What do you mean by SCD2?
  40. What do you mean by SCD3 ?
  41. What do you mean by Star schema?
  42. What do you mean by Snow schema?
  43. What is surrogate key?
  44. What is ER Diagram?
  45. What are the Different methods of loading Dimension tables?
  46. What is denormalization and when would you go for it?
  47. What is lock escalation?
  48. What's the maximum size of a row?
  49. What is RAID?
  50. What do you mean by Deadlock?

Question:What are Sparse Columns?

Back Home Next

New Updates

Topics

Topics

R4R
R4R
R4R
R4R
R4R
R4R
R4R
R4R