Rotating Header Image

Posts Tagged ‘Colin Stasiuk’

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

Microsoft…. Y U NO FIX??

  I would like…. if I may… it take you on a strange journey…. Consider this: A SQL Server database with ALLOW_SNAPSHOT_ISOLATION set to true A stored procedure that creates a #temp table in tempdb and subsequently drops it Multiple calls of this stored procedure (running in Snapshot Isolation mode) happening at the same time […]

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.