Viewing 15 posts - 12,271 through 12,285 (of 19,560 total)
Trey Staker (9/17/2010)
I work in the same building complexes as Cold Stone's headquarters...Today was a charity event with the Phoenix Suns, free icecream for me today!!!
Rub it in. Though...
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, 2010 at 4:41 pm
Has anybody else noticed how close SSC is to 1 million posts overall?
Any bets on if we could get that done by the end of the year?
Only ~12000 posts 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
September 17, 2010 at 4:35 pm
Good work Edogg - beat me to another one 😉
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, 2010 at 4:31 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
September 17, 2010 at 4:30 pm
Alvin Ramard (9/17/2010)
WayneS (9/17/2010)
Roy Ernest (9/17/2010)
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, 2010 at 4:11 pm
You could use the maxdop option in your query.
Typically this is not a serious issue. There could be some tuning in the query to help it run faster 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
September 17, 2010 at 3:46 pm
LutzM (9/17/2010)
CirquedeSQLeil (9/17/2010)
Thanks for stepping in Lutz
[cringingness ON]
I'm glad being recognized by an SSChampion to be of some sort of help. 😀
[cringingness OFF]
More serious: Congrats for being the 6th person...
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, 2010 at 3:44 pm
Stefan Krzywicki (9/17/2010)
CirquedeSQLeil (9/17/2010)
Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?
I've walked out of a few. One was when...
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, 2010 at 3:27 pm
Thanks for stepping in Lutz
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, 2010 at 3:22 pm
Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?
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, 2010 at 3:19 pm
Try this as a starting point
http://www.bimonkey.com/2009/06/the-data-conversion-transformation/
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, 2010 at 3:18 pm
Alvin Ramard (9/17/2010)
Roy Ernest (9/17/2010)
Steve Jones - Editor (9/17/2010)
Alright, everyone behave. I'm knocking off early to go drink some beer with the SQL Sentry guys.Have a great weekend.
Wait 5 minutes...
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, 2010 at 3:14 pm
Yes, I would add a transformation task and include all of the columns in this case.
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, 2010 at 1:30 pm
can you generate the execution plan from the server?
Just the "actual execution plan"
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, 2010 at 1:28 pm
what version and service pack level?
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, 2010 at 1:22 pm
Viewing 15 posts - 12,271 through 12,285 (of 19,560 total)