Forum Replies Created

Viewing 15 posts - 31,276 through 31,290 (of 49,552 total)

  • RE: DBCC CHECKDB - Is this used in real life?

    Absolutely!

    Unless you are 100% totally certain that your IO subsystem is perfectly configured, perfectly stable, that no disks are ever going to go wrong, no controllers ever glitch, no...

    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

    August 12, 2010 at 10:41 am

    #1206198

  • RE: sysadmin

    David Benoit (8/12/2010)

    GilaMonster (8/12/2010)

    Only if Builtin\Administrators is granted login and a member of the sysadmin server role.

    AND if you decide to remove Builtin\Administrators make sure that you do some reading...

    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

    August 12, 2010 at 10:37 am

    #1206190

  • RE: sysadmin

    Only if Builtin\Administrators is granted login and a member of the sysadmin server role.

    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

    August 12, 2010 at 8:33 am

    #1206044

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/12/2010)

    Are you saying you can't give the PK & Unique constraints names on a table variable or names at all?

    The first.

    On a real table, you can use...

    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

    August 12, 2010 at 7:45 am

    #1206016

  • RE: SQL Server Vs Oracle

    koustav_1982 (8/12/2010)

    Is such an answer possible at all?

    No. It's a matter of opinion, hence will differ from person to person.

    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

    August 12, 2010 at 6:53 am

    #1205966

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (8/12/2010)

    Remember that the optimizer uses statistics to decide to use an index. Table variables have none, it is assumed that they will have 1 row. ...

    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

    August 12, 2010 at 6:45 am

    #1205957

  • RE: Are the posted questions getting worse?

    jcrawf02 (8/12/2010)

    I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a...

    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

    August 12, 2010 at 6:27 am

    #1205945

  • RE: Mirror Database - Cannot create snapshot

    What does this return? (run in master database)

    select name, type_desc, physical_name from sys.master_files

    where database_id = db_id('MyDatabase')

    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

    August 12, 2010 at 2:49 am

    #1205855

  • RE: SQL 2000 server

    Temp tables can be used in SQL 2000. They're not a new feature in any recent version.

    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

    August 12, 2010 at 1:31 am

    #1205832

  • RE: Extent allocated to more than on object

    If you've got time (maint window) and it's not a big database, you could script and drop all indexes and stats, then recreate all the indexes. Lots of work, make...

    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

    August 11, 2010 at 11:44 pm

    #1205812

  • RE: Can I use a saved execution plan?

    Peter Trast (8/11/2010)

    hehe.... the first words out of my mouth today were, " I would never recommend doing this but IF you wanted to..."

    😀 I did a TechEd session last...

    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

    August 11, 2010 at 11:43 pm

    #1205811

  • RE: Restoring db

    You can try to attach it, you'll just have to remove the reference to the ldf file in the attach dialog. If the image was made while SQL was running...

    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

    August 11, 2010 at 2:03 pm

    #1205699

  • RE: Unable to restore DB after upgrade SQL 2000 to 2005

    blackbird (8/11/2010)

    Don't forget to change the compatibility level afterwards so the databases are actually 2005 ones since 2000 databases can exist on a 2005 instance, but still be 2000 databases....

    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

    August 11, 2010 at 1:36 pm

    #1205691

  • RE: Restoring db

    You might be able to attach it. If the database was shut down cleanly, then in the process of attaching, SQL will create a new ldf. If the database was...

    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

    August 11, 2010 at 1:06 pm

    #1205675

  • RE: I'm trying to save a recorded profiler trace as a table in database

    No. Something else is going on.

    File -> Save -> to table?

    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

    August 11, 2010 at 12:52 pm

    #1205662

Viewing 15 posts - 31,276 through 31,290 (of 49,552 total)