Viewing 15 posts - 8,776 through 8,790 (of 49,571 total)
smtzac (6/10/2014)
My question is IN MY SITUATION what's the 'desirable size' would be? another word what size should I give to log file after above process?
The max amount of space...
June 10, 2014 at 9:24 am
Whether it's feasible or not depends on whether it meets your RTO and RPO requirements. I can't answer that.
Adding diffs every 4 hours to your current strategy will reduce the...
June 10, 2014 at 8:04 am
When do you want to run the diffs?
June 10, 2014 at 7:49 am
You restored the full backup WITH RECOVERY (the default), hence SQL recovered the database and brought it online at the end of the restore, allowing no further backups to be...
June 10, 2014 at 7:46 am
Andrew Kernodle (6/10/2014)
... *Facepalm* Yep, it certainly does.
So writers don't block readers, instead the read query fetches the previous version out of the version store. The update...
June 10, 2014 at 7:43 am
SQLRNNR (6/10/2014)
Gailforgotwas too lazy tomentionlook up the URL for her blog post on the topic while at work
😀
June 10, 2014 at 7:42 am
dax.latchford (6/10/2014)
Also what would be a 'Best Practice' approach to shrink the log file?
I thought I already answered that. If you have regular log backups running, then do a once-off...
June 10, 2014 at 7:29 am
dax.latchford (6/10/2014)
(1) Change the Recovery mode from Full to Simple
(2) Run a backup against the DB
(3) Check the location of...
June 10, 2014 at 7:17 am
Jeff Moden (6/10/2014)
That's not what I've heard, though.
Maybe spend some time with Kalen's whitepaper? Lots of people have said lots of garbage about Hekaton.
I've heard terms such as "Delayed Durability"...
June 10, 2014 at 7:03 am
Jeff Moden (6/10/2014)
Grant Fritchey (6/9/2014)
June 10, 2014 at 6:21 am
wall str33t (6/9/2014)
In clauses are generally slower because people write them instead of joins,
Are you sure about that? Got some reproducible examples which show that 'ins are generally slower than...
June 10, 2014 at 4:45 am
To start with... https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
That should guide you through identifying and fixing most deadlocks. They do have to be investigated and fixed one by one, there's no magic switch you can...
June 10, 2014 at 4:37 am
Sure, why wouldn't it be?
June 10, 2014 at 3:47 am
Was there another line in the message which you didn't post?
June 10, 2014 at 3:47 am
And it was the entire output, no extra lines that you didn't post?
June 10, 2014 at 3:40 am
Viewing 15 posts - 8,776 through 8,790 (of 49,571 total)