Rotating Header Image

Posts under ‘SQL Server’

#OKPASS – I’m Leaving on a Jetplane

OK so this will be another first for me…. I’ve done plenty of remote presentations (via LiveMeeting) for PASS Chapters around the world but this will be the first time I’ve actually flown to another PASS Chapter (OKPASS)  and presented live in person! Something that I’ve always envied about speakers in the US is how [...]

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

EDMPASS – I’m Speaking on SQL 2012

On March 29th 2012 the Edmonton Chapter of PASS is having it’s next meeting. Details below: http://www.eventbrite.com/event/3046360747 Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks. Date: March 29th 2012 Time: 5:00 pm – 7:00 pm Location: [...]

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 long [...]

SEQUENCE… explain why and win a prize

In SQL Server 2012 there is a new feature that should be very familiar to Oracle folks called SEQUENCE. (my wife LOVES this game) “Creates a sequence object and specifies its properties. A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence [...]

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