Forum Replies Created

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

  • RE: Transaction Log Full in Simple Recovery mode

    clare.xia (2/8/2011)

    3. There is no any backups for MSDB.

    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

    February 9, 2011 at 12:49 am

    #1284234

  • RE: Transaction Log Full in Simple Recovery mode

    One other question. Is the database online? Can you query the tables?

    If so, it may be an idea to start exporting data, incase a recreate is necessary.

    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

    February 8, 2011 at 10:39 pm

    #1284208

  • RE: Are the posted questions getting worse?

    Craig Farrell (2/8/2011)

    LOL! True enough, Saint Gail, Patron Saint of the "Oh Crap, my drives just died!"

    LoL.

    On that topic, who's joining me tomorrow night? http://www.quest.com/backstage/pow.aspx

    Did the presentation 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

    February 8, 2011 at 10:33 pm

    #1284206

  • RE: Where do you look for DBA's?

    Jeff Moden (2/8/2011)

    Brandie Tarvin (2/8/2011)

    proper American English

    According to some of my British friends, that's an oxymoron. 😛

    Absolutely. 😀

    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

    February 8, 2011 at 10:19 pm

    #1284202

  • RE: Transaction Log Full in Simple Recovery mode

    Let me call some help in, not sure what's happening.

    Will a full backup run?

    Is shutting down SQL an option? (don't do it yet, just checking)

    How are you calculating 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

    February 8, 2011 at 10:18 pm

    #1284201

  • RE: Life Without Keyboards

    Steve Jones - SSC Editor (2/8/2011)

    I need something. I find that I can type at 60-70% of my keyboard speed on the iPad virtual keyboard, but I need the audible...

    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

    February 8, 2011 at 3:20 pm

    #1284099

  • RE: Almost same data, same number of records same index ...scan Vs Seek?

    sqldba_icon (2/8/2011)

    actually i think it is more of data related. Because when i run my tests against two days old data it does seek and if i do it against...

    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

    February 8, 2011 at 2:15 pm

    #1284060

  • RE: Almost same data, same number of records same index ...scan Vs Seek?

    sqldba_icon (2/8/2011)

    Thanks Gail. The exec plan has all the table names and database names. I am little hesistant to send it that way.

    Why? What exactly is it going to...

    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

    February 8, 2011 at 2:02 pm

    #1284044

  • RE: Almost same data, same number of records same index ...scan Vs Seek?

    Since the queries don't give the same results, it's not a fair comparison. There could be different data leading to different optimal plans.

    As Craig said, we need to see 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

    February 8, 2011 at 1:26 pm

    #1284020

  • RE: Almost same data, same number of records same index ...scan Vs Seek?

    Same parameters but different data (copy of prod 10 days older than prod). Do the queries return the same 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

    February 8, 2011 at 6:49 am

    #1283642

  • RE: Suspect Question

    Don't use sysdatabases on SQL 2008. It's deprecated, included only for backward compatibility with SQL 2000 and will be removed in a future version. The replacement is sys.databases

    You cannot update...

    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

    February 8, 2011 at 6:44 am

    #1283639

  • RE: How to write optimized query for this case

    Try a google search for String concatenation XML Path.

    Should get you several references.

    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

    February 8, 2011 at 6:15 am

    #1283632

  • RE: A table with a nonclustered index but without primary key or clustered index

    1) DMV - Dynamic management view

    2) 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

    February 8, 2011 at 5:48 am

    #1283623

  • RE: SQL Server 2008 Start Up Phases

    Rajesh M S (2/7/2011)

    Sorry,I mean recovery phases

    If you're talking about crash recovery (the only thing i can think of that mentions phases), the three are

    1) analysis

    2) roll forward

    3) roll...

    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

    February 8, 2011 at 5:46 am

    #1283622

  • RE: Restoring SQL database without logfiles NEED HELP ASAP

    mohammed moinudheen (2/8/2011)

    That means we can never be sure if we could bring the db back online if we loose the log file after a detach operation.

    Simple, don't lose 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

    February 8, 2011 at 5:36 am

    #1283617

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