Temp table limitations

Question

Temp table limitations

Steve Jones - SSC Editor

SSC Guru

Points: 738150
More actions
May 22, 2014 at 8:47 pm

#285856

Comments posted to this topic are about the item Temp table limitations

Viewing 15 posts - 1 through 15 (of 40 total)

You must be logged in to reply to this topic. Login to reply

rhythmk SSCertifiable Points: 7271 More actions · Answer 1

Nice one.Thanks for question Steve.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 2

Nice question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Thank you for post, SJ, simply nice.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

free_mascot One Orange Chip Points: 27164 More actions · Answer 4

Good one. Thank you Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

domenico.delbrocco SSChasing Mays Points: 617 More actions · Answer 5

domenico.delbrocco

SSChasing Mays

Points: 617

May 23, 2014 at 5:19 am

#1716013

Nice question

Have a good weekend!

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Good questions, thanks. Everyone have a good weekend.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SqlMel SSCrazy Points: 2901 More actions · Answer 7

Hi guys.

I actually got it right since I knew from the answers which options I could definitely do with temp tables but I took my time before answering.

I've read several times that this actually is possible, even if it would make no sense to do it.

Not saying it's true. I'll give it a try when I have the time.

Link:

http://sqlfool.com/2008/11/partitioning-101/

---------------
Mel.

Mike Hays SSCommitted Points: 1871 More actions · Answer 8

Good Question, I had to double check on the partition...

mtassin SSC-Insane Points: 23099 More actions · Answer 9

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[/url]
For tips on how to post your problems[/url]

TomThomson SSC Guru Points: 104773 More actions · Answer 10

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 12

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,My blog: www.igormicev.com

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 14

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.

Temp table limitations

Cookies on SQLServerCentral