Viewing 15 posts - 24,586 through 24,600 (of 49,552 total)
Stefan Krzywicki (7/29/2011)
Can you just use Google Documents from the iPad?
There an offline version of that? (Internet access? What's that?)
Do they support Word's review/comment features? Word's tables, formatting, etc? Can...
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
July 29, 2011 at 1:48 pm
Rather leave it at the size it needs to be unless you're absolutely desperate for space. A large log does not impact the DB. Log growth on the other hand...
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
July 29, 2011 at 1:45 pm
Stefan Krzywicki (7/29/2011)
On the desktop, there's much more to play, Civ V, City of Heroes, Europa Universalis III, EuroRails, etc...
I am resisting Civ 5. Want, but...
At the moment, Witcher (1),...
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
July 29, 2011 at 1:41 pm
Steve Jones - SSC Editor (7/29/2011)
GilaMonster (7/29/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
July 29, 2011 at 1:38 pm
Stefan Krzywicki (7/29/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
July 29, 2011 at 1:33 pm
I do very little productive on the phone. It's great for shopping lists, much reduces the chance I'll write a list and leave it at home. Twitter on the move,...
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
July 29, 2011 at 12:37 pm
In this case a Constant Scan, cause that's all you're doing, reading a couple of constants.
If the first was using a temp table (which it's not) there would be some...
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
July 29, 2011 at 11:48 am
No difference at all. Look at the execution plans, they'll be exactly the same.
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
July 29, 2011 at 11:40 am
ramprabhakar.n (7/29/2011)
Every time if I truncate the log with truncate_only option ...
Why are you truncating the log? There is no good reason to do that regularly.
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
July 29, 2011 at 9:09 am
mike.mcquillan (7/29/2011)
According to Microsoft's site, 60% pass the lab first time, with 80% passing the second time.
I suspect that was from back when the MCM was a 3 week training...
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
July 29, 2011 at 9:05 am
Then work through this:
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
July 29, 2011 at 8:22 am
Is the log reader running?
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
July 29, 2011 at 8:04 am
Ninja's_RGR'us (7/29/2011)
GilaMonster (7/29/2011)
talkeffect (7/29/2011)
How is Knowledge Exam? Is it like 70-451 and 70-450 or a little bit harder?
Try several hundred times harder. It's also significantly more expensive. iirc $500 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
July 29, 2011 at 7:48 am
I'm getting way too snide and cynical. Maybe time to take a short forum break again...
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
July 29, 2011 at 7:36 am
SQLRO (7/29/2011)
Actually nobody did the restore manually but the server was restarted once by the infra team...really not sure what has caused these entries in the error logs.
The only thing...
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
July 29, 2011 at 7:30 am
Viewing 15 posts - 24,586 through 24,600 (of 49,552 total)