Answer / 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.

How to display a past time in days, hours and minutes?

1 Answers  

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

CREATE a table from another table

2 Answers  

---

What is stored procedure in SQL..??

2 Answers  

---

What are orphan records?

1 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1 Answers  

---

How to optimize stored procedure optimization?

1 Answers  

---

Can binary strings be converted into numeric or float data types?

1 Answers  

---

What are scheduled tasks in sql server?

1 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---