Forum Replies Created

Viewing 15 posts - 39,781 through 39,795 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/13/2009)

    Damn Gail, I know you're in a whole different world coming from SA, and I'm just a spoiled brat living in the US of A, but what kind of...

    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

    April 13, 2009 at 7:11 am

    #976550

  • RE: Just Walk Away - Blacklisting - and Twits without Twitter

    Jeff Moden (4/12/2009)

    I've been known to stop an interview after the first question for those same reasons. I've no tolerance for condescending or arrogant people especially where I work....

    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

    April 13, 2009 at 2:58 am

    #976421

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/12/2009)

    So, you were there last year. What's a good inexpensive place to stay?

    I stayed at the 7th Ave Inn last year. Decent rooms, includes breakfast (for 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

    April 13, 2009 at 2:56 am

    #976420

  • RE: Fine tuning Indexes.

    This is the way I always do it.

    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/

    No point in tuning queries or indexes that aren't a problem.

    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

    April 13, 2009 at 2:46 am

    #976417

  • RE: heap or clustered

    radek (4/12/2009)

    BTW: table like product_type, product,product_group,failure_cause etc.. is small max 2000rows and tbl_FAILURES_archive_only_first_entrys is about 4000, I think thats very small to create indexes but statistics is better concrete...

    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

    April 12, 2009 at 2:20 pm

    #976341

  • RE: Dynamic query

    Paul White (4/12/2009)

    It's also possible to read all possible data into XML and run an XQuery... 😀

    If you're going to make suggestions as to how something can be done, please...

    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

    April 12, 2009 at 9:53 am

    #976317

  • RE: Dynamic query

    Definitely not a good idea. Personally it's not something I would even suggest here as someone might use it without realising why it's a bad idea.

    Multi-statement table valued function 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

    April 12, 2009 at 9:11 am

    #976308

  • RE: I cant install the server components

    cmrhema (4/12/2009)

    Thanks Gila .Can I have a free download of Developer Edition.

    No. It's $50. Buy it from Amazon if you don't have an MSDN subscription

    And in case I have 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

    April 12, 2009 at 8:52 am

    #976304

  • RE: Dynamic query

    Paul White (4/12/2009)

    Yet another option (though not a good one!) would be to construct a table valued function to return the correct data based on a @MonthName input parameter.

    How would...

    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

    April 12, 2009 at 8:51 am

    #976303

  • RE: Timeout

    Deadlocks won't cause timeouts. Deadlocks cause error 1205.

    Timeouts at a certain time indicate that something else is running at that time that's interfering with the query that's timing out. Any...

    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

    April 12, 2009 at 8:44 am

    #976301

  • RE: Database keeps switching from full recovery Model to simple recovery model

    parthikrishna (4/12/2009)

    Which database recovery model is best and why do we choose that recovery model than remaining models?

    Take a read through these:

    Understanding Logging and Recovery in SQL Server

    Managing Transaction Logs[/url]

    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

    April 12, 2009 at 8:43 am

    #976300

  • RE: Are the posted questions getting worse?

    Alvin Ramard (4/12/2009)

    Being a contractor, that would be without pay too

    Same here. It comes out of my 'education and training' savings.

    If you're paying your own way, ignore the conference hotels....

    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

    April 12, 2009 at 8:39 am

    #976298

  • RE: Dynamic query

    Another option if you're using Enterprise edition is to drop the idea of multiple tables and consider partitioned tables.

    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

    April 12, 2009 at 8:37 am

    #976296

  • RE: I cant install the server components

    You can't install the server components of Enterprise edition on a non-server OS. Basically, to install the server components of SQL Enterprise edition, you need Windows Server 2003 or Windows...

    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

    April 12, 2009 at 8:35 am

    #976293

  • RE: heap or clustered

    I suspect the cluster vs heap discrepancy is more the result of a lot of bad and missing indexes.

    It would really help if you could post the actual execution plan....

    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

    April 12, 2009 at 4:42 am

    #976260

Viewing 15 posts - 39,781 through 39,795 (of 49,552 total)