How to end a stored procedure properly in ms sql server?
Can you explain full-text query in sql server?
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.
What is the purpose of using COLLATE in a query?
What is a periodical index?
What are the different types of replication? How are they used?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
what is database replication? : Sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is it unwise to create wide clustered index keys?
Explain what are various ways to enhance the ssrs report?
What is deadlock and how to avoid the deadlocks.