Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

---

One table how may column and Primary key

3 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

Why would you call update statistics?

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What is a DBMS, query, SQL?

0 Answers   Maveric,

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---