Viewing 15 posts - 2,056 through 2,070 (of 19,560 total)
Lutz was quicker on the draw than me.
About the best you can do with that bad query is to get an optimized query in the proc in place of 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
September 22, 2014 at 9:47 am
crookj (9/22/2014)
Ed Wagner (9/22/2014)
TomThomson (9/22/2014)
wotd: Threadless (see [http://www.sqlservercentral.com/Forums/Topic1618108-61-1.aspx])Memorial
Service
Broker
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
September 22, 2014 at 9:41 am
Thanks for the great article Gail.
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
September 22, 2014 at 9:32 am
Steve Jones - SSC Editor (9/22/2014)
It's back
It's alive!!!!
Let's do the timewarp together!!!
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
September 22, 2014 at 9:22 am
Koen Verbeeck (9/22/2014)
I guess there was too much talk about Bbq in the thread and it just walked away. Or it was highjacked by a vegetarian action group.
Vegan Activists, 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
September 22, 2014 at 8:31 am
OCTom (9/22/2014)
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
September 22, 2014 at 8:13 am
GilaMonster (9/22/2014)
Koen Verbeeck (9/22/2014)
Eirikur Eiriksson (9/22/2014)
There are some other topics missing, some points also went missing, all happened more or less at the same time.😎
Iek, now that you mentioned 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
September 22, 2014 at 8:12 am
If you decide to run live on an upgraded server for any amount of time, you have the problem of rollback - whether you upgraded in place or did a...
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
September 22, 2014 at 8:10 am
Hany Helmy (9/21/2014)
Like some here said, I never used spatial data types before, so definitly learnt somthing new today, thanx for the question.
Same here. Thanks for the question.
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
September 22, 2014 at 7:41 am
I think the problem is more than just the spam. If threads are dropping then that also sounds like malware. If malware has injected into any of the...
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
September 21, 2014 at 8:30 pm
jasona.work (9/18/2014)
Grant Fritchey (9/17/2014)
So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd be appreciative.
Vote for Grant for PASS...
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
September 18, 2014 at 1:05 pm
Stefan Krzywicki (9/18/2014)
GilaMonster (9/18/2014)
Stefan Krzywicki (9/17/2014)
SQLRNNR (9/17/2014)
Roy Ernest (9/17/2014)
It felt like the OP would upgrade to SQL...
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
September 18, 2014 at 1:01 pm
To be a bit of a pedantic, but when typed out as-is, two of the options are incorrect. "Buffer Count" should be a single word "BufferCount".
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
September 18, 2014 at 6:38 am
WayneS (9/17/2014)
Sean Lange (9/17/2014)
WayneS (9/17/2014)
Sean Lange (9/17/2014)
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
September 17, 2014 at 6:39 pm
Sean Lange (9/17/2014)
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
September 17, 2014 at 3:18 pm
Viewing 15 posts - 2,056 through 2,070 (of 19,560 total)