Microsoft released the SQL Server 2008 R2 Best Practices Analyzer last week and I’m not going to lie I was quite shocked. I’ve yet to give it a test drive but the first thing that came to my head was… Why wouldn’t they just release a PSP? No not THAT kind of PSP…. PSP is [...]
Posts Tagged ‘Benchmark IT Consulting’
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 [...]
It’s Here!!!
My lovely wife Heather gave me a call and said… “Guess what I have in my hands?” I had heard that Ken and Jorge received their author copies this week so I was very quick to guess it right Can’t wait to get home today and check it out… I have all the pdf page [...]
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 ( [...]
