Viewing 15 posts - 811 through 825 (of 8,416 total)
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?
I hope not, since I have done this a couple of times. ...
February 6, 2012 at 6:48 pm
GilaMonster (2/6/2012)
johnitech.itech (2/6/2012)
ok check below link plshttp://stackoverflow.com/questions/71022/sql-max-of-multiple-columns
What exactly does the link have to do with the question? The question is about restricting query costs, the link is about finding the...
February 6, 2012 at 6:44 pm
GilaMonster (2/4/2012)
Don't reinvent the wheel...http://sqlfool.com/2011/06/index-defrag-script-v4-1/
or
I very much prefer Ola's.
February 4, 2012 at 9:36 pm
Stephanie Giovannini (2/3/2012)
I hadn't thought of using MERGE when only type of operation could result, but it's valid.
Not only valid, it can be extremely useful: MERGE checks for double-row updates/deletes...
February 4, 2012 at 9:35 pm
Good question; there are a number of links you could have included in the explanation, but one of my favourites is this by Kalen Delaney:
February 4, 2012 at 8:58 pm
GSquared (2/2/2012)
If I'm not mistaken, both SQL Server Audit and Change Data Capture are Enterpise edition features. Or has that changed?
That's right.
And, yes Paul, instead-of triggers can do weird...
February 2, 2012 at 12:58 pm
Revenant (2/2/2012)
How do you remember what was or was not available in 6.5,...
February 2, 2012 at 10:18 am
cengland0 (2/2/2012)
Except, and correct me if I'm wrong, SQL Server Audit is only available in 2008 but the OUTPUT clause is available in 2005 and 2008.
That's right, and if you're...
February 2, 2012 at 9:37 am
danielfountain (2/1/2012)
Some bright spark has added in something like this into the codes.
C01 (Red)
So the code picks up the red, but also picks up yellow from the...
February 2, 2012 at 9:26 am
cengland0 (2/2/2012)
February 2, 2012 at 9:15 am
aaa-322853 (2/2/2012)
I know you can set it at a server level but does anyone know if it is possible to restrict certain user queries by maximum query cost?
Resource Governor does...
February 2, 2012 at 8:03 am
gorenak (2/2/2012)
ok thanks for answer, because I suspect that it is not random 😀
So long as you understand why you can't rely on it, that's cool.
February 2, 2012 at 7:59 am
George H. (2/2/2012)
Thanks for explaining it further!
No worries. While we're chatting, you might find this interesting too:
DECLARE @Example AS TABLE (col1 integer PRIMARY KEY);
-- Seek
SELECT * FROM @Example AS...
February 2, 2012 at 7:55 am
johnitech.itech (2/2/2012)
At any way you can follows basic rules to improve performance ashttp://dba.stackexchange.com/questions/6441/cxpacket-waits-performance-tune-for-sql-server-2008
Another random link from johnitech.itech *sigh*
February 2, 2012 at 7:40 am
Viewing 15 posts - 811 through 825 (of 8,416 total)