Rotating Header Image

Posts Tagged ‘Benchmark IT Consulting’

And the Emmy Award Goes To……

Yup…. Something I didn’t know was even on my bucket list just got crossed off (that’s how bucket lists work right? lol). I won an Emmy Award! (OK so it wasn’t just me that won an Emmy but the company that I contract out to) Invidi Technologies won an Emmy for “System for Executing Targeted […]

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

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