Forum Replies Created

Viewing 15 posts - 36,586 through 36,600 (of 49,552 total)

  • RE: NUMA Node

    I'll dig through old papers. No promises though. If I find the slides I'll mail you the presenters' names.

    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

    September 3, 2009 at 8:17 am

    #1048770

  • RE: Meaning behind error message "Recovery of database 'XXXX' (16) is X% complete (approximately 4709 seconds remain)"?

    xnleiden (9/3/2009)

    So I believe this "stopping" action caused the database to put into a recovery mode.

    No, that wouldn't do it. That would just cause a transaction rollback. To have 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

    September 3, 2009 at 8:14 am

    #1048765

  • RE: Need help for creating couple SQL queries

    So add the name and surname to the SELECT and Group By. The correct table is already in the query.

    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

    September 3, 2009 at 7:52 am

    #1048737

  • RE: Meaning behind error message "Recovery of database 'XXXX' (16) is X% complete (approximately 4709 seconds remain)"?

    Was the server restarted?

    Typically this happens when the server is shut down suddenly, SQL doesn't have time to close the databases cleanly so they have to go through restart-recovery when...

    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

    September 3, 2009 at 7:41 am

    #1048729

  • RE: NUMA Node

    TheSQLGuru (9/3/2009)

    I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance. 🙁

    There was a whole presentation on NUMA...

    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

    September 3, 2009 at 7:38 am

    #1048726

  • RE: Application users.

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic782083-359-1.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

    September 3, 2009 at 6:10 am

    #1048665

  • RE: Stored procedures fine tuning

    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

    September 3, 2009 at 6:10 am

    #1048664

  • RE: Contrary of ISNULL() ?

    SELECT < Column list >,

    CASE WHEN AuthorDate IS NULL THEN '' ELSE 'Last Upload: ' + CONVERT(VARCHAR(30), AuthorDate, < Appropriate formatting code >) END

    FROM Documents

    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

    September 3, 2009 at 5:31 am

    #1048658

  • RE: Recover Deleted rows in SQL Server 2000

    Damien (9/3/2009)

    I already did that but unfortunately the record I want is not on that backup.

    Got an older backup?

    Can I use .Log? to Rollback deleted rows.

    You can try a 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

    September 3, 2009 at 4:38 am

    #1048640

  • RE: Auto Increment

    No. An identity can be set to start at any number and increment by any fixed interval.

    I do have to ask, why do you want values like 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

    September 3, 2009 at 4:23 am

    #1048636

  • RE: If you weren't a DBA what would you be doing?

    Well, I'm not a DBA anyway but...

    Probably as a web or front-end developer. I still enjoy coding. I was half-planning some years back on going back to dev. A friend...

    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

    September 3, 2009 at 4:18 am

    #1048633

  • RE: Can we initiate a t-log backup of the Database when its t-log is full?

    Sudeepta (9/3/2009)

    Thanks for your response, Gila. Unfortunately, the Job History and SQL Server Error log doesn't reflect much. The only information it gave that the backup log is failed with...

    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

    September 3, 2009 at 3:53 am

    #1048613

  • RE: Can we initiate a t-log backup of the Database when its t-log is full?

    Sudeepta (9/3/2009)

    We found that for one DB (Say A), the t-log backup was failed. I have verified that the disk is having enough disk space and the T-log has 500...

    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

    September 3, 2009 at 2:37 am

    #1048580

  • RE: Slow performance

    sql_lock (9/3/2009)

    Dave Ballantyne (9/3/2009)

    GilaMonster (9/1/2009)

    I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.

    My favourite is the over eager virus...

    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

    September 3, 2009 at 2:26 am

    #1048573

  • RE: backup failed..media is formatted to support 1 media famalies, but 2 media famalies...

    Did you add a location or did you replace the location with the new one?

    If you added a location then you're asking the backup to be striped across the two...

    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

    September 2, 2009 at 3:02 pm

    #1048456

Viewing 15 posts - 36,586 through 36,600 (of 49,552 total)