Forum Replies Created

Viewing 15 posts - 22,126 through 22,140 (of 49,552 total)

  • RE: Torn_page_detection Vs Checksum (SQL Server 2005 database upgrade)

    None whatsoever.

    It will be applied to pages the next time they are written to (not read). That's old pages and new.

    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

    November 18, 2011 at 6:38 am

    #1409873

  • RE: What happens during a SQL Server startup?

    If you read through the error log, a lot of info is there. Otherwise there was an excellent description in the book "SQL Server 2005 Practical Troubleshooting"

    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

    November 18, 2011 at 3:49 am

    #1409781

  • RE: difference between unquie and PK constraint

    You can have one pk on a table, but multiple unique. PK requires not-nullable, unique can be on a nullable column, in which case one null is allowed. Transactional repl...

    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

    November 18, 2011 at 3:48 am

    #1409779

  • RE: More than one mirror in SQL 2008 R2?

    christopher.metzger (11/17/2011)

    Anyone else have any better ideas?

    Log shipping, SAN replication, geo-stretch cluster (you don't want that, complex), wait for SQL 2012 and use AlwaysOn. Mirroring is a single principal 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

    November 18, 2011 at 2:24 am

    #1409735

  • RE: More than one mirror in SQL 2008 R2?

    Dev (11/18/2011)

    Better (& Expensive) Solution would be Failover Clusters.

    Why do you say clustering is better and more expensive than mirroring?

    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

    November 18, 2011 at 2:22 am

    #1409734

  • RE: DATETIME Puzzle

    Ola L Martins-329921 (11/17/2011)

    The "AND" operator will check against the date-columns seperately - not simultaneously which in the case with "BETWEEN".

    Using GREATER THAN and LESS THAN in the above question...

    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

    November 17, 2011 at 2:58 pm

    #1409579

  • RE: password security for SQL Server database

    psjrw (11/17/2011)

    HI guys, Thanks for the advice. I looked up Windows Authentication as I have not used it. I understand it only works with asp.net. I'm still...

    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

    November 17, 2011 at 1:02 pm

    #1409482

  • RE: SQL Transactions generating incorrectly

    Sounds like a lot of developers I've worked with. "My code's perfect, it must be something else" 😉

    Without knowing how those values are generated it's going to be impossible 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

    November 17, 2011 at 9:57 am

    #1409341

  • RE: SQL Transactions generating incorrectly

    You're going to have to give a lot more detail than that...

    How is the sequential number generated?

    How is the timestamp generated?

    What's the code that inserts this? Where does it get...

    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

    November 17, 2011 at 9:31 am

    #1409317

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    It's got nothing to do with a difference of opinion.

    It's got to do with someone who was posting blatantly incorrect advice (advising people to detach suspect databases, to delete transaction...

    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

    November 17, 2011 at 9:28 am

    #1409315

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    Dev (11/17/2011)

    Ninja's_RGR'us (11/17/2011)

    Tom Brown (11/17/2011)

    It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like...

    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

    November 17, 2011 at 9:13 am

    #1409286

  • RE: Incorrect syntax near 'GO'

    LOOKUP_BI-756009 (11/17/2011)

    I am aware as this should not be the right way to get things done, but this is a temp solution till we acquire more space on our DEV...

    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

    November 17, 2011 at 8:29 am

    #1409260

  • RE: Compressed Backup Issue, anyone?

    stevescanlan (11/17/2011)

    GilaMonster (11/17/2011)

    stevescanlan (11/17/2011)

    I examined the files and the size is the same. There is a little variation in the size on disk, but that shouldn't matter.

    Not sure what...

    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

    November 17, 2011 at 6:53 am

    #1409162

  • RE: Compressed Backup Issue, anyone?

    stevescanlan (11/17/2011)

    I examined the files and the size is the same. There is a little variation in the size on disk, but that shouldn't matter.

    Not sure what comment this...

    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

    November 17, 2011 at 6:25 am

    #1409144

  • RE: Compressed Backup Issue, anyone?

    stevescanlan (11/17/2011)

    You cannot restore the backup of a compressed database to an uncompressed database.

    I am doing the entire database to a new database.

    Don't worry about that statement....

    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

    November 17, 2011 at 6:24 am

    #1409141

Viewing 15 posts - 22,126 through 22,140 (of 49,552 total)