Viewing 15 posts - 41,881 through 41,895 (of 49,552 total)
sampathsoft (1/8/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 8, 2009 at 4:53 am
Can you please post exactly what you get by running the following:
DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 8, 2009 at 4:50 am
winston Smith (1/8/2009)
the actual clustered index/heap never needs to be accessed. am i correct in this idea?
Correct, all the info is in the index.
if this is the only index on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 8, 2009 at 4:36 am
What does the error log say? It should have some info about the shutdown, and it will have a lot of info about why the service won't start up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 7, 2009 at 11:34 pm
Turn traceflag 1222 on (DBCC TRACEON (1222,-1))
Any deadlocks that occur will have the deadlock graph written to the error log. The deadlock graph will have enough information to locate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 7, 2009 at 11:33 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 7, 2009 at 11:25 pm
Peter D (1/7/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 7, 2009 at 12:58 pm
Steve Jones - Editor (1/7/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 7, 2009 at 9:12 am
Viewing 15 posts - 41,881 through 41,895 (of 49,552 total)