Forum Replies Created

Viewing 15 posts - 42,871 through 42,885 (of 49,552 total)

  • RE: Event 17187 with SQL Server 2005

    Anything in the SQL error log from around the same time?

    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 27, 2008 at 7:41 am

    #904338

  • RE: 80040e14 - SQL statement syntax error

    Let's break this up so that it's easier to see. (note, my VB is exceedingly rusty, so check for obvious errors)

    single quotes (') are SQL string delimitors. Double quotes (")...

    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 27, 2008 at 7:40 am

    #904336

  • RE: Backup job fail

    kumar99ms (11/27/2008)

    Where are the backups been written to? os error

    Where are the backups been written to?

    (Local drive, network drive, tape, DVD, flash drive, etc)

    What's the error message? network error...

    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 27, 2008 at 7:29 am

    #904330

  • RE: CHAR or VARCHAR?

    If all the strings in the table are going to be more or less the same length (within say 10 characters, depending on size) then char, otherwise varchar.

    Things like ID...

    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 27, 2008 at 6:43 am

    #904301

  • RE: Log shipping restore error

    Nazier.vdrheede (11/27/2008)

    The log in this backup set terminates at LSN XXX, which is too early to apply to the database. A more recent log backup that includes LSN XXX 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

    November 27, 2008 at 6:40 am

    #904300

  • RE: SP error on run

    pri.amin (11/27/2008)

    Sorry about the formatting.

    Can you edit your post to fix it please?

    Run the updates and the inserts in that proc one by one until you find the one throwing...

    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 27, 2008 at 6:37 am

    #904296

  • RE: CHAR or VARCHAR?

    It's a 2 byte overhead for storing the length (although that's not exactly what is stored on the pages)

    There's no memory impact for expanding varchars, but it can cause page...

    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 27, 2008 at 6:27 am

    #904290

  • RE: User defined function working differently on tables within same database

    Then there's something wrong somewhere in the function.

    Please can you post the table's definition (the one that's failing) as a create table, and the function's definition along with a couple...

    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 27, 2008 at 6:17 am

    #904286

  • RE: Backup job fail

    Which of your backups are failing?

    Where are the backups been written to?

    What's the error message?

    How long have the backups been failing 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

    November 27, 2008 at 6:14 am

    #904283

  • RE: Page level locking is disabled????

    HanShi (11/27/2008)

    When it is ON a lot of locking will occur and the performance falls down. We added a scheduled job to change the setting to ON just before...

    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 27, 2008 at 6:06 am

    #904278

  • RE: User defined function working differently on tables within same database

    Moral of the story: Store dates in datetime columns, not as varchar.

    Any possibility of fixing the tables?

    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 27, 2008 at 6:03 am

    #904277

  • RE: Happy Thanksgiving

    Sorin Petcu (11/27/2008)

    Can anyone says something without referencing wikipedia? 😉

    On this site, yes, frequently.

    We reference Books Online and MSDN instead. 😀

    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 27, 2008 at 6:02 am

    #904276

  • RE: Transactional Replication and no Primary Keys

    If you have no primary keys (aside, why not?) then you cannot do transactional replication. You can use snapshot, which will copy the entire database over at scheduled intervals, but...

    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 27, 2008 at 6:01 am

    #904275

  • RE: Happy Thanksgiving

    Happy normal working day to all the people in the rest of the world.

    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 27, 2008 at 6:00 am

    #904274

  • RE: I/O error in sqlserver2000

    Any errors in the SQL error log?

    Is this the first time that you've seen an IO error?

    When you have a couple hours where the server won't be heavily used, 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

    November 27, 2008 at 5:32 am

    #904259

Viewing 15 posts - 42,871 through 42,885 (of 49,552 total)