Posts by Dan:
New Index option disabled
I’ll make this short and sweet. I was trying to create an index on a new table I had created through SQL Management Studio 2005. I right clicked the Index folder under the table and noticed that the option of New Index was grayed out (disabled). I figured out that Management Studio will disable that option if you have the table schema-locked in another window. Close any of those windows, and try again – it should be enabled again.
2011 Goals
Goodbye 2010, hello 2011. 2010 brought the launch of this blog and my decision to start doing freelance work. I decided to start learning new programming languages to widen my talent. At the end of 2010, where do I stand? Well clearly this blog is still running. I know some Django (Python’s web framework), and [...]
Numeric padding in T-SQL
I was recently trying to find a way to padding a number in T-SQL and decided to share what I found. Let us say I wanted to pad the number 123 into the string ’00123′, here is how to do it. SELECT REPLACE(STR(123, 5), ‘ ‘, ’0′) FROM SomeTable I found this little bit of [...]
