Viewing 15 posts - 41,896 through 41,910 (of 49,562 total)
sys.tables, sys.columns, sys.foreign_keys, sys.foreign_key_columns, sys.indexes where is_primary_key=1, sys.index_columns
It's a nasty, very large query, but those are the tables needed. If you get stuck, post the query that you have.
One other...
January 7, 2009 at 11:29 pm
To add on to what Barry said, there is no way to take a backup of a 2005 database and restore it on 2000, nor is it possible to detach...
January 7, 2009 at 11:25 pm
Peter D (1/7/2009)
January 7, 2009 at 11:21 pm
Lowell (1/7/2009)
if you had read the chapter or listened to the lecture in class....
Yeah, probably.
January 7, 2009 at 2:44 pm
Eeep. That's a lot of execution plans.
I'm not looking at all of them. That'll take hours.
A few highlights:
Exec plan 3:
The country table needs an index. CountryID INCLUDE name, or,...
January 7, 2009 at 1:53 pm
Lynn Pettis (1/7/2009)
GilaMonster (1/7/2009)
Lynn Pettis (1/7/2009)
hmmm, a question I sense here but not sure what you want.Are you channelling Yoda again?
Sorry, caught a couple of the Star Wars movies on...
January 7, 2009 at 1:43 pm
Lynn Pettis (1/7/2009)
hmmm, a question I sense here but not sure what you want.
Are you channelling Yoda again?
January 7, 2009 at 1:32 pm
IF EXISTS (SELECT 1 FROM SomeTable WHERE SomeKey = @SomeValue)
UPDATE ...
ELSE
INSERT ...
Edit: The question was (paraphrased)
If I have a table and I want to check based on a...
January 7, 2009 at 1:31 pm
RBarryYoung (12/31/2008)
[h2]If your data is important to you then Back It Up![/h2]
And to add to that.
Any backup not tested cannot be considered a valid backup. If it's worth backing...
January 7, 2009 at 12:58 pm
Steve Jones - Editor (1/7/2009)
January 7, 2009 at 9:12 am
Christopher Stobbs (1/7/2009)
Hi Gail,After the first seek is done are the other filters done on the index or resultant dataset return from the first filter(Index seek)
The latter.
The index seek results...
January 7, 2009 at 8:57 am
Since all of the filters are inequalities, SQL can only seek on one of them. The other two have to be applied as a second step after the index seek....
January 7, 2009 at 8:38 am
winston Smith (1/7/2009)
which is better and why?create index index1 on table1 (col1, col2, col3)
or create index on table1 (col1)
include(col2, col3)
Depends what you're trying to accomplish
The first fully covers and...
January 7, 2009 at 8:14 am
Use Statistics IO and Statistics Time when you're investigating the procs themselves, along with the exec plan, to see where the problem points are.
January 7, 2009 at 8:09 am
gharris_35 (1/7/2009)
HiI have uploaded the estimated plan. See Estimated Plan.zip
Did you check that before you posted? 😉
Management studio saves plans one at a time, so all that's attached is...
January 7, 2009 at 7:22 am
Viewing 15 posts - 41,896 through 41,910 (of 49,562 total)