Viewing 15 posts - 811 through 825 (of 1,838 total)
August 10, 2017 at 7:28 am
August 10, 2017 at 7:23 am
I'd think that Database Developers would be required to be in a separate group from DBAs, especially if you're in a public company, as a separation of duties thing. I...
August 9, 2017 at 12:15 pm
I've found that a lot of the problems that are "database" issues turn out to be queries that have either incomplete joins (for tables that have multi-column primary keys) or...
August 9, 2017 at 10:49 am
August 8, 2017 at 6:17 am
I also notice that it has a degree of parallelism of 16 which seems high. Guidance from Microsoft suggests this probably shouldn't be more than 8:
https://support.microsoft.com/en-us/help/2806535/recommendations-and-guidelines-for-the-max-degree-of-parallelism-confi
August 7, 2017 at 2:48 pm
residual IO means that the database engine did a lot more reads than necessary, for example:
Tax_Name_To_DDA, which is listed as a HEAP, has 4 full table scans on it. ...
August 7, 2017 at 2:33 pm
August 7, 2017 at 1:02 pm
a couple of initial comments based on the query plan:
- there are a number of places that the actual number of rows far exceeds the estimated number of rows,...
August 7, 2017 at 12:57 pm
This is why some tasks on your personal list seem to never get done--they are never...
August 7, 2017 at 12:37 pm
August 7, 2017 at 12:16 pm
I tend to not think of the to do items so much as a "list". I see them as a stack of queues. If something comes in at a priority that I...
August 7, 2017 at 8:01 am
have you tried just scripting out the login creation?CREATE LOGIN [DomainB\ADaccountName] FROM WINDOWS;
August 4, 2017 at 1:24 pm
If there were still computers, I'd probably still be a developer then. If we are asking the question assuming non-computer jobs, I'd probably say some kind of woodworking.
August 4, 2017 at 11:49 am
August 4, 2017 at 11:48 am
Viewing 15 posts - 811 through 825 (of 1,838 total)