Viewing 15 posts - 781 through 795 (of 1,157 total)
onlo (10/25/2011)
Is it possible ?
No.
But if you find a way let me know
October 25, 2011 at 4:39 am
If its flakey then my employers entire production environment is flawed! We use it to scale out for web servers.
It works very well and usually errors come from errant...
October 20, 2011 at 11:49 am
I've had a couple of these "ghost" rollbacks in the past. The only way to get rid of them is to restart the sql service.
I would check what locks...
October 20, 2011 at 11:31 am
Sounds a little odd.
Have you traced the memory usage over time to see if it changes?
Do you have any logships in addition to replication?
How frequently does the replicated data change?...
October 20, 2011 at 11:28 am
All previous updates from SP1 and SP2 are "rolled up" into SP3.
Therefore, you will be able to apply SP3 directly onto the RTM version.
October 20, 2011 at 11:22 am
I havent worked out the number of permuatations (I suspect its several hundred) but you will get a new plan everytime you run the same procedure with a different setting...
October 19, 2011 at 11:32 am
Is there anything stopping you creating a stored procedure on the linked server and calling that remotely?
RPC calls perform much better.
October 18, 2011 at 11:54 am
Dev @ +91 973 913 6683 (10/18/2011)
I am becoming a fan of SSC now. 🙂
You werent before? 🙂
October 18, 2011 at 9:42 am
to send or enable database mail?
October 18, 2011 at 8:41 am
FransG (10/18/2011)
It is using the default value of 14 days
Thats fine. Assuming you lost connectivity for less than this then this isnt the issue.
Each row inserted, updated...
October 18, 2011 at 7:27 am
Whats the metadata retention at the publisher?
October 18, 2011 at 6:12 am
Dev @ +91 973 913 6683 (10/17/2011)
I want to script them out and in case of any failure restore the databases from the script and then re-initialise the...
October 17, 2011 at 7:03 am
Dev @ +91 973 913 6683 (10/17/2011)
I don't want to backup them, so to avoid any performance impact,
If it's just object definitions, scripting make sense else it (script...
October 17, 2011 at 4:39 am
GilaMonster (10/16/2011)
MysteryJimbo (10/16/2011)
GilaMonster (10/16/2011)
GilaMonster...Really I wonder from your comments ..!!!!!!
Please read more about schema partitioning + SQL...
October 16, 2011 at 8:55 am
GilaMonster (10/16/2011)
GilaMonster...Really I wonder from your comments ..!!!!!!
Please read more about schema partitioning + SQL Alerts+ benefits...
October 16, 2011 at 8:50 am
Viewing 15 posts - 781 through 795 (of 1,157 total)