Viewing 15 posts - 751 through 765 (of 1,999 total)
Replication uses has far more headaches than a simple linked server. I'm not against replication when it's really needed, of course, but I don't see that need here. I,...
October 29, 2019 at 3:48 pm
NO ONE IS ALLOWED TO DEPLOY THEIR OWN CODE TO PRODUCTION, PERIOD! Except for the addition of indexes, that includes me... the DBA.
when I worked as a test...
October 29, 2019 at 2:11 pm
In my current role, Scripts are executed by the Release Team, so it's difficult to hand them something that requires input e.g. changing the @doCommit value to commit the...
October 29, 2019 at 11:21 am
That's the downside of Dev-Ops I guess, where developers are allowed to change live data.
Interesting point, part of the devops process is about automated builds (including stopping people developing...
October 29, 2019 at 10:55 am
What about temporal tables for your tables that need to be recovered very fast?
good shout. worth looking into. I think our data churn is way too big for that...
October 29, 2019 at 10:50 am
Great comments throughout
one of the issues i'm looking at is that for a table with 50 million records backing up that entire table might not be practical - and how...
October 29, 2019 at 10:21 am
I'm not too worried about having some data latency because this will be a bulk overnight job that only runs once at night. I just need to to...
October 29, 2019 at 9:41 am
scott
cursor thresholds are a new one on me...help a fellow dba out
October 28, 2019 at 6:07 pm
transactional or snapshot replication..100% ... You want the data to be on your local drives. .. With replication it just keeps dribbling data.. The only bad bit is reinitialising. With...
October 28, 2019 at 5:57 pm
in that case the only other pertinent question is "how often and how many rows"..
if you are joining local to remote data in realtime then i'd use replication - if...
October 28, 2019 at 5:08 pm
Linked servers are going to give you a lot of headaches in terms of performance.
how many tables do you need to query on the 2008 instance? - it might be...
October 28, 2019 at 4:24 pm
Yep.
I've been pushing more and more to just get people in source control. By itself, no automation or another cool DevOpsy stuff, source control has benefits. Just gotta convince...
October 28, 2019 at 4:05 pm
one last thing... have you got a query plan for the process that "might" be causing you an issue...it could be as simple as a join or "order by" spooling...
October 28, 2019 at 3:28 pm
This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things the...
October 28, 2019 at 3:01 pm
the only thing I can think to suggest is in the code for the report, do something like..... scrape the report folder from the URL (or other ways) and try...
October 28, 2019 at 2:44 pm
Viewing 15 posts - 751 through 765 (of 1,999 total)