SqlServerKudos

Query Tuning

1
kudos

Kudos

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

published 69 days, 13 minutes ago posted by

sa 73 days, 1 hour, 27 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Performance, Query Tuning, SSAS, SSIS - Integration Services, Training

2
kudos

Kudos

Great article on costs of query plans

published 507 days, 9 hours, 30 minutes ago posted by

sa 514 days, 9 hours, 47 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Performance, Query Tuning, Tips and Tricks, undocumented

1
kudos

Kudos

Scream if you want to go faster

published 618 days, 17 hours, 32 minutes ago posted by

sa 625 days, 20 hours ago

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...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

tags: PASS, Performance, Query Tuning, SQL Server 2005, SQL Server 2008, Tips and Tricks

1
kudos

Kudos

SQL Saturday #35 Dallas

published 665 days, 21 hours, 4 minutes ago posted by

sa 674 days, 22 hours, 40 minutes ago

SQL Saturday is coming to Dallas. May 22nd so add it to your calendar and register. SQLSaturday is a free day-long training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on May 22, 2010 at the Region 10 Education Service Center, 400 E Spring Valley [...] (more)

category: News | clicked: 0 | comment | | source: jasonmassie.com

tags: Mixed Workloads, Query Optimizer, Query Tuning, sql pass, SQL Server, SQLSaturday, TSQL

1
kudos

Kudos

Getting your joins wrong can really impact performance

published 707 days, 23 hours, 4 minutes ago posted by

sa 717 days, 41 minutes ago

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. Someone asked me the ot... (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Performance, Query Tuning

1
kudos

Kudos

Filtered Stats to Counter Data Skew Issues

published 715 days, 23 hours, 36 minutes ago posted by

sa 722 days, 2 hours, 10 minutes ago

Filtered Stats to Counter Data Skew Issues

There are a handful of things that can make SQL Server choose a “bad plan”. They usually revolve around variable sized result sets. Some problematic scenarios are parameter sniffing, data skew, local variables, table variables, UDF’s or complex calculations in the where clause. All of these and more are detailed in my favorite and recently [...] (more)

category: News | clicked: 2 | comment | | source: jasonmassie.com

tags: Query Optimizer, Query Tuning, SQL Server, statistics, TSQL

1
kudos

Kudos

Entity Framework how to stop your DBA having a heart attack

published 725 days, 3 hours, 30 minutes ago posted by

sa 734 days, 14 hours, 55 minutes ago

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 (more)

category: News | clicked: 4 | comment | | source: sqlblogcasts.com

tags: community, DDD, Entity framework, LINQ, Performance, Query Tuning, Speaking

1
kudos

Kudos

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

published 741 days, 4 hours, 40 minutes ago posted by

sa 750 days, 12 hours, 35 minutes ago

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 whilst there are great from a reducation of duplicated code the performance sucks, and sucks big time. I wrote about this a year ago and have spoke about it at m... (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Bugs, Performance, Query Tuning, SQL Engine, SQL Profiler, SQL Server 2005, SQL Server 2008, Tips and Tricks, TSQL

1
kudos

Kudos

DDD 8 vote for the sessions you want

published 745 days, 4 hours, 59 minutes ago posted by

sa 752 days, 4 hours, 40 minutes ago

DDD8 is at the end of the month. They've now opened voting for the sessions that are to be held. 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 including some information about little known trace flags, and the other is lessons learnt from using ORMs especially Entity framework the pitfalls you can get into and how to get out of them. Hope to see you there. (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: community, DDD, Performance, Query Tuning, Speaking, Tips and Tricks

1
kudos

Kudos

Entity Framework - MergeOption.NoTracking and CompiledQuery.Compile

published 753 days, 5 hours, 35 minutes ago posted by

sa 762 days, 17 hours ago

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 entities on the ObjectContext. I've just finished banging my head against a wall when trying to assess the performance of these together. This was my simple code. Create a static readonly functio... (more)

category: News | clicked: 7 | comment | | source: sqlblogcasts.com

tags: Entity framework, Performance, Query Tuning, Tips and Tricks

1
kudos

Kudos

SQL road trip of Ireland in December - Cork and Dublin

published 786 days, 7 hours, 59 minutes ago posted by

sa 795 days, 19 hours, 16 minutes ago

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 http://www.mtug.ie/Home/tabid/38/ctl/Details/Mid/369/ItemID/31/Default.aspx?ContainerSrc=%5bG%5dContainers/_default/No+Container and the Dublin event is here http://irishdev.com/Home/Events/Article.html?id=338 If you're in the area it would be great to... (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Performance, Query Tuning, usergroup

1
kudos

Kudos

Filtered Stats to Counter Data Skew Issues

published 834 days, 12 hours, 23 minutes ago posted by

sa 844 days, 59 minutes ago

category: News | clicked: 4 | comment | | source: jasonmassie.com

tags: Query Optimizer, Query Tuning, SQL Server, statistics, TSQL

1
kudos

Kudos

Internals and Query Tuning - in the Boston area October 12-16

published 922 days, 15 hours, 52 minutes ago posted by

sa 923 days, 22 hours, 26 minutes ago

Internals and Query Tuning - in the Boston area October 12-16

In case you missed Kalen's post, we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that Kalen has ever taught in the area. I hope that some of you will be able to take advantage of this rare opportunity to really take your SQL Server skills to the n... (more)

category: News | clicked: 1 | comment | | source: sqlblog.com

tags: Query Tuning, SQL Server 2005, SQL Server 2008, Training

Welcome!

Query Tuning

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

Great article on costs of query plans

Scream if you want to go faster

SQL Saturday #35 Dallas

Getting your joins wrong can really impact performance

Filtered Stats to Counter Data Skew Issues

Entity Framework how to stop your DBA having a heart attack

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

DDD 8 vote for the sessions you want

Entity Framework - MergeOption.NoTracking and CompiledQuery.Compile

SQL road trip of Ireland in December - Cork and Dublin

Filtered Stats to Counter Data Skew Issues

Internals and Query Tuning - in the Boston area October 12-16

Open ID Login

Standard Login

Forgot Password?

Sign up