Viewing 15 posts - 1 through 15 (of 813 total)
January 12, 2018 at 7:58 am
January 6, 2018 at 10:21 pm
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...
January 6, 2018 at 2:52 pm
I have one question, I'm using...
December 7, 2017 at 9:29 am
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...
July 11, 2017 at 3:02 pm
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...
May 26, 2017 at 2:54 pm
March 30, 2017 at 5:02 pm
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.
March 30, 2017 at 3:25 pm
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...
March 30, 2017 at 2:38 pm
Or just create a formula in Excel similar to=CONCATENATE("INSERT INTO table (fields) VALUES ('",A2
=CONCATENATE("INSERT INTO table (fields) VALUES ('",A2
and so on and so forth
Drag the formula down, then...
March 27, 2017 at 11:56 am
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,...
March 9, 2017 at 5:25 pm
March 7, 2017 at 3:22 pm
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....
March 7, 2017 at 3:03 pm
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,...
February 6, 2017 at 9:46 pm
Well, MSDN Subscriptions have limited test rights:
ADDITIONAL LICENSE TERMS. The following provisions apply to software provided with the subscription.
January 30, 2017 at 11:12 pm