Viewing 15 posts - 4,906 through 4,920 (of 49,571 total)
We can't tune it if we can't see it.
If you can;'t post it, then you're going to have to rewrite it yourself into the form of an in-line table valued...
August 27, 2015 at 6:44 am
JaybeeSQL (8/27/2015)
Should the system databases be best moved in any particular order?
To be honest, other than TempDB, I'd probably leave the others alone for now. Moving master is not the...
August 27, 2015 at 5:04 am
Pro-active performance monitoring. Not 'what's slow right now', but rather trends and historical data. What was procedure x performing like last week compared with today. Wait stats and IO stats...
August 27, 2015 at 5:02 am
Restore from your last good backup (plus log backups)
Repair is usually a last resort for when you don't have backups.
August 27, 2015 at 4:19 am
Same effects as if you were using it without snapshot turned on. Duplicate reads, missing rows, dirty reads and this time for no gain at all because under RCSI readers...
August 27, 2015 at 4:15 am
You're summing the CPU up over the 6 hours. In total, over 6 hour real period, that query did a total of 135 hours of CPU time, easy enough to...
August 27, 2015 at 4:09 am
Since it's an indexed view, giving us the definition of the view is useless from the point of tuning. You need to identify the queries using the view that are...
August 27, 2015 at 4:07 am
Round it to what?
7.84 should become:
8?
7.8?
7.84?
7.840?
Something else?
August 26, 2015 at 3:05 pm
Robert W Marda (8/26/2015)
August 26, 2015 at 1:26 pm
What you're asking for would complicate the lock manager massively, it would also break the isolation (and probably consistency) guarantees which SQL has to provide.
If a deadlock victim, instead of...
August 26, 2015 at 12:19 pm
mitzyturbo (8/26/2015)
It is performing an index seek though oddly enough.
With the query you posted and the two indexes you posted, there is no way that SQL can perform an index...
August 26, 2015 at 11:46 am
No.
August 26, 2015 at 11:42 am
I do. All my colleagues and clients, whose machines I end up working on from time to time while helping/consulting, not so much.
And you've changed snippets. de <space> gets me...
August 26, 2015 at 8:09 am
That would be a far better question, because there's no SQL command to add drives to a server. 😉
Firstly, you don't want to move the binaries, as that would require...
August 26, 2015 at 8:00 am
Gazareth (8/26/2015)
But probably the most common: DELCARE left left left backspace left C 😛
In that case, mine would be SEELCT left left backspace left L :hehe:
August 26, 2015 at 7:26 am
Viewing 15 posts - 4,906 through 4,920 (of 49,571 total)