May 22, 2014 at 8:47 pm
Comments posted to this topic are about the item Temp table limitations
May 23, 2014 at 1:13 am
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
🙂
May 23, 2014 at 1:23 am
Nice question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 23, 2014 at 1:39 am
This was removed by the editor as SPAM
May 23, 2014 at 2:42 am
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.
May 23, 2014 at 3:26 am
Good one. Thank you Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2014 at 5:19 am
Nice question
Have a good weekend!
May 23, 2014 at 5:31 am
Good questions, thanks. Everyone have a good weekend.
May 23, 2014 at 6:17 am
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. 😎
May 23, 2014 at 7:30 am
Good Question, I had to double check on the partition...
May 23, 2014 at 8:59 am
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... 🙂
May 23, 2014 at 9:19 am
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
May 23, 2014 at 10:54 am
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.
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
May 23, 2014 at 11:06 am
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.
Points go for you! Bravo.
🙂
Igor Micev,My blog: www.igormicev.com
May 23, 2014 at 11:09 am
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.
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
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply