Forum Replies Created

Viewing 15 posts - 31,336 through 31,350 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    BrainDonor (8/10/2010)

    Someone has landed a job as a DBA and hasn't heard about recovery models.

    http://www.sqlservercentral.com/Forums/Topic966360-1292-1.aspx#bm966429

    Could someone take over please, I was trying to be helpful until the last reply and...

    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

    August 10, 2010 at 5:46 am

    #1204674

  • RE: SQL Trace

    ODPOA (8/10/2010)

    I was planning on upgrading the database and tools to 2008 express edition along with upgrading soapware to the 2010 version.

    You can, but bear in mind that Express doesn't...

    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

    August 10, 2010 at 5:39 am

    #1204669

  • RE: Transaction Log for Insert/Delete/Update

    For what purpose?

    Auditing? (consider DDL and DML triggers)

    To apply the changes to another server? (consider log shipping or replication)

    Something else?

    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

    August 10, 2010 at 5:12 am

    #1204648

  • RE: SQL Trace

    ODPOA (8/10/2010)

    Could this not do the trick... for now?

    http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

    along with this.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

    ?

    You can try, but I don't know if the SQL 2008 client tools can set up log shipping on SQL...

    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

    August 10, 2010 at 5:03 am

    #1204645

  • RE: SQL Trace

    ODPOA (8/10/2010)

    I did not mean to make it seem as if I expect your help, it however seemed for a moment as if you had dissapeared, and I am on...

    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

    August 10, 2010 at 4:52 am

    #1204632

  • RE: Transaction Log for Insert/Delete/Update

    The transaction log is not intended to be human-readable. What are you trying to do that you want to read the 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

    August 10, 2010 at 4:40 am

    #1204618

  • RE: WA_sys indexes (Who, where, why???)

    Those aren't indexes. They're automatically created statistics.

    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

    August 10, 2010 at 4:37 am

    #1204616

  • RE: When would be the order by faster ?

    John Mitchell-245523 (8/10/2010)

    Gail, reading between the lines, I think what the senior DBA is saying is that if you insert data that is already sorted in the order of 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

    August 10, 2010 at 4:36 am

    #1204615

  • RE: SQL Trace

    ODPOA (8/10/2010)

    Someone please help me, I have 6 hours and I am running out of time.

    We're all volunteers here, we all have our own jobs, we're all posting in our...

    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

    August 10, 2010 at 4:35 am

    #1204614

  • RE: How to make triggers

    Continues here - http://www.sqlservercentral.com/Forums/Topic966360-1292-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

    August 10, 2010 at 3:15 am

    #1204573

  • RE: Shrinking & Reindexing

    The only time you want to shrink a database is after a massive archive and delete that has left an immense amount of free space in the data file that...

    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

    August 10, 2010 at 3:12 am

    #1204572

  • RE: SQL Trace

    Ok, take several steps back. I mean no offence, but you're thinking like a programmer here.

    What is the purpose of this? If what you're trying to do is 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

    August 10, 2010 at 3:08 am

    #1204571

  • RE: When would be the order by faster ?

    Tell your senior DBA that he should check his facts before making statements like that. It's trivial to prove he's wrong.

    CREATE TABLE TestingInsertOrder (

    ID UNIQUEIDENTIFIER PRIMARY KEY,

    Filler CHAR(50)

    )

    GO

    INSERT INTO TestingInsertOrder...

    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

    August 10, 2010 at 3:03 am

    #1204569

  • RE: SQL SErver Query Plans

    Save as xml, open in a good text editor and compare?

    p.s. the set options won't be in the plan. Check the sys.dm_exec_plan_attributes DMV

    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

    August 10, 2010 at 2:47 am

    #1204564

  • RE: SQL Trace

    webmaster 27466 (8/10/2010)

    I am the new NSA, and DBA, I am in training.

    There's no senior DBA there? What happened to the previous DBA?

    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

    August 10, 2010 at 2:46 am

    #1204562

Viewing 15 posts - 31,336 through 31,350 (of 49,552 total)