Viewing 15 posts - 661 through 675 (of 2,443 total)
Brad, re: the 8 TempDB files, I have no direct info here, but yesterday's SSC newsletter had a link to a blog by Eric Stephani (http://ericstephani.com/?p=166) where he was recapping...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 11, 2011 at 8:28 am
WolforthJ (5/11/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 11, 2011 at 7:46 am
Eric M Russell (5/11/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 11, 2011 at 7:43 am
Craig Farrell (5/10/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 11, 2011 at 7:24 am
Vedran Kesegic (5/11/2011)
select * from dbo.Abbreviate(' aaa .. bbb ,, ccccc ')--Result (without ;):
&#;x20;
Sory, result text was eaten by some html machinery -...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 11, 2011 at 7:22 am
bitbucket-25253 (5/10/2011)
jcrawf02You attending or presenting ?
SQLSaturday #75 - Columbus 2011 on Jun 11, 2011
As much as I'd like to try presenting, I'll just be over-committing myself (again), so I'm just...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 12:30 pm
Steve Jones - SSC Editor (5/10/2011)
Doh! Voted for Paul's Sessions.
hahahahaha....sorry to hear that(?)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 12:28 pm
You know Jeff, eventually "ol' Paint" needs to take a trip to the glue factory 😉
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 11:01 am
peterzeke (5/10/2011)[hrI agree 100% -- I've pushed many times that we need to spend the resources to build a "pipeline" instead of maintaining the "bucket brigade."
I like that, I'm...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 10:52 am
Ha! You bunch of spoiled rotten SQLRally-ers. http://maps.google.com/maps?hl=en&biw=1132&bih=700&q=8101+n+high+st+columbus+ohio+43235&um=1&ie=UTF-8&hq=&hnear=8101+N+High+St,+Columbus,+OH+43235&gl=us&ei=42TJTeSHGIS0rAfzwNGgBQ&sa=X&oi=geocode_result&ct=image&resnum=1&ved=0CBcQ8gEwAA
That's roughly 75 miles in any direction. I don't see any ocean, (it takes me a couple hours just to get to Lake...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 10:22 am
vs7804, there was a suggestion earlier to just find/replace in the file before importing, that's one option, or the derived column as suggested just above. Lastly, you could just import...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 9:40 am
peterzeke (5/10/2011)
As I'm sure you've heard from many others before, your thoroughness of tackling a problem is really...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 9:29 am
Jim Murphy (5/9/2011)
GSquared (5/9/2011)
I work in Orlando and live a few miles outside it
Ah yes. I do see something in your profile about Orlando. So you probably know a little...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 9:12 am
GilaMonster (5/9/2011)
Oh my: http://shitmystudentswrite.tumblr.com/
You don't want me to get any work done, do you? I'm laughing so hard I can't see the screen...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 9:05 am
Oops, lucked into the right answer there, I was thinking reseed was setting the increment, and went with 3 because it was 1+2.
Nice question!
I want my points removed! 😛
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 10, 2011 at 8:00 am
Viewing 15 posts - 661 through 675 (of 2,443 total)