Viewing 15 posts - 26,326 through 26,340 (of 49,552 total)
I've heard good things about the Pocket guide, but haven't used it myself (I studied out of Books Online for 450, and for all the other 2008 exams)
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 4, 2011 at 8:09 am
PageIOLatch is a disk -> memory wait (in general). SQL's loading the data it needs from disk into the buffer pool.
I'd check that the query isn't reading more than...
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 4, 2011 at 7:59 am
Grant Fritchey (5/4/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
May 4, 2011 at 7:50 am
Please don't start multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1102345-391-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 4, 2011 at 7:30 am
Jack Corbett (5/4/2011)
Hmmm, I'm surprised that they wouldn't allow you to present jointly with Adam since all the training wouldn't be on your shoulders and Adam has done several pre-con's.
Was...
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 4, 2011 at 7:27 am
Have a look at the redgate tool Ninja mentioned, or consider something manual (like RedGate's SQLDataCompare)
There's no way to take a backup of a portion of the data in each...
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 4, 2011 at 7:19 am
Daily is not enough for log backups. The interval between log backups should be the maximum amount of data you are willing to lose in a disaster.
Log backups are...
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 4, 2011 at 5:48 am
SQL_Helper (5/4/2011)
We are taking daily full databases backup but not taking backup of transaction log, (dont want to take backup of log file).
If you are in full recovery model, you...
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 4, 2011 at 4:29 am
Because Books Online was redone between 2000 and 2005.
Use google.
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 4, 2011 at 3:07 am
How often are you taking log backups?
Please read through this: http://www.sqlservercentral.com/articles/64582/
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 4, 2011 at 2:33 am
[Jim].[dba].[Murphy] (5/3/2011)
Maybe on your website, you can do a PayPal sort of 'save the speaker' (memories of the movie Faris Beuler)?
Between exchange control fees and taxes I might...
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:50 pm
Craig Farrell (5/3/2011)
GilaMonster (5/3/2011)
Craig Farrell (5/3/2011)
GilaMonster (5/3/2011)
Thanks everyoneIronic that the session from 24HoP was one I wasn't considering submitting for summit
Of course the real killer is are they paying for...
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:21 pm
Craig Farrell (5/3/2011)
GilaMonster (5/3/2011)
Thanks everyoneIronic that the session from 24HoP was one I wasn't considering submitting for summit
Of course the real killer is are they paying for travel and expenses...
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:14 pm
Jack Corbett (5/3/2011)
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.
Well deserved Gail, but I don't think you had to worry too much about being...
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:11 pm
Thanks everyone
Ironic that the session from 24HoP was one I wasn't considering submitting for summit
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:10 pm
Viewing 15 posts - 26,326 through 26,340 (of 49,552 total)