Rotating Header Image

Posts under ‘General’

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

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

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

PASS Summit 2013 – Keynote Live Blogging and Random Asides

8:04 am – First time at the bloggers table for me… I plan on just copying whatever the people around me are typing.  I really hope Tim Mitchell and Andy Warren write some funny stuff. So far the big news was already released 🙂 and that is that SQL 2014 CTP2 is available for download…. […]

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