Browse by Tags

All Tags » Query Tuning (RSS)
23 November 2011 20:47

SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
03 September 2010 13:04

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
19 May 2010 19:22

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
01 April 2010 09:45

Microsoft guarantees the performance of SQL Server

I have recently been informed that Microsoft will be guaranteeing the performance of SQL Server. Yes thats right Microsoft will guarantee that you will get better performance out of SQL Server that any other competitor system. However on the flip side...
Posted by simonsabin | 3 comment(s)
Filed under: , , ,
17 February 2010 20:38

Getting your joins wrong can really impact performance

I've just posted about filtering with joins is difficult to optimize (http://sqlblogcasts.com/blogs/simons/archive/2010/02/16/Filtering-by-joining-is-difficult-to-optimise.aspx). This post is along the same lines and is about the opposite, when joins don't filter as expected but rather they expand the result set.

As with the filtering post, this join situation I am going to describe is also difficult to identify and the database tuning advisor won't be able to help you either. In this post we look in at a technique for ensuring your joins are correct ...

...
Posted by simonsabin | 1 comment(s)
Filed under: ,
30 January 2010 14:30

Entity Framework how to stop your DBA having a heart attack

My code and presentation from my session at Developer Day 8 are now available here DDD_8-Entity_Framework Code Entity framework presentation Any questions let me know. Also for more on the new features in Entity Framework v next go to http://blogs.msdn...
Posted by simonsabin | 9 comment(s)
Filed under: , , , , , ,
14 January 2010 19:21

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 with SQL Server.

Well the issue is that ......

...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , , , , ,
13 January 2010 00:29

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...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
02 January 2010 15:52

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
30 November 2009 11:12

SQL road trip of Ireland in December - Cork and Dublin

On so not exactly a road trip but I will be going over to Ireland on the 8th to do a Cork usergroup and then over to Dublin on the 9th for another one. If you are interested in coming along then pop along to the site and register. The Cork event is here...
Posted by simonsabin | 1 comment(s)
Filed under: , ,