Rotating Header Image

Posts Tagged ‘Benchmark IT Consulting’

Do You Even Blog Bro? (Stats, Execution Plans, Indexes, and crazyness)

Have you ever worked with a piece of software for like 15-20 years and ended up doing something with that product that you haven’t or can’t remember doing ever before?   This happened to me quite recently and although I wont have a bunch of sexy scripts for you to reproduce the problem I will […]

PASS Summit 2014 – I’m Speaking!!!

Good Morning!! With all the huzzah of PASS announcing the speakers and topics recently I thought I would wait a bit before doing the standard “I’m Speaking” blog post 🙂 As always it’s an honor to be selected to speak anywhere but the PASS Summit has and always will have a special place in my […]

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

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