Viewing 15 posts - 14,836 through 14,850 (of 19,560 total)
P Jones (4/15/2010)
I keep up by looking at the active postings in the daily newsletter. And keeping a post-it note of which page I'm up to in The Thread:-D
Dedicated Threadizen.
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
April 15, 2010 at 8:40 am
Steve Jones - Editor (4/15/2010)
Happy Tax Day, and behave children. I'm going skiing, so no one will be here to moderate bad jokes and subtract points.
Which mtn / slope /...
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
April 15, 2010 at 8:39 am
Steve-3_5_7_9 (4/15/2010)
This book has a pretty decent section on disk configuration.SQL Server 2005 Performance Tuning
WROX
ISBN: 978-0-470-17639-9
Nice suggestion. I will have to check into that one too.
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
April 15, 2010 at 8:37 am
Tom Brown (4/15/2010)
Anyone having difficulty posting/previewing with IFCodeI'm getting in IE 'cannot display webpage'
and Firefox 'the Connection was reset'
I can post without IFCode fine
Haven't seen that issue.
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
April 15, 2010 at 8:37 am
Tom.Thomson (4/15/2010)
CirquedeSQLeil (4/15/2010)
PlyometricsMyostatic
Ballistic
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
April 15, 2010 at 8:36 am
Plyometrics
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
April 15, 2010 at 8:29 am
Thanks Ron. Excellent 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
April 14, 2010 at 11:12 pm
Mister Ken (4/14/2010)
I've seen that "(select blah bah)" within the field list before, but never really used it. Now I know the power of...
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
April 14, 2010 at 8:10 pm
That makes plenty of sense.
Thanks for posting back.
CTEs cannot be used (as Lutz said) prior to SQL 2005 (new feature).
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
April 14, 2010 at 5:25 pm
In addition to the version, try executing the commands in separate batches (or eliminate the use db statement altogether).
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
April 14, 2010 at 5:18 pm
In your use cu_hds statement, follow it up with a GO
Then you can add the semi-colon, then run your CTE.
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
April 14, 2010 at 4:48 pm
I have played with this some more to fit into the desired results and requirements.
select t.field1, (
select count(*) line_count from #table2 where field2 > t.field2 group by field1
)
from #table1 t
You'll...
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
April 14, 2010 at 4:10 pm
You're welcome.
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
April 14, 2010 at 3:37 pm
GSquared (4/14/2010)
CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.It looks like you can come back now.
And I did....
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
April 14, 2010 at 3:33 pm
Here is a SQLMagazine article on the topic.
http://www.sqlmag.com/article/tsql3/nifty-ways-to-use-for-xml-path-concatenation.aspx
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
April 14, 2010 at 3:32 pm
Viewing 15 posts - 14,836 through 14,850 (of 19,560 total)