Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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,041, 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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, September 23, 2016 2:46 PM
Points: 767, Visits: 4,666
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".


to properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Post #1585926
Posted Wednesday, June 25, 2014 1:13 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 12, 2016 4:56 PM
Points: 310, Visits: 645
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 7, 2016 9:05 AM
Points: 4,074, Visits: 2,292
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-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:48 PM
Points: 41,429, Visits: 38,763
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."

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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 7, 2016 9:05 AM
Points: 4,074, Visits: 2,292
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:48 PM
Points: 41,429, Visits: 38,763
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."

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