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 [...]
Posts under ‘General’
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: [...]
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 [...]
