Forum Replies Created

Viewing 15 posts - 20,776 through 20,790 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    http://en.wikipedia.org/wiki/Fine_structure_constant

    As for Flash Forward, the blackout and flash forward that the series is named for was 2 minutes, 17 seconds long.

    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

    January 24, 2012 at 5:18 pm

    #1438030

  • RE: How to use what I created?

    Evil Kraig F (1/24/2012)

    DATENAME is apparently non-deterministic, I'll have to see what's going on there

    Because it might return different results from the same input depending on the SET options Language,...

    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

    January 24, 2012 at 5:16 pm

    #1438028

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/24/2012)

    GilaMonster (1/24/2012)

    Oooh, a palindrome! Nice.

    It's also the first five binary digits of 10001001 - a number I seem to recall has special significance to you 🙂

    Yes, I do...

    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

    January 24, 2012 at 5:07 pm

    #1438025

  • RE: virtual log file size

    No.

    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

    January 24, 2012 at 4:49 pm

    #1438021

  • RE: Are the posted questions getting worse?

    Oooh, a palindrome! Nice.

    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

    January 24, 2012 at 4:45 pm

    #1438018

  • RE: DMVs go how far back?

    Stefan Krzywicki (1/24/2012)

    I should have mentioned which DMVs I'm using, shouldn't I? 🙂

    sys.dm_exec_query_stats

    sys.dm_exec_sql_text

    Those two keep data as long as the plan is in cache. Once the plan is removed (aged...

    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

    January 24, 2012 at 2:46 pm

    #1437976

  • RE: Are the posted questions getting worse?

    Whether release happens that day or not has not been stated (and likely hasn't been decided even), currently that (and SQLbits at the end of March) are listed as launch...

    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

    January 24, 2012 at 2:43 pm

    #1437973

  • RE: Restore Database Failed

    jarid.lawson (1/24/2012)

    Does it matter if all I'm trying to do is have a daily backup, not a point in time back up? I can remove it, but I would 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

    January 24, 2012 at 12:50 pm

    #1437904

  • RE: Back to Vegas

    Would love to attend one year, but it's not going to be this year. This year it'll likely be PASS Summit again and maybe (hopefully) TechEd Europe. Will see how...

    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

    January 24, 2012 at 11:49 am

    #1437872

  • RE: High CPU Utilization

    Bear in mind that the CPU returned by sp_who2 is cumulative since that connection was established. If you're looking at one of the system processes, it would have been running...

    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

    January 24, 2012 at 11:23 am

    #1437848

  • RE: Efficent select by date (today -1)

    roryp 96873 (1/24/2012)

    Use dateadd instead.

    select DATEADD(d, -1, GETDATE())

    That will only match when the data row is from exactly 24 hours before, down to the millisecond

    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

    January 24, 2012 at 11:19 am

    #1437841

  • RE: Efficent select by date (today -1)

    sqlservant (1/24/2012)

    Thank you, It returns records with yesterdays date in that field.

    So if I query right now, 2012/01/24 20:15, it needs to return rows from 2012/01/23 00:00:00 up to 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

    January 24, 2012 at 11:18 am

    #1437839

  • RE: Efficent select by date (today -1)

    Logic check... If I run that query now (2012/01/24 20:00), what are the dates that should be returned?

    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

    January 24, 2012 at 11:01 am

    #1437828

  • RE: Restore Database Failed

    Neither. All backups to a separate file with a datetime stamp as part of the file name.

    Still wondering why you're switching to simple recovery before the 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

    January 24, 2012 at 10:59 am

    #1437827

  • RE: Backup Size/Transaction Log Size both in need of drastic reduction

    Please read through this - Managing Transaction Logs[/url] and maybe http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    A log backup won't reduce the size of the log. It's not supposed to. It's supposed to make the space...

    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

    January 24, 2012 at 10:06 am

    #1437796

Viewing 15 posts - 20,776 through 20,790 (of 49,552 total)