Viewing 15 posts - 34,141 through 34,155 (of 49,552 total)
Just bear in mind that the data in that DMV is since the last time the DB was started up. So if you restart the SQL instance frequently or have...
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
February 8, 2010 at 9:57 pm
Douglas Murphy (2/8/2010)
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
February 8, 2010 at 9:56 pm
Try a nonclustered index on (BlogID, Page, Deleted) on the DIM_Blog 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
February 8, 2010 at 9:51 pm
If you change to full recovery, you have to be running log backups.
Please read through this - Managing Transaction Logs[/url]
What's your reason for switching from Simple to Full? It's not...
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
February 8, 2010 at 9:48 pm
Joan OBryan (2/8/2010)
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
February 8, 2010 at 12:38 pm
Barkingdog (2/8/2010)[hrFor example, a field declared as varchar (100) will generally use less space than one defined as char(100). Assuming, of course, the data comes in a variety of lengths....
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
February 8, 2010 at 12:07 pm
george sibbald (2/8/2010)
to my mind MS should have gone the whole hog and called 2008 R2 SQL 2010, would have been more consistent with past practices.
Windows Server 2003, Windows Server...
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
February 8, 2010 at 9:30 am
Steve Jones - Editor (2/8/2010)
I didn't see your response as nasty. Came across fine to me.
The first draft was a little more vicious. I revised it before posting.
I have...
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
February 8, 2010 at 8:51 am
george sibbald (2/8/2010)
Will I be able to apply 2008 R2 SP1 to 2008 SP1?
I would highly doubt it, no more than you can apply SQL 2008 SP1 to SQL 2005...
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
February 8, 2010 at 8:49 am
Steve Jones - Editor (2/8/2010)
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
February 8, 2010 at 8:39 am
Maybe, maybe not.
Depends how big the DB is, how long it takes to backup full, diff or log, how long the restores take, what the downtime allowance of 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
February 8, 2010 at 8:35 am
george sibbald (2/8/2010)
at least we now know why it was called R2 and not just released as SP2!
Because it's not a service pack. It's a set of add-ons for 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
February 8, 2010 at 7:52 am
A copy_only doesn't reset the differential base. That's about it.
Depending on how active the DB is, those diffs may not be appreciably smaller than the fulls over a period of...
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
February 8, 2010 at 7:35 am
A suspect DB has to be set to Emergency mode before CheckDB can be run. There's a brief (one sentence) mention of running CheckDB in Scenario 3, right before 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
February 8, 2010 at 7:32 am
You could make every backup other than the sunday backup a COPY ONLY backup, however there's some problem in restoring copy_only backups using the management studio GUI (T-SQL script works...
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
February 8, 2010 at 7:16 am
Viewing 15 posts - 34,141 through 34,155 (of 49,552 total)