Browse by Tags

How to make your laptop 10 times faster

For a while now I’ve been struggling with the performance of my laptop. Over time it starts to run slowly videos play really badly and anything that is CPU bound just takes ages. Anyone thats seen my demos recently might have seen some erratic behaviour. I put it all down to the bloat of stuff installed...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 17 2011
Performance Tuning and Query Optimisation–SQLBits Training Day

I will be doing a training day at SQLbits in April on Performance Tuning and Query Optimisation. This is the outline for the day. Its going to be an intense day, I look forward to seeing you there. To register go to http://www. sqlbits .com/information/registration.aspx . Places are limited so make sure...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Jan 29 2011
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
Have you really fixed that problem?

The day before yesterday I saw our main live server's CPU go up to constantly 100% with just the occasional short drop to a lower level. The exact opposite of what you'd want to see. We're log shipping every 15 minutes and part of that involves calling WinRAR to compress the log backups before...

Posted to DavidWimbush (Weblog) by DavidWimbush on Thu, Mar 18 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
Quickest way to get the row count of a table

Note: This is not provide a transactionally consistent count You often need to find out the number of rows in a table. However running a SELECT COUNT(*) FROM TABLE can be very slow. From SQL 2005 onwards the system catalogues manitain the row count for a table, and unlike in previous versions it is maintain...

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 4 (32 items) 1 2 3 4 Next >