Forum Replies Created

Viewing 15 posts - 29,956 through 29,970 (of 49,552 total)

  • RE: Surogate Keys are not always the answer but are freqently used

    Tom.Thomson (10/14/2010)

    The guidelines aren't really sound; for example "can be used on range queries" really means "make things which are used close together live close together in the 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

    October 14, 2010 at 1:36 pm

    #1237174

  • RE: Delete Trigger

    Edit: nevermind. I'm not thinking

    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

    October 14, 2010 at 1:30 pm

    #1237171

  • RE: Are the posted questions getting worse?

    WayneS (10/14/2010)

    LutzM (10/14/2010)

    bitbucket-25253 (10/14/2010)

    Is Mr Celko mellowing? Admitting there is something he does NOT know, or has his character drastically changed?

    http://www.sqlservercentral.com/Forums/Topic1002440-1292-2.aspx

    Question: How many false statements can you find in...

    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

    October 14, 2010 at 1:20 pm

    #1237161

  • RE: Calling a Stored Procedure inside a stored procedure

    CELKO (10/14/2010)

    I have not tried it, so i am not sure about the scoping rules:

    1) Declare a table variable in the Outside procedure

    2) Use the Inside procedure 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

    October 14, 2010 at 1:14 pm

    #1237158

  • RE: Index Maintenance and Page Counts

    Luke L (10/14/2010)

    Would you say it's safe to remove any indexes with less than 25 pages from my maintenance tasks no matter how fragmented they are?

    Sure, and I'd set...

    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

    October 14, 2010 at 1:12 pm

    #1237157

  • RE: Delete Trigger

    Should the user column be set to the login name of the user who deleted the 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

    October 14, 2010 at 12:58 pm

    #1237150

  • RE: Index not getting used when where clause uses variable, index is getting used when value is hard coded.

    Parameter sniffing (or more accurately, lack thereof)

    http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

    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

    October 14, 2010 at 12:54 pm

    #1237147

  • RE: Delete Trigger

    Post the definitions of the tables please.

    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

    October 14, 2010 at 12:47 pm

    #1237142

  • RE: Arranging table output

    Group by is used for aggregation. (min, max, sum, avg, etc)

    From the sound of things, you just want the rows ordered first by category then, within that, bty price. So...

    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

    October 14, 2010 at 11:47 am

    #1237109

  • RE: Index Maintenance and Page Counts

    Both 😀

    Under 25 pages you're likely to get little-no change in fragmentation because of the way the first few pages are allocated.

    1000 pages is a rough guesstimate as 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

    October 14, 2010 at 11:45 am

    #1237107

  • RE: Detach Log Shipping Primary?

    No need to detach.

    ALTER DATABASE to change the location of the file (check Books Online for the syntax)

    Take the database offline

    Move the file(s)

    Bring the database online.

    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

    October 14, 2010 at 11:31 am

    #1237098

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/14/2010)

    However I have still gone to bookstores a few times, or the library, and to me, there's something different there. There's a randomness that I...

    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

    October 14, 2010 at 11:27 am

    #1237094

  • RE: Help, my database is corrupt. Now what?

    jpSQLDude (10/14/2010)

    with the DATA_PURITY option before CheckDB will not fix this. <-- not??

    Yup, that's correct.

    CheckDB with the data purity option will check for bad values, it will not fix them.

    There's...

    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

    October 14, 2010 at 11:23 am

    #1237089

  • RE: transaction logs full in simple recovery mode?

    No replication, but that's an old active transaction.

    In any recovery model, the log can only be truncated to the beginning of the oldest active transaction. So if you have transactions...

    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

    October 14, 2010 at 10:59 am

    #1237060

  • RE: Are the posted questions getting worse?

    I'm kinda leaning towards an iPad for a light-weight eReader/pdf reader/etc. It does pdfs very well )friend of mine has one), there's a kindle app for it and there's 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

    October 14, 2010 at 10:57 am

    #1237054

Viewing 15 posts - 29,956 through 29,970 (of 49,552 total)