Forum Replies Created

Viewing 15 posts - 34,096 through 34,110 (of 49,552 total)

  • RE: Time Bomb Coding

    Ryan C. Price (2/10/2010)

    Not that I want to encourage bad habits, but I seem to recall a discussion (I thought it was here @ SQL Server Central, but I can't...

    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

    February 10, 2010 at 6:21 am

    #1116745

  • RE: Why it is failing ?????????

    What's the error?

    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

    February 10, 2010 at 6:11 am

    #1116737

  • RE: RESTORE VERIFYONLY

    Dave Mason (2/9/2010)

    Does anyone else do this on a regular basis?

    If you don't verify your backups, it means you have no idea if they will restore when necessary....

    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

    February 10, 2010 at 5:14 am

    #1116713

  • RE: need suggetions on urgent basis!!!!!!!

    Try Google.

    Good search terms would be "enabling PAE Windows Server 2003" and "enabling AWE SQL 2005". Additionally you could look in Books Online.

    Why is this urgent?

    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

    February 10, 2010 at 5:11 am

    #1116710

  • RE: Administration

    Don't understand your question. What do you mean by a 'real time server'?

    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

    February 10, 2010 at 5:09 am

    #1116709

  • RE: Upgrade from MCITP 2005 to MCITP 2008 DBA

    The same books as are used for the MCTS 2008 Admin and MCITP 2008 Admin will be of value. I highly doubt you'll find a book specifically for an upgrade...

    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

    February 10, 2010 at 5:08 am

    #1116707

  • RE: Administration

    Don't understand your question. LSN stands for Log Sequence Number, it's a binary value that each and every change in a DB has. Files don't have LSNs, transactions do.

    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

    February 10, 2010 at 5:07 am

    #1116706

  • RE: User initiated stack dump. This is not a server exception dump

    A user-generated dump can be manually generated. DBCC STACKDUMP. It might be worth running profiler to see what's running. Also, what's in the SQL error log? (If you're not sure...

    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

    February 10, 2010 at 5:04 am

    #1116704

  • RE: Clustered Index Scan: How to fix ?

    This series may help you understand. http://www.sqlservercentral.com/articles/Indexing/68439/

    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

    February 10, 2010 at 5:01 am

    #1116701

  • RE: Restoring Database without .mdf on SQL Server 2005

    BrainDonor (2/10/2010)

    the Log file only records any changes made since the last database backup.

    No it does not. The log file records changes since the last log backup (in full/bulk-logged recovery)...

    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

    February 10, 2010 at 5:01 am

    #1116700

  • RE: Restoring Database without .mdf on SQL Server 2005

    sunil.aggi (2/10/2010)

    I need to restore my database and I don't have my .mdf files.

    Is there any way by which I can restore my database using only .ldf files ??

    Nope. If...

    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

    February 10, 2010 at 4:59 am

    #1116697

  • RE: SARGability question

    weitzera (2/9/2010)

    First of all, what's the rule for whether an implicit cast is SARGEable*?

    Pretty much the same as explicit casts.

    Can you post the code of that TVF 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

    February 9, 2010 at 10:08 pm

    #1116574

  • RE: An Administrative Security Hole?

    ben.mcintyre (2/9/2010)

    In other words, there is simply no way of securing a database so that it cannot be fully unsecured if a copy falls into the wrong hands ? ...

    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

    February 9, 2010 at 10:07 pm

    #1116572

  • RE: Democratizing the Microsoft MVP Award

    Steve Jones - Editor (2/9/2010)

    Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly technical...

    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

    February 9, 2010 at 10:04 pm

    #1116571

  • RE: A guide to recover a database out from Suspect mode

    y.koteswarrao-652921 (2/9/2010)

    This is artice is very good and usefull in solving

    No, the article is neither good nor useful. Read over the prior comments to see why.

    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

    February 9, 2010 at 10:03 pm

    #1116570

Viewing 15 posts - 34,096 through 34,110 (of 49,552 total)