Viewing 15 posts - 3,346 through 3,360 (of 7,609 total)
To the OP:
I still wish you'd run the script I posted earlier and post the results (on Page 4; can't get the link to it to copy correctly right...
June 4, 2018 at 8:03 am
You want five separate stored procs regardless. Then, if you want only to have to call 1 main proc from the report/SSRS/whatever, create a parent/"driver" proc that executes those 5...
June 1, 2018 at 1:49 pm
For [AMT].[ItemVersions] :
If [Description] and [PropertyBag] are (1) used more than rarely *and* (2) are used in at least 1 time-critical task *and* (3) for a majority of rows,...
June 1, 2018 at 1:41 pm
Definitely need index overhauls. [And wow do you all love guids!] Would you mind running the script below and posting the results? I always prefer to tune including actual SQL...
June 1, 2018 at 1:10 pm
With the size of modern drives, and the number of files on each drive, I don't know that you truly get a stationary head sitting there waiting for the next...
June 1, 2018 at 8:14 am
We'll continue to have a difference of opinion there. As for 30 years...
May 31, 2018 at 3:18 pm
May 31, 2018 at 3:02 pm
May 31, 2018 at 12:16 pm
May 31, 2018 at 11:58 am
May 31, 2018 at 11:52 am
In that case, I guess I'd need to know what your definition of...
May 31, 2018 at 11:45 am
Not at all. Usually dbs perform better with more drives (more spindles really).
May 31, 2018 at 11:43 am
Viewing 15 posts - 3,346 through 3,360 (of 7,609 total)