Rotating Header Image

Posts under ‘Benchmark IT Consulting’

List All Statistics For a Column – Update

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 […]

SQL Server 2014 RTM – April 1st (and that’s no joke)

    Christmas in April 🙂 I like it.   “SQL Server 2014, Microsoft’s cloud first data platform, released to manufacturing today Today, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on […]

PASS Summit 2014 – Call for Speakers

That’s right ladies and gentlemen the PASS Summit 2014 Summit Call for Speakers is officially open for business!!! Last year was my first year presenting at a Summit and I can’t wait to submit and hopefully have an abstract and topic that people are interested in. I actually was honored and selected for 2 sessions […]

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 […]

Happy 2014 SQL Folks!!!

Seems like a year since my last post haw haw haw But seriously it has been a while and it’s a new year so I guess it’s time I make good on a resolution (or make one in the first place) and blog more. 2013 was a great year and professionally it marked the first […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.