What is dbcc updateusage?
No Answer is Posted For this Question
Be the First to Post Answer
What does this statement do @@rowcount?
How many tables can be joined in SQL Server?
How to get all stored procedures in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
List all the types of user-defined functions?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What are the hotfixes and patches in sql server?
How to rebuild all indexes on a single table?
How to invoke a trigger on demand?
how many type of indexing in database?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,