Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Byte Me: Insubordinate Clause Expand / Collapse
Author
Message
Posted Tuesday, June 24, 2014 10:46 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Byte Me: Insubordinate Clause
Post #1585737
Posted Wednesday, June 25, 2014 8:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 373, Visits: 2,599
On a scale of 1 to 10, 1 being "completely unfunny" and 10 being "hilarious", I'd rate this one a -3, "would like to sandpaper Bob's AOL cd".
Post #1585926
Posted Wednesday, June 25, 2014 1:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:57 PM
Points: 202, Visits: 392
its only a matter of time before someone adds in these gems into the compiler.

The more you are prepared, the less you need it.
Post #1586077
Posted Wednesday, June 25, 2014 2:59 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 17,947, Visits: 15,941
Hilarious and seems to be well timed for the day.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1586152
Posted Wednesday, June 25, 2014 5:25 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:24 PM
Points: 3,384, Visits: 2,017
Reminds me of the Oracle error I got the other day -

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.

Thanks for the helpful resolution hint there Oracle...
Post #1586197
Posted Thursday, June 26, 2014 12:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:36 PM
Points: 35,546, Visits: 32,131
KWymore (6/25/2014)
Reminds me of the Oracle error I got the other day -

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.

Thanks for the helpful resolution hint there Oracle...


BWAAA-HAAA!!!! Sometimes my old eyes playing tricks on me provides the benefit of spontaneous and absolutely hilarious entertainment. Here's what I thought that error said when I first looked at it. Major SPOM momemnt!

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IDIOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1586245
Posted Thursday, June 26, 2014 7:50 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 17,947, Visits: 15,941
Jeff Moden (6/26/2014)
KWymore (6/25/2014)
Reminds me of the Oracle error I got the other day -

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.

Thanks for the helpful resolution hint there Oracle...


BWAAA-HAAA!!!! Sometimes my old eyes playing tricks on me provides the benefit of spontaneous and absolutely hilarious entertainment. Here's what I thought that error said when I first looked at it. Major SPOM momemnt!

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IDIOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.


My eyes did the same thing. Then i chuckled. I'm thinking it is some Oracle developer's sense of humor coming to light.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1586440
Posted Thursday, June 26, 2014 8:50 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:24 PM
Points: 3,384, Visits: 2,017
SQLRNNR (6/26/2014)
Jeff Moden (6/26/2014)
KWymore (6/25/2014)
Reminds me of the Oracle error I got the other day -

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.

Thanks for the helpful resolution hint there Oracle...


BWAAA-HAAA!!!! Sometimes my old eyes playing tricks on me provides the benefit of spontaneous and absolutely hilarious entertainment. Here's what I thought that error said when I first looked at it. Major SPOM momemnt!

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IDIOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.


My eyes did the same thing. Then i chuckled. I'm thinking it is some Oracle developer's sense of humor coming to light.


Considering my overall lack of Oracle expertise, Oracle probably did think I was an IDIOT!

Glad others found it amusing too.
Post #1586489
Posted Thursday, June 26, 2014 9:10 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 17,947, Visits: 15,941
KWymore (6/26/2014)
SQLRNNR (6/26/2014)
Jeff Moden (6/26/2014)
KWymore (6/25/2014)
Reminds me of the Oracle error I got the other day -

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.

Thanks for the helpful resolution hint there Oracle...


BWAAA-HAAA!!!! Sometimes my old eyes playing tricks on me provides the benefit of spontaneous and absolutely hilarious entertainment. Here's what I thought that error said when I first looked at it. Major SPOM momemnt!

SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature with temporary table"
*Cause: An attempt was made to create an IDIOT, specify physical attributes,
specify partition or parallel clause.
*Action: do not do that.


My eyes did the same thing. Then i chuckled. I'm thinking it is some Oracle developer's sense of humor coming to light.


Considering my overall lack of Oracle expertise, Oracle probably did think I was an IDIOT!

Glad others found it amusing too.


There is a bit of irony with that error too.

Based on the verbiage, I presume it means you cannot partition a temp table in Oracle.
According to Microsoft documentation you can't partition a temp table either.

But in SQL Server you can definitely partition a temp table.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1586509
Posted Thursday, June 26, 2014 9:32 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:36 PM
Points: 35,546, Visits: 32,131
I think it would be much more fun to partition an IDIOT.

--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1586524
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse