What happens if we shrink log file in sql server?

0 Answers  

---

what is the difference between sql query and google query?

10 Answers   TCS,

---

How to find Duplicate Records In table?

0 Answers   HCL,

---

How to connect to a sql server using odbc_connect()?

0 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Explain collation?

0 Answers  

---

How to tune a stored procedure?

6 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

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,

---

What are the steps to insert a table?

0 Answers  

---

What command is used to rename the database?

0 Answers  

---