What is sparse columns of sql server 2008?

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

how to rename the table

3 Answers  

---

What is query optimization process?

0 Answers  

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

---

How to use group functions in the select clause in ms sql server?

0 Answers  

---

What is transcation?Plz give One example?

2 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How to create an index on a view?

0 Answers  

---