Viewing 13 posts - 1 through 13 (of 13 total)
Good start with setting immediate sync OFF.
I'd take a look at your Publication Properties >> Subscription options. Turning off "allow anonymous subscriptions" will let your distribution database delete transactions...
October 11, 2016 at 2:18 pm
John Mitchell-245523 (8/4/2016)
You're trying to insert from the dim_person.person_name column, which is (presumably) nvarchar into the person_Ext column in your temp table, which is int.John
Yup,
Try flipping the order of...
August 4, 2016 at 9:01 am
Well that's nice to hear!
I don't think that anything that connects to our SQL databases (ERP, WMS, CRM) is that rigid in requiring SQL Auth - I'm pretty sure everything...
February 18, 2016 at 1:31 pm
We actually are in the process of converting all of our raw excel queries into stored procs for that reason. If we disallow all but a certain AD group...
February 18, 2016 at 12:55 pm
I'm slightly confused as to how they would circumvent if we are using AD only. By disabling SQL logins, it forces the SQL server to use the AD group-member...
February 18, 2016 at 10:30 am
We are looking at implementing this at my job. We do have full control over the AD groupings because we are a small enough company.
What I'm worried about is...
February 18, 2016 at 7:18 am
GilaMonster (11/9/2015)
andrew.leef (11/9/2015)
But we use it mostly for reporting, so generally it doesn't matter if a transaction is in process at the time.
So your users are perfectly happy getting reports...
November 9, 2015 at 2:30 pm
GilaMonster (11/9/2015)
Since read committed snapshot already takes no read locks, using nolock gets you all of the disadvantages of that isolation level (dirty...
November 9, 2015 at 2:17 pm
We use NOLOCK in all of our TSQL that doesn't require an INSERT, UPDATE or DELETE. But we use it mostly for reporting, so generally it doesn't matter if...
November 9, 2015 at 2:12 pm
We were able to run UA this weekend on our production server (2008r2), and it came back with only 2 warnings, one about max of 64gb ram, and the other...
November 9, 2015 at 12:08 pm
Ohh, I get what you were saying now.
No, we installed 2008 on our test server, in order to run the 2014 Upgrade Advisor - but got no results. We...
November 3, 2015 at 8:16 am
Well, right now the only DB instance that I can be sure is working properly is my Live production one. I don't think just changing Compatibility mode to 120...
November 3, 2015 at 6:54 am
Just to clarify the question ...
You have a DB-1 and a DB-2 which are mirror images of each other, but when someone executes code with insert update or delete, you...
October 31, 2015 at 7:28 am
Viewing 13 posts - 1 through 13 (of 13 total)