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 ««12345»»»

Temp table limitations Expand / Collapse
Author
Message
Posted Friday, May 23, 2014 8:59 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: Monday, July 21, 2014 8:35 AM
Points: 3,642, Visits: 72,429
Good question... the pick 2 made it easy though... I knew they could have constraints and indexes because I've had to put them on them before.

Which only left the other two... :)





--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1574083
Posted Friday, May 23, 2014 9:19 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 8,573, Visits: 9,081
Nice easy question. I was quite surprised to see that more than twice as many thought constraints were not allowed as thought indexes were not allowed, and also quite surprised that 30% got it wrong although. Maybe people don't much use temp tables?

Tom
Post #1574089
Posted Friday, May 23, 2014 10:54 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:02 PM
Points: 21,342, Visits: 15,017
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1574151
Posted Friday, May 23, 2014 11:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 4:35 AM
Points: 2,901, Visits: 2,927
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7


Points go for you! Bravo.
:)




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1574154
Posted Friday, May 23, 2014 11:09 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:02 PM
Points: 21,342, Visits: 15,017
Igor Micev (5/23/2014)
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7


Points go for you! Bravo.
:)


Thanks Igor




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1574159
Posted Friday, May 23, 2014 11:20 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 856, Visits: 1,935
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7


This is really awesome, sql wise. Thank you for the link.

(actually the correct people are wrong and some selected wrong people are actually right)


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1574160
Posted Friday, May 23, 2014 11:25 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:02 PM
Points: 21,342, Visits: 15,017
Raghavendra Mudugal (5/23/2014)
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7


This is really awesome, sql wise. Thank you for the link.



You're welcome.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1574163
Posted Friday, May 23, 2014 12:56 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 8,573, Visits: 9,081
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7

Wow. I'm surprised. I can't imagine what I would use it for, but it seems eminently reasonable for the feature to be available even tough until now I believed it wasn't.


Tom
Post #1574208
Posted Friday, May 23, 2014 12:57 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:02 PM
Points: 21,342, Visits: 15,017
TomThomson (5/23/2014)
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7

Wow. I'm surprised. I can't imagine what I would use it for, but it seems eminently reasonable for the feature to be available even tough until now I believed it wasn't.


Yeah it is kinda hard to figure out a possible use-case. But it is kinda cool and fun to play with at least.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1574210
Posted Friday, May 23, 2014 2:33 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: Today @ 10:45 AM
Points: 3,266, Visits: 1,959
SQLRNNR (5/23/2014)
TomThomson (5/23/2014)
SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

Here is a rundown of the three options that are correct.
http://bit.ly/1kb7zz7

Wow. I'm surprised. I can't imagine what I would use it for, but it seems eminently reasonable for the feature to be available even tough until now I believed it wasn't.


Yeah it is kinda hard to figure out a possible use-case. But it is kinda cool and fun to play with at least.


Very nice post Jason. That script clearly demonstrates partitioning on a temp table. Saved that link to my favorites!

I've been trying to think of why you would ever need to partition a temp table for the past few minutes....Nope. I have no idea why that would be useful.
Post #1574237
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse