SqlServerKudos - Stories tagged with Query Tuning

Query Tuning

atom rss
1
kudos
spam Kudos Remove

Scream if you want to go faster
published 65 days, 9 hours, 31 minutes ago posted by sasa 72 days, 12 hours ago
Thursday, May 27, 2010 10:33:51 AM GMT Thursday, May 20, 2010 8:05:34 AM GMT
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...(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
spam Kudos Remove

SQL Saturday #35 Dallas
published 112 days, 13 hours, 4 minutes ago posted by sasa 121 days, 14 hours, 40 minutes ago
Saturday, April 10, 2010 7:01:15 AM GMT Thursday, April 01, 2010 5:25:01 AM GMT
SQL Saturday #35 Dallas
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
spam Kudos Remove

Getting your joins wrong can really impact performance
published 154 days, 15 hours, 4 minutes ago posted by sasa 163 days, 16 hours, 41 minutes ago
Saturday, February 27, 2010 5:01:11 AM GMT Thursday, February 18, 2010 3:24:38 AM GMT
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
spam Kudos Remove

Filtered Stats to Counter Data Skew Issues
published 162 days, 15 hours, 36 minutes ago posted by sasa 168 days, 18 hours, 10 minutes ago
Friday, February 19, 2010 4:29:33 AM GMT Saturday, February 13, 2010 1:55:10 AM GMT
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: 1 | comment | | source: jasonmassie.com
tags: Query Optimizer, Query Tuning, SQL Server, statistics, TSQL
1
kudos
spam Kudos Remove

Entity Framework how to stop your DBA having a heart attack
published 171 days, 19 hours, 29 minutes ago posted by sasa 181 days, 6 hours, 55 minutes ago
Wednesday, February 10, 2010 12:35:55 AM GMT Sunday, January 31, 2010 1:10:29 PM GMT
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: 2 | comment | | source: sqlblogcasts.com
tags: community, DDD, Entity framework, LINQ, Performance, Query Tuning, Speaking
1
kudos
spam Kudos Remove

User defined function performance is awful, Micorosft please sort this out
published 187 days, 20 hours, 40 minutes ago posted by sasa 197 days, 4 hours, 34 minutes ago
Sunday, January 24, 2010 11:25:16 PM GMT Friday, January 15, 2010 3:30:46 PM GMT
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
spam Kudos Remove

DDD 8 vote for the sessions you want
published 191 days, 20 hours, 59 minutes ago posted by sasa 198 days, 20 hours, 39 minutes ago
Wednesday, January 20, 2010 11:06:20 PM GMT Wednesday, January 13, 2010 11:25:44 PM GMT
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.  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
spam Kudos Remove

Entity Framework - MergeOption.NoTracking and CompiledQuery.Compile
published 199 days, 21 hours, 34 minutes ago posted by sasa 209 days, 9 hours ago
Tuesday, January 12, 2010 10:30:47 PM GMT Sunday, January 03, 2010 11:05:21 AM GMT
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: 1 | comment | | source: sqlblogcasts.com
tags: Entity framework, Performance, Query Tuning, Tips and Tricks
1
kudos
spam Kudos Remove

SQL road trip of Ireland in December - Cork and Dublin
published 232 days, 23 hours, 59 minutes ago posted by sasa 242 days, 11 hours, 15 minutes ago
Thursday, December 10, 2009 8:06:40 PM GMT Tuesday, December 01, 2009 8:49:57 AM GMT
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
spam Kudos Remove

Filtered Stats to Counter Data Skew Issues
published 281 days, 4 hours, 23 minutes ago posted by sasa 290 days, 16 hours, 58 minutes ago
Friday, October 23, 2009 3:42:26 PM GMT Wednesday, October 14, 2009 3:06:49 AM GMT
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: 4 | comment | | source: jasonmassie.com
tags: Query Optimizer, Query Tuning, SQL Server, statistics, TSQL
1
kudos
spam Kudos Remove

Internals and Query Tuning - in the Boston area October 12-16
published 369 days, 7 hours, 52 minutes ago posted by sasa 370 days, 14 hours, 25 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:39:43 AM GMT
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