Answer / sql dba

RESTORE VERIFYONLY FROM DISK = 'C:\temp\adventure.bak'

How optimize sql query with multiple joins in sql server?

0 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

What are the advantages of using third-party tools?

0 Answers  

---

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

---

What happens if null values are involved in bitwise operations?

0 Answers  

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---