During a full database restore, you have a power outage and the restore fails after running for 6 hours out of an estimated 7 hours to complete. What would you do when power is restored to recover the database in the most effective way?  Re-write this query so it will use the index on the Datecreated column. (1) SELECT * FROM order_header WHERE DateDiff(hh,Datecreated,getdate()) < 2 SELECT * FROM order_header WHERE DateDiff < 2   Your clustered SQL Server 2000 production database supports a busy 24/7 web site. Your 24/7 support team reports 2 short periods during the night when ‘SQL Server not found or access denied’ messages were generated from the middle tier of your application and web page access suffered as a result. You suspect that the cluster failed over twice during the night. How would you confirm this?  A server has 8GB ram installed but performance monitor reports SQL Server is using only 2GB. What settings must be changed from default for SQL Server to be able to address all of the memory?   What tool could be used for tracking the occurrences of SQL server exceptions including the error message text, database name, date/time etc over a 12 hour period?   A query using large tables used to run in 2 mins, is now taking over 15 mins to run, how would you investigate what is causing this and how would you fix it?   On inspecting you SQL Server Error Log you notice a large number of deadlock errors. What would you do to troubleshoot these errors?   Where would you expect to use the syntax ‘DEFAULT VALUES’?   Other than a result set, name 2 methods for returning a value from a stored procedure?  What is wrong with the syntax below?CREATE PROC usp_ExtractOrderNumbers @StartDate datetime = GETDATE() - 1, @EndDate datetime = GETDATE()ASSELECT OrderID, OrderNumFROM tbl_OrdersWHERE OrderDate between @StartDate and @EndDate  In the Bulk Logged recovery model, what is written to the transaction log during a SELECT INTO operation? 

Questions by highvoltage

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions