Forum Replies Created

Viewing 15 posts - 18,826 through 18,840 (of 49,552 total)

  • RE: Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value 'MD-101289' to data type int.

    You're trying somewhere in that huge column list to insert a varchar value into an int column. Check the types of each columns. Or could be that one of those...

    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

    April 24, 2012 at 10:46 am

    #1478383

  • RE: SQL Server Row Compression Problem

    lwright 19926 (4/24/2012)

    If it is compressed and I run this statement, I get nothing. When it 'loses' its compression, I can rerun this statement and get every table in the...

    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

    April 24, 2012 at 10:45 am

    #1478381

  • RE: SQL Server Row Compression Problem

    The only way something is going to 'lose' compression is if someone runs an ALTER INDEX ... WITH (DATA_COMPRESSION = NONE)

    ALTER TABLE? No clustered index?

    Have you monitored what commands the...

    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

    April 24, 2012 at 10:15 am

    #1478351

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/24/2012)

    Just....

    walk...

    away....

    +500

    He is not worth the time and stress, just ignore him and leave him be.

    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

    April 24, 2012 at 10:12 am

    #1478348

  • RE: What are the best alerts to set up on a SQL server?

    SQLKnowItAll (4/24/2012)

    GilaMonster (4/24/2012)

    All errors of severity 19 and higher and error number 825

    I assume that since you said 19 and higher, but then specifically 825 that it is not included...

    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

    April 24, 2012 at 9:48 am

    #1478318

  • RE: What are the best alerts to set up on a SQL server?

    All errors of severity 19 and higher and error number 825

    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

    April 24, 2012 at 9:38 am

    #1478306

  • RE: When table variable data moves to temp table?

    They log less than temp tables (though not a huge amount less)

    They aren't affected by an explicit rollback

    The don't cause recompiles when data changes (may be a good thing, maybe...

    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

    April 24, 2012 at 9:34 am

    #1478302

  • RE: Server Performance

    Performance has less to do with server settings and more to do with properly written code and good indexes

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-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

    April 24, 2012 at 9:14 am

    #1478276

  • RE: When table variable data moves to temp table?

    Gianluca Sartori (4/24/2012)

    The lazy writer process handles memory pressure flushing clean and dirty pages to be written to disk. The checkpoint process does a similar job, but the purposes are...

    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

    April 24, 2012 at 9:12 am

    #1478272

  • RE: When table variable data moves to temp table?

    S_Kumar_S (4/24/2012)

    The question might sound theoritical, but if we have a guideline for this shift, then it can help in deciding whether we should create a table variable or 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

    April 24, 2012 at 9:11 am

    #1478269

  • RE: Dbcc checkdb says 0 errors but SQL error 823 produced

    Ask him if he wants to bet his job on there being no additional problems (because without backups, that's what you would be doing)

    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

    April 24, 2012 at 8:40 am

    #1478229

  • RE: Dbcc checkdb says 0 errors but SQL error 823 produced

    Make sure you have backups of all of those databases first.

    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

    April 24, 2012 at 8:30 am

    #1478221

  • RE: DBCC

    ananthbhaskar (4/24/2012)

    I would like to see what does it call internally in dbcc pintable

    PinTable in SQL 2008 is dead easy. It does nothing at all. Seriously, it's a NOP.

    Other DBCC...

    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

    April 24, 2012 at 6:37 am

    #1478080

  • RE: Certification in SQL Server 2012

    If you want SQL 2008 certs, write the 2008 exams. If you want SQL 2012, wait and write the SQL 2012. Having the SQL 2008 just so you can upgrade...

    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

    April 24, 2012 at 5:07 am

    #1478030

  • RE: Disk space when varchar to nvarchar change

    A quick way to do this might be to calculate the average row length (via sys.dm_db_index_physical_stats) and subtract the length of any fixed lenght columns within the tables (like int,...

    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

    April 24, 2012 at 4:52 am

    #1478022

Viewing 15 posts - 18,826 through 18,840 (of 49,552 total)