Forum Replies Created

Viewing 15 posts - 16 through 30 (of 319 total)

  • RE: sorting issue

    Gianluca Sartori (6/29/2010)

    Try sorting using the numeric part only:

    works with little modification

    select top 1 @num = num from table order by cast(right(num,len(num)-4) as int) desc

    June 29, 2010 at 2:42 am

    #1186237

  • RE: backup buffer and backupIO wait stats

    Paul White NZ (5/3/2010)

    Sqlfrenzy (4/29/2010)

    top 2 waitstats on one of the server are BackupBuffer and BackupIO. The backup is being done at a network location using symantec backup utility. There...

    May 3, 2010 at 3:46 am

    #1161160

  • RE: backup buffer and backupIO wait stats

    Grant Fritchey (4/29/2010)

    Sqlfrenzy (4/29/2010)

    Grant Fritchey (4/29/2010)

    No, waits are not because of inadequate storage. It's because either the network, or the storage system itself, is running slow and causing SQL Server...

    May 1, 2010 at 12:20 am

    #1160870

  • RE: backup buffer and backupIO wait stats

    Grant Fritchey (4/29/2010)

    No, waits are not because of inadequate storage. It's because either the network, or the storage system itself, is running slow and causing SQL Server to wait on...

    April 29, 2010 at 8:10 am

    #1159719

  • RE: backup buffer and backupIO wait stats

    As I said..its a network storage.

    April 29, 2010 at 5:06 am

    #1159549

  • RE: Index Management

    am working on automating this across all servers and databases. It may take some time.

    April 23, 2010 at 1:59 am

    #1156652

  • RE: 3-node Database Mirroring

    free_mascot (3/24/2010)

    I guess it could be possible. As two different instance on a same server will be distinguised by the different tcp/ip port. Hence I guess what you are planning...

    March 24, 2010 at 10:19 pm

    #1139390

  • RE: 3-node Database Mirroring

    A common mirror..I think it is not possible.

    March 24, 2010 at 7:01 am

    #1138877

  • RE: Drop Index

    nadersam (3/9/2010)

    Thanks Gail

    ur replies were very helpfull.

    they are..always helpful...

    March 9, 2010 at 4:10 am

    #1130546

  • RE: Create index on a view

    Sqlfrenzy (3/9/2010)

    partitioning is good option in this case..Can u provide us table schema??

    I lost it here too..I must go to sleep :sick:

    March 9, 2010 at 4:07 am

    #1130545

  • RE: Create index on a view

    partitioning is good option in this case..Can u provide us table schema??

    March 9, 2010 at 12:41 am

    #1130482

  • RE: Adding new field

    Paul White (3/8/2010)

    Sqlfrenzy (3/8/2010)

    hmm...but the index is not rebuild...

    Which index are you talking about? The clustered index? I don't recall saying anything about indexes - can you clarify...

    March 8, 2010 at 10:02 pm

    #1130434

  • RE: Adding new field

    Paul White (3/8/2010)

    Sqlfrenzy (3/8/2010)

    Paul White (3/8/2010)

    This is quite a complex topic, but I will try to be brief.

    When you add a column, what SQL Server has to do, depends on...

    March 8, 2010 at 9:55 pm

    #1130428

  • RE: Adding new field

    Paul White (3/8/2010)

    This is quite a complex topic, but I will try to be brief.

    When you add a column, what SQL Server has to do, depends on many factors. ...

    March 8, 2010 at 9:41 pm

    #1130420

  • RE: Adding new field

    rebuild index drops and then creates the index...this process changes the pageids being used by the index...

    to check this use the dbcc page command..u can use the below given link...

    March 8, 2010 at 4:08 am

    #1129911

Viewing 15 posts - 16 through 30 (of 319 total)