Forum Replies Created

Viewing 15 posts - 36,736 through 36,750 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Roy Ernest (8/28/2009)

    Thanks Grant, I am hoping it will continue like this.

    Don't be worried if it doesn't. I'm only now, almost a year later, getting the same attendance 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

    August 29, 2009 at 7:14 am

    #1046476

  • RE: null value in unique constraint

    There's no real use. It's just that within unique indexes is the only place where nulls are considered the same. Unique indexes and unique constraints only allow a single null....

    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 29, 2009 at 7:12 am

    #1046475

  • RE: Is CHECKDB necessary on Read-Only DB's?

    Ed (8/28/2009)

    Since these db's are never written to again, is it still necessary to run CHECKDB on them?

    Yes it it. SQL doesn't corrupt it's own databases while writing...

    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 28, 2009 at 3:53 pm

    #1046425

  • RE: Query Run Very Slow on SQL 2005

    CAn you please post the exec plan from the SQL 2005 server as detailed in the article I referenced above. You're missing indexes, I can't tell which ones without seeing...

    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 28, 2009 at 3:42 pm

    #1046420

  • RE: Query Run Very Slow on SQL 2005

    Execution plan please. Just the SQL 2005 one is fine.

    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 28, 2009 at 1:17 pm

    #1046384

  • RE: restoring only one column

    Not directly.

    Restore the backup as a new database and use UPDATE to get the values as you want them.

    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 28, 2009 at 12:48 pm

    #1046374

  • RE: Reading DBCC Checktable Ouptut

    Not that I'm aware of, from the output of the repair.

    Do you have the original error messages?

    Why repair and not restore from backup?

    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 28, 2009 at 8:56 am

    #1046287

  • RE: SQL Server not evaluating WHERE before Casting?

    gary.wood (8/28/2009)

    Well, thanks, but as I mentioned, this is greatly simplified and the real WHERE clause is significantly more involved. I picked this one simply to illustrate what 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

    August 28, 2009 at 8:53 am

    #1046286

  • RE: SQL Server not evaluating WHERE before Casting?

    And be aware that ISNUMERIC checks whether the value can be cast to one of the numeric data types, not whether it can be case to int.

    SELECT ISNUMERIC ('1.245d10')

    SELECT CAST('1.245d10'...

    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 28, 2009 at 8:50 am

    #1046282

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/28/2009)

    Anybody else get an email via SSC from pboyall969@xxxxxxxxxx requesting help to purge all the tables in a database?

    Not so far, 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 28, 2009 at 8:42 am

    #1046273

  • RE: Are the posted questions getting worse?

    Luke L (8/28/2009)

    Care to share what that pluggin is?

    I'm sure I've mentioned it before. http://clippings.mozdev.org/

    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 28, 2009 at 8:38 am

    #1046269

  • RE: SortOrder - differnt results on two different SQL servers that are different patch levels

    Maxer (8/27/2009)

    I wonder... if one of the tables had a clustered index on NAME and the query was

    SELECT Department, Name

    FROM someTables

    ORDER BY Department

    Then is it at all possible that...

    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 28, 2009 at 8:29 am

    #1046260

  • RE: New Picture of Steve Jones in the Daily Email

    GSquared (8/28/2009)

    He actually insisted that dressing well helps to prove competence. Not, "dressing well shows a degree of respect for the people you are interviewing with, and a conformation...

    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 28, 2009 at 8:04 am

    #1046237

  • RE: Query execution speed half on anything other than x5570 core 0

    I'm not familiar with the x5570 and I'm not as familiar with NUMA as I would like to be. As far as I know, a NUMA node would consist of...

    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 28, 2009 at 7:57 am

    #1046229

  • RE: DBCC CHECKDB consistency errors

    philokeeffe75 (8/28/2009)

    Gail all the messages have dissapeared CheckDB comes back clean after the repair_rebuild.

    🙂

    Good to hear.

    This means if the IO subsystem problem can be resolved alongside putting in place...

    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 28, 2009 at 7:55 am

    #1046226

Viewing 15 posts - 36,736 through 36,750 (of 49,552 total)