Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 18,926 total)

  • RE: Seperating sql server 2000 database because of increasing size

    cindyaz (10/7/2011)

    You can try taking compressed backup and see the backup size. However, as said, the problem is of network. Get that fixed and get the network pipe size increased.

    Yes...

    October 7, 2011 at 8:52 am

    #1391801

  • RE: Seperating sql server 2000 database because of increasing size

    ninnumca82 (10/7/2011)

    Actually We compress it using 7-zip after that it becomes 76MB file then we transfer to other location now management needs to seperate the database, becuase of network problem...

    October 7, 2011 at 8:43 am

    #1391790

  • RE: Are the posted questions getting worse?

    SQLRNNR (10/7/2011)

    Stefan Krzywicki (10/7/2011)

    ...

    Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA K:-D

    Looks like...

    October 7, 2011 at 8:42 am

    #1391788

  • RE: Seperating sql server 2000 database because of increasing size

    Don't waste time with this. It takes 1 minute to zip a 1 GB file. That'll buy you another couple years before having to waste time on that.

    Plan...

    October 7, 2011 at 8:30 am

    #1391775

  • RE: Are the posted questions getting worse?

    SQLRNNR (10/7/2011)

    Ninja's_RGR'us (10/7/2011)

    Steve Jones - SSC Editor (10/7/2011)

    amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?

    So...

    October 7, 2011 at 8:29 am

    #1391773

  • RE: Are the posted questions getting worse?

    GSquared (10/7/2011)

    I'm busy prepping for another attempt at moving our servers to a new datacenter.

    (No, I'm not at all bitter about doing it twice. Not even slightly. I'm...

    October 7, 2011 at 8:23 am

    #1391767

  • RE: alternative of Top.

    shivendrakumaryadav60 (10/7/2011)

    Thanks to all.. 🙂

    Actually when we perform "TOP" for table having very large

    row set (50000 or More) ;than "TOP" gives performance issue. It happens because according to sql architecture...

    October 7, 2011 at 7:53 am

    #1391741

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/7/2011)

    Not asking that at all, just strange that everyone dropped off at once.

    I'm sure a few of you are heading to PASS or SQL Saturday...

    October 7, 2011 at 7:36 am

    #1391718

  • RE: alternative of Top.

    ChrisM@Work (10/7/2011)

    SELECT SUM(Agg) as [Agg]

    From

    (

    select

    id,

    rn = ROW_NUMBER() OVER(ORDER BY id)

    from @testing

    ) dt WHERE rn < 11

    SQL 2K ;-).

    Edit : Wrong thread.

    October 7, 2011 at 7:34 am

    #1391714

  • RE: The DR Test Schedule

    Ya my whole point is that untill and unless you try it, you just have no idea how much fuel "time" you really have.

    I'd be assuming here that other system...

    October 7, 2011 at 7:32 am

    #1391711

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/7/2011)

    amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?

    So you want...

    October 7, 2011 at 7:26 am

    #1391703

  • RE: Are the posted questions getting worse?

    Ok to bring this back on topic.

    I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead + perf tuning.

    No my concern is that...

    October 7, 2011 at 7:25 am

    #1391701

  • RE: The DR Test Schedule

    jay holovacs (10/7/2011)

    We do an offfsite DR test 2x per year.

    In addition we are in a building with diesel generators and sufficient fuel to run for several weeks.

    When you tried...

    October 7, 2011 at 7:17 am

    #1391692

  • RE: Secure SQL Server backups

    bsdtux (10/7/2011)

    Thanks for the Advice. I will certainly do a test from that drive. As for them trying on test I am not really sure. I was given this task...

    October 7, 2011 at 7:14 am

    #1391689

  • RE: Secure SQL Server backups

    Personally I'd just rather give them access to a test server and restore the latest copy of prod.

    Any reason you can't go that route?

    If that's not an option I'd try...

    October 7, 2011 at 7:06 am

    #1391683

Viewing 15 posts - 2,146 through 2,160 (of 18,926 total)