Forum Replies Created

Viewing 15 posts - 42,646 through 42,660 (of 49,552 total)

  • RE: Any Way Determine Data Loss

    rbarryyoung (12/2/2008)

    And whenever you want to post a 370+ line output file like this, please feel free to either trim it down some or post it as an attachment instead.

    For...

    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

    December 3, 2008 at 12:05 am

    #906662

  • RE: log shipping without regular bak files

    Full backup does not truncate the tran log. Never has. Only a transaction log backup, an explicit truncate or a switch to simple recovery will truncate the tran log.

    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

    December 2, 2008 at 11:57 pm

    #906660

  • RE: SQL 2005-64 bit

    Don't bother with lock pages on a desktop. Since it prevents SQL from been swapped out, it could give you perf problems with other apps.

    Lock pages is important on servers...

    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

    December 2, 2008 at 11:35 pm

    #906659

  • RE: Question On Queries with declared Variables

    That's going to have to be a procedure, since you have dynamic SQL.

    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

    December 2, 2008 at 4:37 pm

    #906569

  • RE: Date Validation using ISDATE()

    Remove the select ISDATE ('5/1/2008') from before the Create Proc

    You're missing begins for two of those ifs

    If ISDATE(@DateMin) = 0

    BEGIN

    Raiserror('Please enter valid date format...

    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

    December 2, 2008 at 3:40 pm

    #906555

  • RE: Production issue

    Monitor that regularly and when the available space gets low, manually grow the file.

    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

    December 2, 2008 at 3:13 pm

    #906544

  • RE: Integrity Check -- DBCC

    That's going to take a while.

    What's the availability requirements? Can you get a weekend where the DB isn't in use? It may not take that long, but just for...

    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

    December 2, 2008 at 3:12 pm

    #906541

  • RE: Recommended path for advanced training?

    Gaby Abed (12/2/2008)

    Really? I'm curious what his answer was, or was it a simple "I don't know"?

    He told us (panel interview, myself, two other DBAs and 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

    December 2, 2008 at 3:00 pm

    #906531

  • RE: Unused Columns (all NULL) and Saving Storage Space

    nate (12/2/2008)

    Then, I moved on to a different table that had no clustered indexes. Once I removed 5 unused columns and rebuilt the non-clustered index, the 'Data Space' value...

    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

    December 2, 2008 at 2:56 pm

    #906528

  • RE: Integrity Check -- DBCC

    Script all the objects (perhaps excluding the foreign keys) to files, bcp all of the data to file. Create a new database, run all of the script files, bcp all...

    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

    December 2, 2008 at 2:45 pm

    #906520

  • RE: Production issue

    It's got nothing to do with space available. Grows are very intensive operations and will cause the entire system to slow down due to the IO impact.

    As for monitoring, try...

    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

    December 2, 2008 at 2:24 pm

    #906507

  • RE: Product of Values in a Column

    There's no built-in function that does that. However...

    Itzik, in his PASS precon, showed a cool trick for faking one using some highschool maths.

    LOGx(a * b * c) = LOGx(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

    December 2, 2008 at 2:22 pm

    #906506

  • RE: Integrity Check -- DBCC

    Paul Randal (12/2/2008)

    Without backups, this is going to be hard to get rid of - repair cannot fix this so your only options without backups are to migrate all schema...

    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

    December 2, 2008 at 2:16 pm

    #906504

  • RE: Recommended path for advanced training?

    Jeff Moden (12/2/2008)

    I had several folks say they were Ninja's in SQL Server and one even claimed to be a "9 out of 10" right on his resume......

    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

    December 2, 2008 at 2:15 pm

    #906502

  • RE: Recommended path for advanced training?

    Oksana March (12/2/2008)

    I have same question but how to go from beginner to intermediate! Oksana

    Study for the SQL certifications.

    Note, I did not say write and pass them. I said...

    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

    December 2, 2008 at 2:09 pm

    #906500

Viewing 15 posts - 42,646 through 42,660 (of 49,552 total)