you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

Why use update_statistics command in sql server?

0 Answers  

---

What is the concept of optimization?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

how to find out the repeated value from table using groupby function?

4 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,

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---