Forum Replies Created

Viewing 15 posts - 15,346 through 15,360 (of 49,552 total)

  • RE: my mistake, not updating column

    jerome.morris (12/6/2012)

    Hi guys I am trying to update my Database column using the below, if the column is not present it get created fine, but wont set all the entries...

    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

    December 6, 2012 at 3:52 pm

    #1566377

  • RE: Storage Space for Table, Column, and Index

    cacapo (12/6/2012)

    That's not looking too helpful either. Damn I was hoping that this would be a lot easier to find and I was just missing something.

    What's hard about 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

    December 6, 2012 at 3:01 pm

    #1566364

  • RE: Storage Space for Table, Column, and Index

    Try sys.dm_db_partition_stats for table and index.

    Column space usage isn't stored. Best you'll be able to do is average size of the column * number of 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

    December 6, 2012 at 2:00 pm

    #1566345

  • RE: sql service cannot start

    Huh?

    The SQL error log, C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG, open it in notepad and paste the last few lines here

    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

    December 6, 2012 at 1:25 pm

    #1566335

  • RE: Sizing Server Memory, Consulting Gig

    RAM per user?

    As for SQL's memory, http://www.sqlskills.com/blogs/jonathan/post/how-much-memory-does-my-sql-server-actually-need.aspx

    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

    December 6, 2012 at 11:35 am

    #1566291

  • RE: Datatype performance

    Faster in this case does not mean noticably or measurably faster. Maybe a few microseconds for a simple comparison like that. Joins show more of an effect, but you 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

    December 6, 2012 at 10:01 am

    #1566253

  • RE: ensure no rollback

    If you're not using a transaction, then SQL is in auto-commit mode meaning once a statement completes it automatically commits and can't then be rolled back.

    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

    December 6, 2012 at 9:48 am

    #1566249

  • RE: High availability best practice?

    Martin Stephenson (12/6/2012)

    if the source gets a new full backup, doesnt that break the log chain for transaction log backups and therefore stop you applying it to the target database?

    No.

    http://www.sqlskills.com/blogs/paul/post/Misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.aspx

    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

    December 6, 2012 at 9:43 am

    #1566248

  • RE: High availability best practice?

    Martin Stephenson (12/6/2012)

    Log shipping seems to be ok but I dont like being left with huge numbers of TRN files and no regular BAK files.

    Log shipping does not remove 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

    December 6, 2012 at 9:09 am

    #1566229

  • RE: Very long avg queue length for SQL Server

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Start with chapter 1.

    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

    December 6, 2012 at 7:50 am

    #1566181

  • RE: sql service cannot start

    What's the last few messages in the SQL error log?

    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

    December 6, 2012 at 5:27 am

    #1566113

  • RE: Log Shipping failing when the primary DB is taken offline

    Has the primary been restored from a 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

    December 6, 2012 at 5:25 am

    #1566110

  • RE: Create a policy to avoid backups withou copy_only option

    sanket kokane (12/6/2012)

    GilaMonster (10/23/2010)

    It's trivial to test and, if you want, I can find a blog post from the former program manager of the Storage Engine stating and proving this.

    Yes...

    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

    December 6, 2012 at 5:23 am

    #1566108

  • RE: Log Shipping failing when the primary DB is taken offline

    Ravi-156610 (12/6/2012)

    We have Log Shipping setup on SQL 2008 instances and everything was running fine until the primary database was accidentally taken offline. We bought the DB online but noticed...

    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

    December 6, 2012 at 2:37 am

    #1566054

  • RE: database log file

    sqlfriends (12/5/2012)

    So if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is...

    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

    December 6, 2012 at 1:52 am

    #1566045

Viewing 15 posts - 15,346 through 15,360 (of 49,552 total)