T-SQL Tidy

Online T-SQL Statement Parser and Formatter

T-SQL Tidy : Home

T -SQL Tidy takes your messy unformatted T-SQL statements and formats it into nice looking SQL.


Enter your SQL in the box below or click Paste.



Casing :








Latest News

Friday, May 23, 2014 1:21 AM
Broken Leg...
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)

Today: 0

Last 7 days: 0

Last 30 Days: 0

This Year: 113870

© T-SQLTidy.com | Valid XHTML | CSS

Download the FREE T-SQL Tidy SQL Server Management Studio Add-in for 2008 and 2008 R2 HERE!