Viewing 15 posts - 451 through 465 (of 5,843 total)
First off: If you want something fixed "now" you really need to get someone on the phone
to see what is connected/running the best thing I know of is...
January 30, 2017 at 3:14 pm
Do a web search for dynamic pivot sql server for some options.
January 30, 2017 at 12:33 pm
A) IIRC both secondary databases have their files on the same disk system, so latencies between files "should" be identical and thus not a factor here. Something to verify though.
January 30, 2017 at 12:31 pm
I have tried to find documentation of it but have been unable to. Can...
January 30, 2017 at 9:37 am
Something strange though, just with this new database's replication:
instance A (active):
database replicated transactions replication rate trans/sec replication...
January 30, 2017 at 9:06 am
Listener:
">https://msdn.microsoft.com/en-us/library/hh213417.aspx
Do note that if you make a secondary database readable you will modify PRIMARY data structures to have a 14-byte version store pointer placed...
January 25, 2017 at 9:48 am
It REALLY helps us help you to provide a create table script, some INSERT statements for sample data and your expected outputs.
January 20, 2017 at 6:21 pm
Oh, perhaps you can cheat and add a persisted computed column to the table?!? 😀
January 19, 2017 at 2:48 pm
January 19, 2017 at 2:46 pm
January 19, 2017 at 1:37 pm
not discarded yet
however, we can ping now
A -> B 72ms
B -> A 72ms
A -> C 1ms
C -> A 1ms
Didn't you say...
January 18, 2017 at 6:01 pm
January 18, 2017 at 4:07 pm
January 18, 2017 at 2:04 pm
January 18, 2017 at 11:46 am
The number of rows in a replicated table isn't of importance from a replication performance perspective. It is how much DML activity occurs.
Check the 2017 table for foreign...
January 18, 2017 at 8:38 am
Viewing 15 posts - 451 through 465 (of 5,843 total)