With CLUE as (Select * from Random_Thought ORDER BY Common_Sense DESC)

SQL Server thoughts, observations, and comments
posts - 52, comments - 79, trackbacks - 0

December 2008 Blog Posts

Zunicide

Yes, I own a 30 GB Zune.  Yes, it crashed today.  Yes, I am unhappy. Having worked in the computer industry for many years now, I watched many companies deal with failed products.  Such is inevitable in an industry that gives the biggest rewards to the first implementation that is “good enough”.  More importantly, I have seen companies deal with failures in various ways.  Some handled things well and some no longer exist or have lost market dominance due to poor reactions to failures.  Here are a few observations that I am sure Microsoft will ignore, partly because you have to...

posted @ Wednesday, December 31, 2008 1:12 PM | Feedback (2) | Filed Under [ Hardware High Availability ]

Successful Failure

Microsoft has successfully migrated its SQL Server support forums to a platform guaranteed to eliminate an estimated 20-30% of all corporate users.  By including the word "social" in the URL, most corporate firewalls will block access automatically.  Congratulations go to Microsoft for moving people off of their lowest cost support platform. http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/ Ready, Fire, Aim.      

posted @ Friday, December 12, 2008 3:07 PM | Feedback (0) | Filed Under [ Microsoft ]

Free Space Fundamentals

One of the easy ways to fail at database administration is to allow your databases to self-manage space.  Autogrow is a safety valve, not a pressure regulator.  Of course, to manage space you have to know exactly how much free space you have.  And since database objects are stored in filegroups, it would help to see free space by filegroups buth in MB and in percentages.  Well, here you go. For those not familiar with my administration style, all my servers have an Admin database to store stuff like this.  use Admin go ----- Create the following table or results come back empty --Create...

posted @ Friday, December 05, 2008 4:31 PM | Feedback (0) | Filed Under [ SQL General ]

Powered by:
Powered By Subtext Powered By ASP.NET