Benchmark IT Consulting Rotating Header Image

Posts under ‘General’

Oracle for the SQL DBA… Part 1 of a bunch LOL

So i’ve been a bit quiet lately as things have been very crazy in my world… which is good cause that means I’m staying busy and out of trouble but I thought I would drop a quick horribly long blog about some of the stuff I’m working on right now.  One thing that seems to [...]

EDMPASS July Meeting w/Brent Ozar #YEG

On July 7th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below: http://www.eventbrite.com/event/686883487 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:  July 7th 2010 Time: 5:00 pm – 7:00 pm Location: Stanley A. Milner library Map: [...]

List All Statistics For a Column

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

MAXRECURSION with a CTE in a View

So a minor “gotcha” here to start your day. If you’ve worked with CTEs before you’ve probably also worked with the MAXRECURSION option which specifies how many recursion levels deep to go before cancelling a statement. (Code below borrowed from: http://msdn.microsoft.com/en-us/library/ms175972.aspx) USE AdventureWorks; GO –Creates an infinite loop WITH cte (EmployeeID, ManagerID, Title) as ( [...]

SQL Server 2008 Internals and Troubleshooting and DBA Survivor

OK so I’m back from an extended vacation from BenchmarkITConsulting.com and although my vacation had nothing to do with warm weather, beaches, or bacon it was time well spent on finishing up my chapters for the soon to be released Pro Server 2008 Policy-Based Management book. After going through this process I have a whole new [...]

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