What are the challenges you have faced while using stored procedure?

How to create restore point in Server 2003?

Hi,Someone please explain me the inner logic, how the inner query is getting executed.The Query is:SELECT t1.* FROM department t1 WHERE t1.location IN (SELECT t2.location FROM department t2 WHERE t1.dept_no t2.dept_no)The result of the Query is:dept_no dept_name locationd1 developer Seattle d2 tester Seattle...

What is a Database Snapshot ?What is Stuff function ?why we use replication .Do we use replication in an dataware house project ?What is meant by Scan and Seek ?We can use select in stored procdure using open query .Any idea .How do you do code coverage for UI and Database ? What factors are instrumental in doing UIcode coverage ? Eg : we consider Stored Procedure ,.... parameters validation as instrumental...

Explain the Replication overview?

What are the memory pools?

How can we dynamically assign parameters to a subscription in SQL Server Reporting Services 2005.

What is the buffer size of SQL query output row?

How are SQL Server databases physically stored under Windows 2000?

Explain what is Distributed deadlock?

What is the different between Logging and Transaction?

Hello:I would like you to help me guys for my Project Dynamic Document Management System (DDMS) .I was looking for any information to help me to make my project ,but I couldn’t find good recourses to help my. If you have any idea to help me or books ,I’ll be very grateful. Especially about how to create and design Dynamic database SQL Server 2005 .

How optimisation and Performance in Sql Server 2000 can be achieved?What are the steps involved?

We have used a Stored Procedure having large code in it. If we try to Alter the SP again then the entire code seems to be SCRAMBLED - Why ?