Viewing 15 posts - 4,111 through 4,125 (of 22,211 total)
January 13, 2017 at 11:09 am
It's hard to say for certain without seeing the execution plans. It could be contention on resources that's there in prod, but not QA. In addition to capturing and comparing the...
January 13, 2017 at 11:02 am
January 13, 2017 at 8:04 am
Just modify the capture script to include a filter for the database. You can modify it in that fashion.
January 13, 2017 at 7:45 am
Be sure that you have measurements of the I/O and execution time of the query from before adding that index. You don't want to tune just on whether or not...
January 13, 2017 at 7:43 am
However, this conversion isn't preventing the use of statistics or the index. Fix it? Sure. But it's not causing you performance headaches.
January 12, 2017 at 9:59 am
January 12, 2017 at 6:37 am
January 12, 2017 at 6:28 am
Brandie Tarvin (1/11/2017)
January 11, 2017 at 6:27 am
Brandie Tarvin (1/11/2017)
BLOB EATER (1/11/2017)
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)you have my vote!
So someone tell me who those "Steve Jones" and "Grant Fritchey" characters...
January 11, 2017 at 6:15 am
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)
DITTO!
(nudge, nudge, wink, wink).
January 11, 2017 at 6:13 am
dave-L (1/5/2017)
I have a active, highly relational, OLTP database
combined with
There are almost no foreign-key constraints defined in the dB
Effectively means that your database is not relational.
but I do not...
January 6, 2017 at 6:20 am
Ah, cool. I wouldn't even have thought to check that.
January 5, 2017 at 5:41 pm
They are certainly not making things easy. The "generic" approach is to use SQL Agent. I have never tried doing this without using Agent or a third party software.
If...
January 5, 2017 at 4:14 pm
May be a recent change then.
January 5, 2017 at 4:02 pm
Viewing 15 posts - 4,111 through 4,125 (of 22,211 total)