Viewing 15 posts - 31 through 45 (of 102 total)
firing 1000 times do you think would that be a problem or any better alternative solution would you suggest
June 24, 2015 at 6:43 pm
thanks for ur response. if thousand records fire at a time it would cause blocking or does it cause triggers to fail.
2) what would you suggest a sql job to...
June 24, 2015 at 4:55 pm
Rebuild process is better when compared to reorg
below are the runtimes of a non clustered index of row count 1114462
rebuild 7 mins with maxdop 2 and sort in tempdb...
June 1, 2015 at 6:49 am
Daily maintenance rebuild if the fragmentation level > 30%, between 20 and 30% reorg
updates stats with default algorithm.
weekend schedule is if the fragmentation level between 1 and 2% reorg(in...
May 18, 2015 at 10:16 am
there is no data load or updates, index fragmentation is only 1.2%. I have setup blocking alerts every 5 minutes did not receive any I myself logged in few times...
May 18, 2015 at 6:37 am
do you have indexes on position, tax lots and transactions temp tables. try to use windows function if you are on SQL2014/12.
May 11, 2015 at 2:53 pm
you might be deleting and inserting new records.
check your data load process.
May 11, 2015 at 9:50 am
take a look at below kb
https://support.microsoft.com/en-us/kb/2543687/en-us
issue could be coding inside your application. Can users make connections normally ?
May 7, 2015 at 2:07 pm
Snapshot or transactional.
is it failing in the initial setup or failing while replicating DDL changes to subscriber
May 7, 2015 at 12:38 pm
you can use option in the article properties not to replicate deletes to subscriber then you don't need to remove and add replication back during your purge process.
May 7, 2015 at 11:19 am
change replication configuration not to replicate deletes to subscriber
In SSMS go to Replication -> Local Publications and right click on your publication and select Properties. In the Publication Properties window...
May 7, 2015 at 10:49 am
on SQL2014 the least compatibility mode you can run is 100.
Since its a vendor check with them before you plan to migrate. I have seen people have code to check...
May 7, 2015 at 10:46 am
can you provide below details
what is the latency b/w publisher and distribution database -- if the issue is this keep distribution DB on a separate server may help or move...
May 7, 2015 at 10:42 am
Viewing 15 posts - 31 through 45 (of 102 total)