in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Tips and Tricks » Query Tuning (RSS)

Browse by Tags

  • Great article on costs of query plans

    I’ve not seen anyone go into this details before in explaining costing of queries. Whilst I would avoid getting hung up on the specifics of a cost as these will change from release to release. Its a very interesting read about how and why cost optimisation is done and then some quirky un documented stuff...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Sep 3 2010

  • Scream if you want to go faster

    My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest of the sessions can be found here http://www.sqlpass...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 19 2010

  • User defined function performance is awful, Micorosft please sort this out

    User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing. So what is the problem...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 14 2010

  • DDD 8 vote for the sessions you want

    DDD8 is at the end of the month. They've now opened voting for the sessions that are to be held. http://developerdeveloperdeveloper.com/ddd8/Users/VoteForSessions.aspx so get voting. By the way I've submitted two sessions, one an extended version of my car crash queries session I did at SQLBits...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 13 2010

  • Entity Framework - MergeOption.NoTracking and CompiledQuery.Compile

    Two things that people tell you about Entity framework performance are, use the Compiled Queryies and potentially remove tracking when its not needed. You can achieve this by using the CompiledQuery.Compile function to obtain a function that is your compiled query and to set the MergeOption of the relevant...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Jan 2 2010

  • Q&A from the query tuning webcast

    The following are the questions asked following the query tuning webcast I did with Kevin Kline If you have any further questions please let me know. Hue Holleran Asked: Shouldn't the _primary_ objective be to minimise _overall_ server load, ie. reducing logical reads is the most important thing...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Sep 22 2009
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems