-
-
-
-
Large Stored procedure formatting
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 ?
-
-
-
-
-
-
-
-
Optimisation and Performance
How optimisation and Performance in Sql Server 2000 can be achieved?What are the steps involved?
-
Dynamic Document Management System (DDMS)
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 .
-
Logging and Transaction
What is the different between Logging and Transaction?
-
Distributed deadlock
Explain what is Distributed deadlock?
-
SQL Server Physical Storage
How are SQL Server databases physically stored under Windows 2000?
-
Output Row Buffer Size
What is the buffer size of SQL query output row?
-
SQL Server Reporting Services Subscription
How can we dynamically assign parameters to a subscription in SQL Server Reporting Services 2005.
-
Memory Pools
What are the memory pools?
-
Replication Overview
Explain the Replication overview?
SQL Server Interview Questions
Ans