My 10,000th Post!
-
This is my 10,000th (ten thousandth) post!
well err, 10K points technically, since I did spend some time on questions of the day and stuff like that.
My first post nine years ago, on Posted 4/2/2003 9:40 AM, and you can see it here:
http://www.sqlservercentral.com/Forums/Topic11040-4-1.aspx
I'd been lurking for a while before that.
now that I have 10K points, I wanted to ask the other high posters whether they waited until they had 12K points to redeem them for the bigger prizes, or just did it right away just to get a bunch of stuff now?
I got the email asking my size for the Polo Shirt, and started poking around the SSC premiums to see what to redeem my points for.
I'm leaning towards WalMart cards for my premium, since I'll get a better return per dollar than on food or gas station cards. I'll never get enough points for the Harley motorcycle, so that's not even on my list.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Just use DBCC Timewarp and you can the Harley today!!!
The funny thing is that your points show as 9,990 next to your icon but shows as 10,000 on the last 30 days thing.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Congratulations
-
Sean Lange (8/7/2012)
Just use DBCC Timewarp and you can the Harley today!!!The funny thing is that your points show as 9,990 next to your icon but shows as 10,000 on the last 30 days thing.
yeah there's some lag between the sync from questions of the day vs forum posts;
they usually catch up after a half hour or less, from what i've seen.
two different systems, obviously.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Congratulations Lowell!
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
-
Very cool. It's been good to know you all this time, Lowell. Well done!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Well done Lowell.
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 -
Nice work Lowell! I know I've learned a few tricks from some of your 10K posts!
I just hit 1,000 today. Gotta ways to go before they're redeemable.
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St -
Lowell (8/7/2012)
This is my 10,000th (ten thousandth) post!You suck!
Single thread next to this one got almost 4 times more!!!
😀
_____________
Code for TallyGenerator
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply