Viewing 15 posts - 7,876 through 7,890 (of 49,571 total)
sqlsurfing (9/10/2014)
I think i'll focus on working w/developer on any tweaks first on that blocking sproc first.
Good idea. Can't see anything in the code you posted...
September 11, 2014 at 12:06 am
Sean Perkins (9/10/2014)
So, the process of shrinking log files (or data files) won't cause a ridiculous performance hit during production hours?
Shrinking data files certainly will.
Shrinking log shouldn't, but do it...
September 10, 2014 at 3:03 pm
Steps:
1. Backup the TLOG
2. Change DB from Full to Simple
3. Change the initial size of the TLOG to something much smaller
4. Perform the log shrink
5. Change from Simple to Full
6....
September 10, 2014 at 2:52 pm
And thank you. The 24hop session was better received than I'd expected, seeing as it's fairly dry internals all the way through.
September 10, 2014 at 1:51 pm
Grant Fritchey (9/10/2014)
I'd love to present with Gail again, regardless of the harm we would inflict on others. We had way too much fun.
Shall we try for Bits next year?
September 10, 2014 at 1:50 pm
GilaMonster (4/11/2011)
Please post new questions in a new thread. Thank you.
September 10, 2014 at 1:42 pm
sqldriver (9/10/2014)
Has anyone seen them together at the same time? They sound awfully alike.
Yes, I assure you many, many people have seen us both at the same time. Including an...
September 10, 2014 at 1:39 pm
Waaaaay out of his depth... http://www.sqlservercentral.com/Forums/Topic1612186-357-1.aspx
September 10, 2014 at 1:33 pm
cafescott (9/10/2014)
September 10, 2014 at 1:28 pm
Because if you recover the DB (bring it online), thereby removing the restoring status as you asked, you won't be able to restore more log backups and hence your log...
September 10, 2014 at 11:37 am
dinsab11 (9/10/2014)
@GilaMonster: My questin was what's the best way to check when statistics were update last time on A DATABASE (all table).
Query sys.stats and use the STATS_DATE function. It...
September 10, 2014 at 11:32 am
Sean Lange (9/10/2014)
Steve Jones - SSC Editor (9/10/2014)
WayneS (9/10/2014)
Sean Lange (9/9/2014)
September 10, 2014 at 10:42 am
er.mayankshukla (9/10/2014)
I guess some heavy updates might be the reason for that
Might be. Or might not. I prefer not to assume such things when I have no idea.
Even if heavy...
September 10, 2014 at 10:38 am
er.mayankshukla (9/10/2014)
September 10, 2014 at 10:05 am
Viewing 15 posts - 7,876 through 7,890 (of 49,571 total)