Takeaway: I explain an interesting problem I encountered. I explain how I maintain data for a table that stores hierarchy info. The problem might not be relevant to you dear reader, but the technique might. The Problem So say that you’re keeping track of a hierarchy in a particular ...
In case you haven’t heard there is an upcoming 24 Hours of PASS event to be held on May 19th and 20th. Here is a reminder of the features in SQL 2008 R2 that will be discussed: PowerPivot PerformancePoint Utility Control Point Parallel Data Warehouse StreamInsight Master Data Management Multi-Server ...
If you missed my recent Twitter announcement, SQL University’s next semester is going to start back up on Monday April 12th. This semester will start with Creative Writing week (aka Documentation). I’ll post the full semester’s schedule and topics shortly over on the main page. This semester I’m happy to ...
Last year my better half, Tim, suggested that we start a blog. It made sense for any number of reasons, but it scared the heck out of me. I couldn’t imagine that there was anything that I could ever blog about that hadn’t already been posted and probably by someone ...
With SQL Server 2008 R2 having been released it seems like a good time to remind people about the sp_refreshview system stored procedure. How are those two things related? Great question. When migrating or upgrading to newer versions (such as R2), you need to be aware that a simple restore ...
In Part 2 of this series, I dangled a carrot in front of you, taunting you with the fact that the Reads and CPU figures were markedly different between SQL2008 and SQL2005 in processing our million-row test table one row at a time: /* Description CPU Reads ---------------------------------------------- SQL2008: STATIC ...
As one of the bloggers behind The Master Blog, Joe Sack is a public face for the SQL MCM program. Joe also blogs at MSDN, and he manages the SQL MCM prerequisite reading list. The MCM program isn’t even his “day job” – he’s also a Senior Premier Field Engineer, ...
Yes, we use T-SQL to manage and manipulate data for multi-billion dollar enterprises, but every now and then we need to take some time for some recreation.And I don’t mean “lie around on a Hawaiian beach sipping a Mai-Tai” kind of recreation… I’m talking about something more cerebral.We’re going to ...
During a Twitter conversation today Malik Alamin (Twitter) asked about the Autogrow settings on his databases. The conversation naturally progressed to the question of how you change the default behavior and set all newly created databases to have user defined settings. Brent Ozar (Blog | Twitter) was able to point ...
Well, it’s official, the MS newsgroups are going the way of Microsoft Bob by the end of this year. While I have never hid my feelings for newsgroups or forums I will say that participating in the private MVP newsgroups was one of the benefits I enjoyed the most as ...
Pulse is a brand-new section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community. We recommend checking out Pulse in a modern web browser, such as Internet Explorer 7+, Firefox 3+, Safari 4+, Opera 10+, or Chrome.