October 6, 2011 at 12:21 pm
Grant Fritchey (10/6/2011)
Time to start the education. Quintessential Ramones. But my own preference is for this.Hurry, hurry, hurry...
...too late I already went insane.
_______________________________________________________________
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/
October 6, 2011 at 12:23 pm
Sean Lange (10/6/2011)
Stefan Krzywicki (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!A sad day, and a reminder that I'm getting older as well. People I admire, know, love, are slowly dying. Remember that. You're dying too. Enjoy this life, and do something you love while you can.
Crap, you're just getting there? When Joey Ramone died was the day I suddenly felt old. Still haven't quite recovered.
It isn't right that all the Ramones are dead, but all the Rolling Stones are alive.
All the original Ramones are not dead. Tommy (the original drummer) is still alive and well. There are several other non original members still alive.
The Ramones were Joey, Johnny and Dee Dee. The drummers (they had several) and the late substitute bassist CJ don't really count. They weren't why you went to the shows. That said, we've frequently joked about having an all-drummer reunion tour. Isn't Tommy currently hawking his own brand of BBQ sauce?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 6, 2011 at 12:27 pm
Stefan Krzywicki (10/6/2011)
Sean Lange (10/6/2011)
Stefan Krzywicki (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!A sad day, and a reminder that I'm getting older as well. People I admire, know, love, are slowly dying. Remember that. You're dying too. Enjoy this life, and do something you love while you can.
Crap, you're just getting there? When Joey Ramone died was the day I suddenly felt old. Still haven't quite recovered.
It isn't right that all the Ramones are dead, but all the Rolling Stones are alive.
All the original Ramones are not dead. Tommy (the original drummer) is still alive and well. There are several other non original members still alive.
The Ramones were Joey, Johnny and Dee Dee. The drummers (they had several) and the late substitute bassist CJ don't really count. They weren't why you went to the shows. That said, we've frequently joked about having an all-drummer reunion tour. Isn't Tommy currently hawking his own brand of BBQ sauce?
True that any of the numerous drummers were not the reason to go see them. Pretty much didn't notice them sitting behind all the guitars and hair anyway...man what memories!!!!
Yeah I do remember hearing that Tommy was doing something along those lines.
_______________________________________________________________
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/
October 6, 2011 at 12:27 pm
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.
Never really listened to the Ramones, although I'm sure I've heard some of their music at some point.
Big Beatles fan though, even though I'm still too young to remember them being together.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 6, 2011 at 12:30 pm
Jack Corbett (10/6/2011)
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.Never really listened to the Ramones, although I'm sure I've heard some of their music at some point.
Big Beatles fan though, even though I'm still too young to remember them being together.
I can just about guarantee you have heard the Ramones at some point. Their music has been making into commercials and stuff over the last few years. So strange that all the punk rock I grew up with is so mainstream that is can be background music for commercials today.
_______________________________________________________________
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/
October 6, 2011 at 12:31 pm
GilaMonster (10/6/2011)
Stefan Krzywicki (10/6/2011)
GilaMonster (10/6/2011)
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!A sad day, and a reminder that I'm getting older as well. People I admire, know, love, are slowly dying. Remember that. You're dying too. Enjoy this life, and do something you love while you can.
Crap, you're just getting there? When Joey Ramone died was the day I suddenly felt old. Still haven't quite recovered.
Joey who? 😀
No idea.
Seriously? Three (at least) of you don't even know who Joey Ramone was? How about John Lennon?
Joey Ramone, never heard of. John Lennon, sure. Someone whose music my mother loves.
😀
Yes - someone whose music my mother enjoys but not my style.
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
October 6, 2011 at 12:32 pm
Sean Lange (10/6/2011)
Jack Corbett (10/6/2011)
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.Never really listened to the Ramones, although I'm sure I've heard some of their music at some point.
Big Beatles fan though, even though I'm still too young to remember them being together.
I can just about guarantee you have heard the Ramones at some point. Their music has been making into commercials and stuff over the last few years. So strange that all the punk rock I grew up with is so mainstream that is can be background music for commercials today.
Heh heh.... not all of it. Some of that stuff was just slightly blue for commercials.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2011 at 12:34 pm
Sean Lange (10/6/2011)
Jack Corbett (10/6/2011)
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.Never really listened to the Ramones, although I'm sure I've heard some of their music at some point.
Big Beatles fan though, even though I'm still too young to remember them being together.
I can just about guarantee you have heard the Ramones at some point. Their music has been making into commercials and stuff over the last few years. So strange that all the punk rock I grew up with is so mainstream that is can be background music for commercials today.
Pretty sweet isn't 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
October 6, 2011 at 12:39 pm
So working on a system where there is a UDF that calls a view and the view definition is:
create view SYSTEM_DATE_VIEW
as select getdate() SYSTEM_DATE
GO
So other code calls the UDF. It's more effort than calling GETDATE() directly.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 6, 2011 at 12:48 pm
Grant Fritchey (10/6/2011)
Stefan Krzywicki (10/6/2011)
GilaMonster (10/6/2011)
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!A sad day, and a reminder that I'm getting older as well. People I admire, know, love, are slowly dying. Remember that. You're dying too. Enjoy this life, and do something you love while you can.
Crap, you're just getting there? When Joey Ramone died was the day I suddenly felt old. Still haven't quite recovered.
Joey who? 😀
No idea.
Seriously? Three (at least) of you don't even know who Joey Ramone was? How about John Lennon?
Whoa, slow down there hoss... we're not comparing Joey Ramone to John Lennon. Ick! The Ramones were gods astride the earth, Lennon was in some band named after an insect.
A misspelled insect.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 6, 2011 at 12:52 pm
Sean Lange (10/6/2011)
Jack Corbett (10/6/2011)
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.Never really listened to the Ramones, although I'm sure I've heard some of their music at some point.
Big Beatles fan though, even though I'm still too young to remember them being together.
I can just about guarantee you have heard the Ramones at some point. Their music has been making into commercials and stuff over the last few years. So strange that all the punk rock I grew up with is so mainstream that is can be background music for commercials today.
Commercial, industrially distributed, "punk rock" was always an amusing concept to me.
But, yes, I remember The Ramones, and The Beatles broke up in my lifetime.
I go back an forth between being amazed at how young I am, and shocked at how old I've gotten, sometimes within the same train of thought.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 6, 2011 at 12:55 pm
Jack Corbett (10/6/2011)
So working on a system where there is a UDF that calls a view and the view definition is:
create view SYSTEM_DATE_VIEW
as select getdate() SYSTEM_DATE
GO
So other code calls the UDF. It's more effort than calling GETDATE() directly.
LOL
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
October 6, 2011 at 12:55 pm
Jack Corbett (10/6/2011)
So working on a system where there is a UDF that calls a view and the view definition is:
create view SYSTEM_DATE_VIEW
as select getdate() SYSTEM_DATE
GO
I've done that when I needed a non-deterministic function within a UDF, though in my case it was NewID. If the function just returned the date then it's worthy of TheDailyWTF for several reasons.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 12:56 pm
GSquared (10/6/2011)
Sean Lange (10/6/2011)
Jack Corbett (10/6/2011)
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.Never really listened to the Ramones, although I'm sure I've heard some of their music at some point.
Big Beatles fan though, even though I'm still too young to remember them being together.
I can just about guarantee you have heard the Ramones at some point. Their music has been making into commercials and stuff over the last few years. So strange that all the punk rock I grew up with is so mainstream that is can be background music for commercials today.
Commercial, industrially distributed, "punk rock" was always an amusing concept to me.
But, yes, I remember The Ramones, and The Beatles broke up in my lifetime.
I go back an forth between being amazed at how young I am, and shocked at how old I've gotten, sometimes within the same train of thought.
And the Ramones were anything but commercial punk rock at the time.
Being a child of the 60s, I too was alive when the Beatles broke up. I guess the point we are at now is sort of the definition of mid-life crisis. When you still feel young but realize that you are getting old.
_______________________________________________________________
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/
October 6, 2011 at 12:58 pm
Jack Corbett (10/6/2011)
So working on a system where there is a UDF that calls a view and the view definition is:
create view SYSTEM_DATE_VIEW
as select getdate() SYSTEM_DATE
GO
So other code calls the UDF. It's more effort than calling GETDATE() directly.
There may have been a reason. On my blog I provide a function for SQL Server 2005 that will generate a random length string. To make it work I had to create a view whose definition is:
create view dbo.MyNewID as
select newid() as NewIDValue;
go
I have not tried this in SQL Server 2008 or 2008 R2 yet so I guess I should test it tonight without the view definition.
Viewing 15 posts - 30,691 through 30,705 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply