T-SQL Tidy : Home
T -SQL Tidy takes your messy unformatted T-SQL statements and formats it into nice
Enter your SQL in the box below or click Paste.
Friday, May 23, 2014 1:21 AM
Firstly, let me answer a few questions..Yes - it hurt (a lot).Yes - it still hurts.Yes- the pain killers do help.3 months.Judo - I was fighting and landed on my knee. Yes - I may go back to Judo.Yes - Lots of clips/staples.I've got a metal plate and some screws.No - they won't come out, they stay in.Yes - its a cool scar and yes, you can have a look.I think that just about covers everything? :-)Now for the pictures...
Thursday, July 11, 2013 1:00 PM
Question: When is a columnstore index not a columnstore index?
Answer: When its a rowstore index. or When its not been rebuilt. Explanation: The answer is on MSDN – “The updateable columnstore first inserts new data into an OPEN rowgroup, which is in rowstore format” –> Yes, rowstore, not column store. MSDN says re-organising the index will put it in columnstore format, but in CTP1 this doesn’t work. You need to rebuild the index, not a problem because we are using developer edition (or enterprise edition). I’ve blogged here what happens when you insert into a column store index here
Monday, July 08, 2013 5:55 PM
Column Store Index Life Cycle
Monday, July 08, 2013 5:26 PM
Clustered Column store index recap
Wednesday, June 26, 2013 2:24 PM
Very interesting things about updateable column store indexes
Wednesday, June 26, 2013 2:06 PM
More interesting things about the Clustered Column store index..
Wednesday, June 26, 2013 12:50 PM
Interesting thing about updateable Clustered Column Store Index
Usage Stats: (Tidies)
Last 7 days:
Last 30 Days: