Viewing 15 posts - 26,371 through 26,385 (of 49,552 total)
I still don't understand what you're getting at...
My previous statement was about backups WITHOUT copy_only. Neither full nor diff will break log shipping and no backup will break mirroring.
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
May 3, 2011 at 2:20 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1102133-364-1.aspx
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
May 3, 2011 at 2:02 am
Not just disaster recovery. The log is used for transaction rollbacks and restart-recovery, among other things.
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
May 3, 2011 at 2:01 am
Don't understand your question.
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
May 3, 2011 at 1:57 am
LOB data does use the buffer pool. It's paged allocations, part of the data cache.
The setting of memtoleave (-g) is only applicable on 32-bit instances. What's the relevance of 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
May 3, 2011 at 1:55 am
sgvv (5/3/2011)
Have TABLOCK hint placed on the table.This will be minimally logged.
http://msdn.microsoft.com/en-us/library/ms190422(v=SQL.90).aspx
Deletes are never minimally logged, regardless of locks or recovery model.
Your link talks about bulk import, ie inserting rows,...
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
May 3, 2011 at 12:35 am
Please post new questions in a new thread, don't hijack other people's threads.
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
May 3, 2011 at 12:33 am
sgvv (5/3/2011)
Moreover he has moved the DB to another server, which requires Update statistics be Run.
Moving a DB from one server to another does not require update stats, not unless...
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
May 3, 2011 at 12:32 am
All tables should have a clustered index (with a few specific exceptions)
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
May 2, 2011 at 11:57 pm
sgvv (5/2/2011)
Try Updating statistics of all tables with full scan
How is that going to help re-enable the index?
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
May 2, 2011 at 11:48 pm
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
May 2, 2011 at 11:38 pm
Grant Fritchey (5/2/2011)
GilaMonster (5/2/2011)
Woot!!!!!!!!!!http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Well earned too. Congratulations! Nothing like knowing you have a reservation.
And an invitation for a spotlight that I thought I'd missed out on by not being there...
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
May 2, 2011 at 11:36 pm
Separate log backups most certainly will affect log shipping. If you're log shipping you cannot be taking log backups any other way. Full and diff backups won't break log shipping...
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
May 2, 2011 at 11:34 pm
Woot!!!!!!!!!!
http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
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
May 2, 2011 at 5:00 pm
Hey Grant, due to the Order By that SQL Pass uses on the submitted sessions page, you and I are listed consecutively for all sessions. 🙂
Totally irrelevant and useless, I...
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
May 2, 2011 at 4:05 pm
Viewing 15 posts - 26,371 through 26,385 (of 49,552 total)