Forum Replies Created

Viewing 15 posts - 37,711 through 37,725 (of 49,552 total)

  • RE: GUID or Int is the best for primary key columns?

    Dave Ballantyne (7/13/2009)

    Also the randomness can be an issue , though newsequentialid can overcome this. See this link

    That's if the primary key is the clustered index, which...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 13, 2009 at 3:49 am

    #1023754

  • RE: The ROI for PASS 2009

    Is there any way that those of us using other registration codes can come to the party?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 13, 2009 at 3:08 am

    #1023739

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/13/2009)

    GilaMonster (7/13/2009)

    Lynn Pettis (7/10/2009)

    On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.

    For that matter, anyone heard from Grant?...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 13, 2009 at 2:50 am

    #1023728

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/10/2009)

    On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.

    For that matter, anyone heard from Grant? I think he...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 13, 2009 at 2:11 am

    #1023716

  • RE: The Worst Advice

    dmoldovan (7/13/2009)

    Besides what GilaMonster had already mentioned - directly changing data in the system tables (sql 2000).

    Oh yeah, that's always fun. Often the consequences are only noticed after upgrading to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 13, 2009 at 2:09 am

    #1023715

  • RE: change back the db from emergency to normal

    Sourav Mukherjee (7/13/2009)

    Just before running the dbcc checkdb statement I had to take it in single_user mode.

    Yup. All repairs have to be run with the DB in single user mode.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 13, 2009 at 2:08 am

    #1023714

  • RE: SET ROWCOUNT usage with DELETE..

    Jeffrey Williams (7/12/2009)

    GilaMonster (7/12/2009)

    If you want to delete the oldest rows, then you need something like this (because order by is not permitted in a delete statement)

    DELETE FROM SomeTable WHERE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 12, 2009 at 11:22 am

    #1023624

  • RE: change back the db from emergency to normal

    Sourav Mukherjee (7/12/2009)

    2. Then stopped the SQL Server.

    3. Deleted the 2 files(mdf and ldfs).

    4. Then changed the .mdf file of the old file(abc.mdf) to abc1.mdf

    5. Resatrted the SQL Service

    ALTER DATABASE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 12, 2009 at 9:08 am

    #1023618

  • RE: SET ROWCOUNT usage with DELETE..

    LeelaKrishna (7/11/2009)

    In one of stored procedures written ages back which uses SET ROWCOUNT to limit rows effected by DELETE operation after that.. Rows from BOTTOM (Old rows) are getting deleted...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 12, 2009 at 3:56 am

    #1023583

  • RE: How to recover my user database if LDF is lost?

    Sourav Mukherjee (7/12/2009)

    If the .LDF is gone, what are the steps required to follow to recover the database if I am using SQL 2005 and 2008?

    Restore from backup. If you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 12, 2009 at 3:32 am

    #1023582

  • RE: Missing Index

    There's probably a column different somewhere. Missing indexes doesn't take into account existing similar indexes. Take that DMV with a pinch of salt, it's recommendations are not always accurate and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 11, 2009 at 9:17 am

    #1023514

  • RE: SQL script to Restore a DB to standard starting point for Test purposes

    SQAPro (7/9/2009)

    ... staffed by folks who are experienced experts in this field, and yet, seem to be unble to resolve an basic issue with a website correctly accessing a datase.....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 11, 2009 at 9:16 am

    #1023512

  • RE: The Worst Advice

    Lynn Pettis (7/11/2009)

    Partly disagree here. True, you should just answer never, ever use a cursor, but ....

    Is there a 'not' missing from that sentence?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 11, 2009 at 9:08 am

    #1023510

  • RE: Managing Transaction Logs

    A full backup backups up the data in the database and then backs up just enough of the transaction log so that when the backup is restored, it can be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 11, 2009 at 5:14 am

    #1023479

  • RE: SQL Server 2008 SP1 Issues

    I think definitely time to give Product support a call

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 11, 2009 at 4:53 am

    #1023474

Viewing 15 posts - 37,711 through 37,725 (of 49,552 total)