Sean Lange (4/22/2013)
mister.magoo (4/22/2013)
Sean Lange (4/22/2013)
mister.magoo (4/19/2013)
Sean Lange (4/19/2013)
I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really knows it is for but...There is a column ConstantC char(1).
Anyone want to take a guess what value you will find in all 1.2 million rows???
Not only do we have 1.2 million copies of the same value, just using the column is 9 or 10 extra keystrokes than just using the actual constant from the keyboard. :w00t:
Please tell me there is an index on it as well!
No the table is a heap!!! I have been asking around and nobody knows what the table is even used for. 😛
Maybe I will add a clustered index.
Oh, that's a shame, an index on 1.2 million repetitions of "C" would have been sooooo nice 😛
How about adding a filtered index ;-):-D
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