05/29/2015
by Marlon Ribunal
5 Comments
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days … Continue reading
03/19/2015
by Marlon Ribunal
3 Comments
Beginning in version 2005, SQL Server is making manipulation of a partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions with OVER(), etc.). You can manipulate partitions of rows on the fly with Window Functions. I’ve seen how complicated … Continue reading
07/03/2014
by Marlon Ribunal
1 Comment
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at the same time.You can register and manage any servers but only those in SQL Server versions 2008 and higher can … Continue reading