Rotating Header Image

Posts under ‘SQL Server’

Waiting For A Pot To Boil… Restore Database Progress

Ever kicked off a restore and didn’t set the STATS parameter? Ever had a separate application handle a restore and not give you any feedback at all on how far along a restore is? Well if your answer is no than this post / script is NOT for you  🙂 BUT If your answer is […]

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

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