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 ‘Benchmark IT Consulting’
EDMPASS – I’m Speaking on SQL 2012
On March 29th 2012 the Edmonton Chapter of PASS is having it’s next meeting. Details below: http://www.eventbrite.com/event/3046360747 Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks. Date: March 29th 2012 Time: 5:00 pm – 7:00 pm Location: [...]
What Is My Restore Doing?
I love that I can still learn cool new stuff with SQL Server even after 15 years I was trying to troubleshoot a problem and got to the point where I was questioning everything I knew about backups/restores because I just couldn’t explain what was going on and why a restore was taking so long [...]
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 [...]
Not Everyone Knows What YOU Know
Something that I still struggle with as a blogger is finding topics that “I” think people would want to read about or don’t know about. I start thinking about what I don’t know (a new feature or function, etc) and work through it and then write a blog post about it. After 4 years of [...]
