2011: More Nerdy Drawrings (TSQL Tuesday #14)
Category:
database-administration
This month’s #tsql2sDay is hosted by Jen McCown ( blog | twitter ) and Jen’s question is “What techie resolutions have you been pondering, and why?”
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Category:
tsql-programming
With every new year I think a little bit about time and dates. This posts looks a little more at that in TSQL.
Filling in Data Potholes Redux: Tally Tables vs CTEs
Category:
performance-tuning
In A Previous Installment… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post “Filling in Data Potholes with Recursive CTEs.”
2010 liner notes and my theme for 2011
Category:
job-searching-and-career-development
The MorningNews asked the following question recently:
Who you would recognize in your 2010 liner notes?
Filling in Data Potholes with Recursive CTEs
Category:
database-administration
Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero.
The 9th Day of SQL: Things Are Not as Simple as They Seem
Category:
indexing
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which they’ve loved this year by people in the SQL community. For each “day of SQL,” someone picks a blog which they thought was great and writes about it.
Invalid metadata in views and user defined functions
Category:
tsql-programming
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I learned the hard way, but forgot to blog about.