Forum Replies Created

Viewing 15 posts - 34,216 through 34,230 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (2/4/2010)

    Gail, I distinctly remember you speaking to one of my co-workers in Seattle and asking him if I did any work at all. Evidently they...

    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 4, 2010 at 7:55 am

    #1113768

  • RE: Indexing: Required for Columns Used in ORDER BY or GROUP BY Clauses?

    It is possible to configure indexes so that they can be used for Order By and Group By, it's difficult, it cannot always be done. It's something that I put...

    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 4, 2010 at 7:51 am

    #1113764

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/4/2010)

    I don't want to be responsible for anything. I like just hanging around and trying to answer the ones no one has answered yet. Plus, 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

    February 4, 2010 at 7:47 am

    #1113762

  • RE: Retrieval of DB

    They can try buying a data retrieval tool to 'undelete' the files, but the chances of recovering it is rather slim.

    No backups at 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

    February 4, 2010 at 6:25 am

    #1113693

  • RE: Finding Empty Tables in a database

    Willem's will work, providing you run update usage first. Otherwise the rowcounts can be inaccurate (sysindexes' row count is not 100% accurate)

    dbcc updateusage (0) with count_rows

    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 4, 2010 at 5:58 am

    #1113667

  • RE: Database Crashed

    You need a backup that was taken before whatever happened. You cannot take a backup after a crash to undo it.

    Do you have a backup from before 12:41? Do 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

    February 4, 2010 at 5:54 am

    #1113664

  • RE: physicaly Deleted LOG file...want new databse to point to MDF file.

    Please post new questions in a new thread. Thank 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

    February 4, 2010 at 5:49 am

    #1113661

  • RE: null in IN clause

    Ville Lucander (2/4/2010)

    Select * from table where some_attribute NOT IN (Select distinct some_attribute from table2)

    should always be written as

    Select * from table where some_attribute NOT IN (Select...

    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 4, 2010 at 5:49 am

    #1113659

  • RE: null in IN clause

    akshaycjoshi (2/4/2010)

    U mean to say that n!=null returns unknown when n is null, right ?

    If you want to be precise and formal, yes. I'll use null and interchangeably in logical...

    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 4, 2010 at 2:51 am

    #1113572

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (2/3/2010)

    Congratulations, Jack!!

    ... and belated congratulations Saint Lynn!

    Hi Bob. Where yea been?

    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 4, 2010 at 2:26 am

    #1113559

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/3/2010)

    Jack Corbett (2/3/2010)

    Lynn Pettis (2/3/2010)

    Congrats Jack!! :w00t:

    I feel slighted, only 1 person even acknowledge when I hit 10,000. 🙁

    And it probably wasn't me. Now I feel bad....

    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 4, 2010 at 2:24 am

    #1113558

  • RE: Tip for Forgot Windows Password

    Is there a question here?

    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 4, 2010 at 2:20 am

    #1113556

  • RE: null in IN clause

    It comes down to the truth table for ANDs and ORs when nulls are involved. (It's in Books Online for anyone interested)

    In the case of NOT in,

    SELECT n FROM...

    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 4, 2010 at 2:20 am

    #1113555

  • RE: Msg 8909 & Msg 8998: Page allocation errors

    Paul Randal (2/3/2010)

    Gail - you mean you don't have all the allocation bitmap page IDs and intervals burned into your brain? Lucky you 🙂

    Not yet, I'm working on it though.

    Can...

    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 4, 2010 at 2:13 am

    #1113548

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/3/2010)

    Congrats Jack!! :w00t:

    I feel slighted, only 1 person even acknowledge when I hit 10,000. 🙁

    Don't worry, same thing happened when I hit 15000. But then I only noticed...

    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 4, 2010 at 2:12 am

    #1113547

Viewing 15 posts - 34,216 through 34,230 (of 49,552 total)