Viewing 15 posts - 331 through 345 (of 1,129 total)
JackIntheBox (5/20/2013)
curious_sqldba (5/17/2013)
May 20, 2013 at 8:12 pm
GilaMonster (5/19/2013)
* The queries are not logically equivalent
* The different form resulted in the optimiser searching a different area of the plan space and...
May 19, 2013 at 2:48 pm
GilaMonster (5/19/2013)
Completely irrelevant. Order that you specify the joins is not the order they are executed in, unless you're forcing join order.Check that the queries are logically equivalent.
In my actual...
May 19, 2013 at 9:36 am
Eric M Russell (5/16/2013)
curious_sqldba (5/16/2013)
Ok makes sense, i am joining on a table and a view, i might have to add this column on all the underlying tables...
I don't know...
May 16, 2013 at 10:17 am
curious_sqldba (5/15/2013)
Eric M Russell (5/15/2013)
WHERE A.Pid = 9
AND ( Isnull(A.ID, 0) <> Isnull(V.ID, 0)
...
May 16, 2013 at 9:19 am
Eric M Russell (5/15/2013)
WHERE A.Pid = 9
AND ( Isnull(A.ID, 0) <> Isnull(V.ID, 0)
...
May 15, 2013 at 8:40 pm
i can try to get the schema.
In the meanwhile is there a better way to write this piece:
where Isnull(A.FPID, '') <> Isnull(V.FPID, '')
May 15, 2013 at 12:30 pm
dedicatedtosql (5/9/2013)
May 14, 2013 at 2:15 pm
ChrisM@Work (5/8/2013)
curious_sqldba (5/7/2013)
May 8, 2013 at 8:20 am
Paul Randal (4/18/2013)
Correct. Although manual use of database snapshots is only in Enterprise Edition, DBCC's use of them is in every edition down to Express.
Kalen mentioned in this http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/10/dbcc-hidden-snapshot.aspx:
'Running your...
April 18, 2013 at 12:52 pm
Paul Randal (4/18/2013)
You don't. Only if you want to control where the snapshot goes do you need to do that.
So i can run DBCC CHeckdb ('MyDB') on standard edition and...
April 18, 2013 at 11:07 am
Paul Randal (4/18/2013)
It used to take table locks in 7.0 - from 2000 onwards it's been online by default, with no table locks.
Thanks Paul. If DBCC doesn't place any table...
April 18, 2013 at 10:52 am
GilaMonster (4/17/2013)
April 17, 2013 at 2:18 pm
GilaMonster (4/17/2013)
curious_sqldba (4/17/2013)
However i am still not clear what 'Hidden Snapshot' means?Exactly that. It's a database snapshot that's hidden from view (not in the system tables)
So i am able to...
April 17, 2013 at 12:09 pm
This http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/10/dbcc-hidden-snapshot.aspx answered my question.
However i am still not clear what 'Hidden Snapshot' means?
April 17, 2013 at 10:08 am
Viewing 15 posts - 331 through 345 (of 1,129 total)