I would start by only doing rebuilds - especially if you're on Enterprise Edition and that MAXDOP = 8 is helping you more than MAXDOP = 1 would.  I agree...

Please keep us updated on which CU actually fixes this; we do sometimes, though rarely, have single user mode databases, and we use dm_exec_requests for some monitoring, so this is...

I've seen the same as everyone else - most things are the same or better, a few are very much worse.

My best advice if you have a lot...

I've just restored the previous server's ReportServer database to the new server and all the subscriptions were set up on the new server automatically.

I would note that to be comprehensive, it needs to have a setting for Leap Day babies as well.

When calculating age for someone whose birthdate is on a...

Or just create a formula in Excel similar to

=CONCATENATE("INSERT INTO table (fields) VALUES ('",A2


and so on and so forth

Drag the formula down, then...

Data goes as follows:
Client <-> SQL  - "data in motion" - to encrypt, have data encrypted before it's sent to SQL or use SQL Server Configuration Manager,...

I think I'm agreement with several of the other posters.

RDP to a SQL Server is BAD, UNLESS you are a systems DBA doing maintenance or OS level investigation....

That's an interesting interview question.

I would recommend that you consider advantages and disadvantages from different points of view; an advantage for A is often a disadvantage for B,...

Well, MSDN Subscriptions have limited test rights:

https://msdn.microsoft.com/en-us/subscriptions/hh297076.aspx

ADDITIONAL LICENSE TERMS. The following provisions apply to software provided with the subscription.

  Acceptance Testing...