Viewing 15 posts - 3,076 through 3,090 (of 19,560 total)
That's pretty much what you'd need to do. If you need to sum colors and then pick the max quantity, this works well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 2:12 pm
jchapman (5/22/2014)
My misbehaving share table is partitioned (with LightSpeed, this is 2005 environment) into 183ish partitions.
Here is what I did I just copied my 92...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 2:03 pm
Luis Cazares (5/22/2014)
Maybe changing the last condition would solve the proble, but I'm not sure if it...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 1:31 pm
So looking at the queries, it really is nothing more than the lack of a covering index. This is normal behavior. The query is returning enough results that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 1:19 pm
jchapman (5/22/2014)
Does it make sense to you though, that the query plan would change to a table scan just because one of the 4 columns in the select is not...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 1:13 pm
Looks to me like the issue is with the Kill statement
EXECUTE ('KILL ' + @spid)
you need to cast the spid to varchar because 'Kill ' cannot be converted to INT.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 1:03 pm
Then you will need to utilize a bunch of unions to get all of the database information.
An alternative is you could prepopulate a table with all of the data for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 12:34 pm
Guras (5/22/2014)
How about using a cursor and a CTE in a view and doing a final select on the CTE in a view? Just thought of it.
erm - you can't...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 12:26 pm
The only possible conceivable advantage is in the case where you are unable to get more disk space so the only option is to shrink a database to try and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 12:17 pm
I'm with Lowell. This looks to me like somebody did a reseed on backupset.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 11:56 am
Out of curiosity, what is generating the query?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 11:45 am
You'll also notice that the Recipe table has been removed from the execution plan. It looks like you probably have a trusted constraint between Recipe and RecipeMap. Based...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 11:32 am
The query is a relatively low cost but is going parallel.
It looks like you might have set maxdop to 2 but left the cost threshold at 5.
You might want to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 11:19 am
Some of the report data will be cached locally on the report server. Large reports may error out due to memory issues. Depending on the number and size...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 11:13 am
In this case you are going to a query that doesn't have a covering index. It also appears you do not have a clustered index because you are reverting...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 22, 2014 at 10:58 am
Viewing 15 posts - 3,076 through 3,090 (of 19,560 total)