Forum Replies Created

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

  • 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

  • RE: Linked servers over the internet

    Tom.Thomson (8/22/2010)

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

    My first instinct was to build a vpn tunnel between the servers but then I remembered that we can only have 1 vpn connection on 1 machine at...

    August 22, 2010 at 5:29 pm

    #1210179

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

    Thanks Gail, now 1 follow up question : Since I can't seem to find the option to get the details per table for reads in profiler (please point...

    August 22, 2010 at 4:46 pm

    #1210165

  • RE: help needed in code tuning.

    GilaMonster (8/22/2010)

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

    Here's a weird idea, start worrying about it when you plan to move to sql 201? and having the upgrade advisor throwing errors and warnings.

    In addition...

    August 22, 2010 at 4:42 pm

    #1210163

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