Viewing 15 posts - 12,091 through 12,105 (of 39,804 total)
July 19, 2013 at 11:25 am
Steve-3_5_7_9 (7/19/2013)
TempDB should be sized just like any other database. One should know their workload, or at least monitor the TempDB over several weeks to see what is a...
July 19, 2013 at 11:25 am
djackson 22568 (7/18/2013)
July 19, 2013 at 11:16 am
Henry_Lee (7/18/2013)
July 19, 2013 at 11:14 am
L' Eomot Inversé (7/17/2013)
why should they need a ribbon bar when they know how to waste far more screen space without having one?
Careful, I like the ribbons.
you just might get...
July 18, 2013 at 11:19 am
Evgeny (7/18/2013)
In question, you should mention that first 2 steps should be performed on master database.
why? The question isn't about performing every step. It's just to ensure you understand...
July 18, 2013 at 11:18 am
You may have the active portion of the log at the end of the file, which prevents it from shrinking. One of the things you can do is run some...
July 18, 2013 at 9:25 am
You might also track some of the existing waits with regards to IO. http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
July 18, 2013 at 9:24 am
I suspect you had someone setting this up that didn't understand RPO/RTO and was just managing the log size, not worrying about recovery.
I'd make the logs more frequent.
July 18, 2013 at 9:23 am
LEFT, SUBSTRING, you need to limit the amount of data updated, as Eugene noted.
July 18, 2013 at 9:21 am
Have you setup clustering? If not, you might want to hire someone as a consultant to help you here.
It's unclear what you are trying to accomplish with a cluster. You...
July 18, 2013 at 9:19 am
Brandie Tarvin (7/17/2013)
I see a SQL Spackle article in my future... Plus a blog post followup.
Write it up and send it in
July 17, 2013 at 12:01 pm
Koen Verbeeck (7/17/2013)
Jeff Moden (7/16/2013)
Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.BWAAA-HAAA!!!! You mean like the stuff that generates the SSC News Letter? :sick::-D:-P
Touché 😀
Yeah, that's been...
July 17, 2013 at 7:52 am
Most days software works flawlessly for me. I have a small domain of things I do, and they work great.
The last two days I've expanded into the continuous integration world,...
July 16, 2013 at 3:56 pm
Arrgggg, some days I hate software.
July 16, 2013 at 1:21 pm
Viewing 15 posts - 12,091 through 12,105 (of 39,804 total)