Msg 5074, Level 16, State 1, Line 1 The statistics ‘StatName’ is dependent on column ‘ColumnName’. Msg 4922, Level 16, State 9, Line 1 ALTER TABLE DROP COLUMN ColumnName failed because one or more objects access this column. So what is a nice quick and easy way to list all the statistics that are dependant [...]
Posts under ‘General’
SEQUENCE… explain why and win a prize
In SQL Server 2012 there is a new feature that should be very familiar to Oracle folks called SEQUENCE. (my wife LOVES this game) “Creates a sequence object and specifies its properties. A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence [...]
#SQLFamily Thoughts
@SQLRockstar (Tom LaRock) recently asked the SQL bloggers in his “Meme Monday” series to write about what the term “SQL Family” means to them. It’s amazing how many thoughts/ideas come into your head when you hear the term #SQLFamily. I was able to breakdown what #SQLFamily means to me into 3 categories: Technology Professional Development [...]
Happy Halloween From Benchmark IT Consulting
If you’d like to chat with me about this or anything else (SQL or other) please leave a comment or hit me up on my Twitter: @ColinStasiuk
Turn the Page
Something that has been problematic at best for developers to deal with historically is the idea of “paging”. Basically being able to say that if I was assuming 10 rows per page, I want to see what the contents of page 250 would be. In order for you to work with my example (which uses [...]
