Forum Replies Created

Viewing 15 posts - 9,946 through 9,960 (of 49,552 total)

  • RE: Log Files Growing, even in Simple Mode

    AndrewSQLDBA (2/20/2014)

    I would really like the database to not log anything for this data load.

    You'd like a failure anywhere in the load to cause the destination DB to be...

    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 21, 2014 at 12:10 am

    #1690993

  • RE: Performance Tuning - Proof in the pudding

    Shawn Melton (2/20/2014)

    Do you bother capturing a before and after to show what you accomplished?

    What type of information did you capture (perfmon counters, DMV output, wait stats, etc.)?

    Always.

    I'll have...

    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 20, 2014 at 1:05 pm

    #1690868

  • RE: Are the posted questions getting worse?

    PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked into. ETA 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 20, 2014 at 12:53 pm

    #1690858

  • RE: Are the posted questions getting worse?

    stormsentinelcammy (2/20/2014)

    will this forum thread ever get back on topic?

    After over 40 000 posts, I don't think it has a topic any longer.

    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 20, 2014 at 12:48 pm

    #1690852

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Ooohhhhh...... 😀

    *starts typing faster*

    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 20, 2014 at 12:44 pm

    #1690845

  • RE: LCK_M_IX on tempdb?

    Dird (2/20/2014)

    If so hopefully you'll do some that include step-by-step performance issue debugging 🙂

    You mean this?

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    https://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

    February 20, 2014 at 8:41 am

    #1690728

  • RE: Complex search Functionality with joins

    born2achieve (2/20/2014)

    Though i hit the cached link still the same message from browser.

    I just tried it and the google cache works. Click the triangle next to the search result in...

    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 20, 2014 at 5:55 am

    #1690639

  • RE: Complex search Functionality with joins

    born2achieve (2/20/2014)

    I understand that the site is down. any clue when will be up.

    GilaMonster (2/20/2014)

    Still fighting with hosting provider and domain registrar. Day 4.

    Try http://www.google.com/#q=sqlinthewild+catch+all and view the cached...

    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 20, 2014 at 5:48 am

    #1690636

  • RE: Complex search Functionality with joins

    born2achieve (2/20/2014)

    Hi Gila,

    nope.

    *sigh* Yes.

    The link is correct. The site (as I'm well aware and as I explained above) is down in its entirety.

    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 20, 2014 at 5:42 am

    #1690629

  • RE: Complex search Functionality with joins

    born2achieve (2/20/2014)

    can i have the exact link for the article please. would like to learn.

    The link given is correct.

    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 20, 2014 at 5:22 am

    #1690622

  • RE: Complex search Functionality with joins

    Sean Lange (2/19/2014)

    You might also take a look at Gail's article about catch-all queries (although as I write this her blog is down).

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

    Still fighting with hosting provider and domain registrar....

    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 20, 2014 at 5:21 am

    #1690621

  • RE: create a table with two primary keys.

    azhar.iqbal499 (2/20/2014)

    Actually, when we define primary key on a table, data is stored in the physical order of primary key

    Not true.

    The clustered index (not primary key) enforces the logical storage...

    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 20, 2014 at 3:12 am

    #1690583

  • RE: IIF Statement

    What version of SQL are you working with? If 2005, that's why you're getting an error, IIF was added in SQL 2012.

    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 20, 2014 at 2:54 am

    #1690577

  • RE: How is my user getting update permissions through stored procedure?

    The relevant page in the docs - http://technet.microsoft.com/en-us/library/ms188676%28v=sql.105%29.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

    February 20, 2014 at 12:40 am

    #1690556

  • RE: Page Life Expectancy is too low

    SQL_Student (2/19/2014)

    Thanks a lot for all the assistance, that book that Gila mentioned is quite useful and not only for accidental DBA's :-D....

    Thank you.

    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 20, 2014 at 12:33 am

    #1690555

Viewing 15 posts - 9,946 through 9,960 (of 49,552 total)