Forum Replies Created

Viewing 15 posts - 7,846 through 7,860 (of 18,926 total)

  • RE: Linked servers over the internet

    Brandie Tarvin (8/23/2010)

    At some point, you're going to have to test. So, as long as your clients are aware that you're testing the new system and not expecting things to...

    August 23, 2010 at 10:33 am

    #1210589

  • RE: Linked servers over the internet

    Tom.Thomson (8/23/2010)

    Brandie Tarvin (8/23/2010)

    Add all the information Paul and Tom just gave you to the fact that you do not have a direct, dedicated link to your customers, and suddenly...

    August 23, 2010 at 8:35 am

    #1210483

  • RE: Linked servers over the internet

    Brandie Tarvin (8/23/2010)

    Add all the information Paul and Tom just gave you to the fact that you do not have a direct, dedicated link to your customers, and suddenly you...

    August 23, 2010 at 6:14 am

    #1210395

  • RE: Linked servers over the internet

    Tom.Thomson (8/23/2010)

    Ninja's_RGR'us (8/23/2010)

    Also keep in mind that for each of the separate clients, we might exchange 5-20 MB of data (after encrytion) over an 8 hours day. With each transfer...

    August 23, 2010 at 6:13 am

    #1210394

  • RE: Linked servers over the internet

    paul.knibbs (8/23/2010)

    Not to mention, of course, that this 5-20Mb per customer may well not be spread evenly over the whole day--if you get a whole bunch of them trying to...

    August 23, 2010 at 6:10 am

    #1210392

  • RE: Query takes too much time to fetch the record

    I don't see any indexes in that script. Did you simply forget to script them?

    You don't tell us what query you are running and you don't supply us the...

    August 23, 2010 at 4:49 am

    #1210351

  • RE: DATALENGTH

    da-zero (8/23/2010)

    It is a good question about the basics, but not a very original one. I believe this sort of question has already been asked multiple times.

    I'd say at least...

    August 23, 2010 at 4:47 am

    #1210350

  • RE: tsql retrieve records on date

    Jeff Moden (8/22/2010)

    Ah... apologies. I see that Remi already posted such a comment. I've really got to learn to read a whole thread before posting.

    Same here... I had...

    August 23, 2010 at 4:44 am

    #1210348

  • RE: Do you advise to apply Recomendations given by DTA?

    GilaMonster (8/23/2010)

    Jeff Moden (8/22/2010)

    I'm pretty sure that statistics TIME and IO don't include SQLCLR and I believe they sometimes miss what's happening in UDF's that a query may contain.

    Correct on...

    August 23, 2010 at 4:43 am

    #1210347

  • RE: Linked servers over the internet

    Brandie Tarvin (8/23/2010)

    It bothers me that data latency is an issue in this situation. The main problem I see is network hubs going down or your clients having modem lines...

    August 23, 2010 at 4:40 am

    #1210344

  • RE: Linked servers over the internet

    paul.knibbs (8/23/2010)

    No, that's definitely not right. Encryption will make the data larger, but that's only because encryption algorithms usually have a fixed block size to deal with. For 128-bit encryption...

    August 23, 2010 at 4:32 am

    #1210341

  • RE: Linked servers over the internet

    Exactly what I tought... completly out of my league network wise :hehe:.

    Seriously, that's what I call expert advice.

    We do have 3500 clients and we had 100% response rate for people...

    August 22, 2010 at 6:50 pm

    #1210185

  • RE: help needed in code tuning.

    Just use the "do what I say" line... seems to work for many people.

    Leave the rest to fie and ask for our help when they screw up... :w00t:

    August 22, 2010 at 5:39 pm

    #1210182

  • RE: Do you advise to apply Recomendations given by DTA?

    Jeff Moden (8/22/2010)

    I'm pretty sure that statistics TIME and IO don't include SQLCLR and I believe they sometimes miss what's happening in UDF's that a query may contain. I'll...

    August 22, 2010 at 5:37 pm

    #1210181

  • RE: Linked servers over the internet

    Tom.Thomson (8/22/2010)

    Ninja's_RGR'us (8/22/2010)

    Is there a way on a firewall to accept traffic from only a single IP and redirect to another secured machine on a secured port far beyond the...

    August 22, 2010 at 5:32 pm

    #1210180

Viewing 15 posts - 7,846 through 7,860 (of 18,926 total)