Viewing 15 posts - 136 through 150 (of 1,999 total)
chris is correct - if you keep over writing the last t-log backup then you don't have an effective DR plan
if the issue is that your t-logs are getting big...
March 6, 2020 at 11:54 am
your DB server should be in a DMZ (dead mans zone/demilitarised zone) which is effectively 2 firewalls
but if you want to allow client access to your data then you could...
March 6, 2020 at 11:06 am
normally you will get a rollback transaction that puts everything back into place, but if you have for example a sql agent job with 5 steps and you kill it...
March 6, 2020 at 10:58 am
1st question - how big is the database? just asking in case a normal snapshot might be a better option
March 6, 2020 at 10:53 am
joe - your examples didn't have a join in - they were single table selects
and I have to disagree, the reason we have Inner/outer join syntax makes code more readable...
March 6, 2020 at 9:12 am
I had this same conversation with an Nhibernate developer
he said it was just faster than writing stored procs
I asked him "would you write a c# class that exposed all of...
March 6, 2020 at 9:00 am
The trace flag can be set at the session level (add 1 line of code at the beginning of the proc). I wouldn't set this at the server level...
March 5, 2020 at 3:55 pm
you can't be 2 of the dwarfs at the same time
March 5, 2020 at 3:05 pm
rather surprised that table variable are faster.
normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the...
March 5, 2020 at 2:51 pm
rather surprised that table variable are faster.
normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the same indexes.
As...
March 5, 2020 at 1:51 pm
this is just one scenario - you know how it is?. find the proc that is causing you issues.... find out that the guy who wrote it left 3 years...
March 5, 2020 at 1:46 pm
thanks for the links guys
- afraid the option(recompile) would be a bugger to implement as it's at statement level and some of this code is maybe 7000 lines long (hence...
March 5, 2020 at 12:41 pm
who needs these new fangled inner and outer join types anyway? 🙂 they are so 1992 🙂
its 28 years since that standard came into play and i cannot understand why...
March 5, 2020 at 11:41 am
does your SQL code (that you haven't posted) use a linked server? if the linked server is being service packed or gets rebooted then this will occur
other than that erland ...
March 5, 2020 at 10:05 am
Seriously, though... I come across that tough? I thought I reserved that for JC.
nah, i know you are a big cuddly teddy bear underneath - now get back to...
March 5, 2020 at 9:01 am
Viewing 15 posts - 136 through 150 (of 1,999 total)