Thankfully I had yet another cross country flight yesterday. Why thankfully? Because the travel gives me ample time (and booze) to think about things like “If there was a DBA reality television show, what would it be like?” I started with the basics, something in a Survivor format, maybe a Big Brother, or The Apprentice, … Read more
Never, that’s when. Don’t want to believe me? Well then, who would you believe? How about the SQL Craftsman, a man with more MVP-ness than myself. What’s that? Not good enough for you? Well, then, let me introduce you to Paul Randal. He had some thoughts on the subject. http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx So why is this … Read more
Did you want to speak at the upcoming PASS 2009 Community Summit? Well, now is your chance! The call for speakers went out today and you can find all of the details at http://www.sqlpass.org/Community/SpeakerResource.aspx The deadline for submission of abstracts is April 10th, so do not put this off any longer. Get motivated and submit your … Read more
On Tuesday March 31st Jeremiah Peschka will be presenting a session for the Application Development SIG titled “Dynamic SQL: What’s All the Fuss About, Anyway?”. The time is set for 1PM EDT (1700UTC). When the livemeeting details are final I will post them here as well. For a list of other SIG events, visit the … Read more
Recently we had a vendor suggest to us that we turn off the option for NOCOUNT on their database. Upon hearing this my first question was, naturally, why? What was the issue such that they would say they wanted this turned off for their database(s)? Those questions were immediately followed by, naturally, how? How do … Read more
Grant Fritchey’s new book is now available on Amazon, you can order it from the link below. SQL Server 2008 Query Performance Tuning Distilled I have know Grant for a few years now and have always been impressed with how he able to dissect query plans as well as his overall performance tuning abilities. This … Read more
