How to Improve the performencs of SQL Server 2005 exclude
stored Procedure and Indexes?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to drop existing indexes in ms sql server?

0 Answers  


Define clusters?

0 Answers  


What are the difference between primary key and unique key? : sql server database administration

0 Answers  


What is the difference between for auto and for nested?

0 Answers  


What is buffer cash in sql server?

0 Answers  






I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  


What are the difference between “where” and “having” clause in sql server?

0 Answers  


SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  


What are the underflow and overflow behaviors on float literals?

0 Answers  


How do you clear a log file?

0 Answers  


Can we create clustered index on non primary key column

20 Answers   ABC, CTS,


How can we solve concurrency problems?

0 Answers  


Categories