Viewing 15 posts - 42,511 through 42,525 (of 49,552 total)
My guess is that you have autogrow enabled, one of more files grew and completely overloaded the IO system.
Either set smaller autogrow increments or (preferably) monitor the free space in...
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
December 8, 2008 at 2:22 am
Maybe I'm missing something, but the two queries unioned look the same.
Why do you need to union 24 results sets? There may be a better way.
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
December 8, 2008 at 1:39 am
leonp (12/7/2008)
but I also want to understand where Jeff and Gail were going with their queries before I draw any conclusions
What I'm trying to get at is whether the...
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
December 8, 2008 at 12:42 am
leonp (12/7/2008)
I guess point-in-time recovery doesn't mean a lot to our users for this DB.
Have you asked them?
I can't tell you what the best backup type is. Only...
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
December 7, 2008 at 10:17 am
Means either the SQL service is restarting every night, or there's a job that's cycling the error log (sp_cycleerrorlog)
Check the beginning of the new error log, either you'll see SQL's...
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
December 7, 2008 at 10:13 am
debjani.bedajana (12/7/2008)
Gail,And I can run the execution plan in SQL 2000 query analyzer. But it is not letting me save it.
Please post in the correct forum in the future. If...
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
December 7, 2008 at 9:54 am
The question you should ask yourself in this situation is the following.
"If the DB fails 10 hours after the last full/diff backup, is the loss of all changes made in...
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
December 7, 2008 at 1:51 am
There's very little difference, as far as the query optimiser's concerned, between a join condition and a where clause predicate.
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
December 6, 2008 at 1:31 pm
2) Restore all log backups up to the point of the corruption. Use the same STOPAT and NORECOVERY options on each one.
3) Immediately perform a full backup of the database...
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
December 6, 2008 at 1:07 pm
sqlguy (12/6/2008)
Grant Fritchey (12/6/2008)
You mentioned that there are some types of joins that could prevent index usage. Can you give me an example of this?
CAST(Table1.Col1 AS INT) = CAST(Table2.Col1...
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
December 6, 2008 at 1:01 pm
Derek (12/6/2008)
Could it be possible in the FROM?
No. Same problem as in the where. Join conditions must be conditions, not statements.
Just trying to parse that query shows that it won't...
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
December 6, 2008 at 3:05 am
Derek (12/6/2008)
I would think WHERE (dbo.tblSkillsetType.SQLSnippet) would cause an error
Yes it will. The where clause must consist of conditions, where one expression is compared against another. As I said in...
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
December 6, 2008 at 2:26 am
The only way to do that is to use dynamic SQL, build up the final query and then use sp_executeSQL to run it.
Be aware of the downsides of dynamic SQL...
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
December 6, 2008 at 1:32 am
Does the directory 'R:\MSSQL\BACKUP' exist?
Is there anything more useful in the SQL error log
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
December 6, 2008 at 1:22 am
sqlguy (12/5/2008)
And I know that if a query has 5 or more tables then this indicates that the query should be refactored.
Why 5? What's magic about a 5 table...
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
December 6, 2008 at 1:21 am
Viewing 15 posts - 42,511 through 42,525 (of 49,552 total)