Experience >>>>> Certifications

From the MS site on one of the exams for that cert (461)

Who should take this exam?

This exam is intended for SQL Server database administrators, system engineers, and...

https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

caippers (1/31/2014)

---

I am trying to pass it a date and have it return day of week. But the first thing I wanted to try was to just create a...

Try rescheduling for a quieter time, check the link I posted about CheckDB's memory grants and check the server in general for resource contention (execution grants)

'indefinitely' how long have you left it? How busy is the server?

Resource Semaphore is a wait for memory grants. (also see this: http://www.sqlskills.com/blogs/jonathan/dbcc-checkdb-execution-memory-grants-not-quite-what-you-expect/)

What should that procedure return? If I pass it current date (2014/01/31), what do you expect to get back?

Please note: 5 year old thread.

It's entirely possible to set the backup jobs up on the mirror as well, just have them check the DB status when they run, if...

Depends on the queries that run against that table. If you have queries that filter on Instance, Site and Office or Instance, Site, Office and PersonType it could impact the...

BWFC (1/31/2014)

---

If you mean 'is the difference in ServiceDays and AverageServiceDays the same every time' then...

Can't see anything obvious (other than multiple unnecessary DISTINCTs)

Is the difference in rowcount consistent?

Could you rather put the code in your post, wrapped in the code tags (see left-hand panel)

Word docs from untrusted sources.... 🙁

Why is the DB in Standby? Why does it need to go back in Standby?

Going to need to see the code. Can you post just the procedure and view initially, might need more later.

I created the view by copying the code from my...

Ryan George (1/31/2014)

---

Dear Mr....

In that case option 2 and option 3 are not equivalent and hence cannot be compared for performance.