February 21, 2015 at 1:34 pm
Comments posted to this topic are about the item ColumnStore index
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
February 21, 2015 at 1:42 pm
Easy question as I have followed a session about this topic ( with a marvellous speaker , Frédéric Pichaud ) at Issy-les-Moulineaux. All the answers were given and fully explained , it is why I had no problem with this question.
When I read the 1st time this question, I have hesitated 2012 or 2014 and I remembered what Frédéric said :
clustered ==> 2014
nonclustered ==> 2012 and 2014
After this little hesitation , all the choices were easy.
Thanks.
February 23, 2015 at 1:01 am
Interesting, I just learned about them last two weeks.
😀
February 23, 2015 at 1:21 am
This was removed by the editor as SPAM
February 23, 2015 at 1:23 am
Thank you for the post, really really good one. (I got it wrong as I never used it, have to learn about this)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 23, 2015 at 1:44 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
February 23, 2015 at 7:32 am
I wasn't awake enough to realize the year. :doze: Thanks for the great question.
February 23, 2015 at 7:49 am
https://msdn.microsoft.com/en-us/library/gg492088.aspx
says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.
February 23, 2015 at 9:19 am
ssimmons 2102 (2/23/2015)
https://msdn.microsoft.com/en-us/library/gg492088.aspx
says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.
+1
February 23, 2015 at 9:51 am
I don't understand why the 'physically stored' options is not considered one of the right answers.
What's the fine details here that I'm missing?
A clustered columnstore index is regulating how the data is stored on the disk. Or are you making the distinction that sure, it places it in a special way on the disk, but it's not ordered - like a clustered index.
?
missing something in Seattle.....
February 23, 2015 at 10:11 am
DataTherapist (2/23/2015)
I don't understand why the 'physically stored' options is not considered one of the right answers.What's the fine details here that I'm missing?
A clustered columnstore index is regulating how the data is stored on the disk. Or are you making the distinction that sure, it places it in a special way on the disk, but it's not ordered - like a clustered index.
?
missing something in Seattle.....
From BOL:
Columnstore indexes are ordered according to the compression algorithms. Sorting would eliminate many of the performance benefits.
In addition in the create syntax you cannot specify any column, so it's impossible to sort (on what?).
February 23, 2015 at 11:22 am
Columnstore indexes are ordered according to the compression algorithms. Sorting would eliminate many of the performance benefits.
In addition in the create syntax you cannot specify any column, so it's impossible to sort (on what?).[/quote]
Fair enough!
thanks!
February 23, 2015 at 11:56 am
ssimmons 2102 (2/23/2015)
https://msdn.microsoft.com/en-us/library/gg492088.aspx
says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.
The question is specifically about clustered columnstore indexes, which were introduced in 2014. The referenced site does not contradict that nor does it state that a clustered columnstore index was introduced in 2012.
Columnstore indexes were introduced in 2012, but that was only nonclustered types.
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
February 23, 2015 at 12:18 pm
SQLRNNR (2/23/2015)
ssimmons 2102 (2/23/2015)
https://msdn.microsoft.com/en-us/library/gg492088.aspx
says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.
The question is specifically about clustered columnstore indexes, which were introduced in 2014. The referenced site does not contradict that nor does it state that a clustered columnstore index was introduced in 2012.
Columnstore indexes were introduced in 2012, but that was only nonclustered types.
Yep - that's the part I missed. Got the year part wrong.
February 24, 2015 at 4:01 am
I hope 1 day that my company will ever consider upgrading to SQL 2014 so our databases will get benefit from all the nice new performance features 🙂
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply