Viewing 15 posts - 25,426 through 25,440 (of 49,552 total)
Check the logs, see if there are any messages for MSDB. Check the state of MSDB. SQLAgent shouldn't depend on a user DB.
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
June 17, 2011 at 11:15 am
glen.wass (6/17/2011)
HI, try looking up variable temp tables, as i understand it these work from memory
Nope. Same rules as temp tables as to whether they are in memory 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
June 17, 2011 at 11:13 am
AlexGreen (6/17/2011)
SQL Server has three recovery models:Simple: This model minimally logs most transactions.
Simple minimally logs the same operations that bulk-logged minimally logs. The difference is that log records are inactive...
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
June 17, 2011 at 8:55 am
There will be a time estimation after the %. It's usually on the low side.
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
June 17, 2011 at 8:43 am
The Dixie Flatline (6/17/2011)
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
June 17, 2011 at 8:36 am
You don't need this predicate - b.UserString6 is not null - it's covered by the other one.
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
June 17, 2011 at 7:40 am
Post new exec plans
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
June 17, 2011 at 7:29 am
He's suggesting replacing both predicates you have with the one he suggested. They are synonymous.
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
June 17, 2011 at 7:17 am
And the blog post that Brandie listed explains that and what copy_only backups are really for.
Log backups are only based on the previous log backup, not fulls or diffs. 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
June 17, 2011 at 4:40 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 17, 2011 at 4:39 am
Not really. It's a point-in-time, read-only view of a 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
June 17, 2011 at 4:25 am
Good luck.
If you want help, you're going to have to post a lot more detail than the performance stats.
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
June 17, 2011 at 4:10 am
sqlnes (6/17/2011)
(i think if the file was too big will affect preformance).
Nope.
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
June 17, 2011 at 4:04 am
mike.mcquillan (6/17/2011)
You are right - my bad. Sorry everybody!
Don't apologies, you're right.
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
June 17, 2011 at 3:32 am
John Mitchell-245523 (6/17/2011)
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
June 17, 2011 at 3:04 am
Viewing 15 posts - 25,426 through 25,440 (of 49,552 total)