Database Development

Leveraging an organization’s data stores is crucial to enabling strategic decision-making. My articles below illustrate skills necessary for an firm to achieve its goals. MANAGEMENT, UTILITIES Normalization SQL Server: SSMS Object Explorer Filter xSQL Data Compare   T-SQL T-SQL: Binary_Checksum T-SQL: Bitwise Arithmetic T-SQL: Checksum T-SQL: Complex Queries T-SQL: Compound Operators T-SQL: Control Flow T-SQL:…

T-SQL: Ranking Functions

Ranking Functions There are several new impressive advancements in the latest version of t-sql; this article will focus on “Ranking” functions. Prior to the release of SQL Server 2005 with its t-sql enhancements, working with blocks of related data was clunky at best. T-sql authors mostly relied on “GROUP BY” statements and then had to…

T-SQL: Common Table Expressions

Performing Recursive Queries. Prior to SQL Server 2005, performing recursive actions on data required the use of temporary tables, cursive, or some other memory-intensive method. Now, performing such operations requires much less code and avoids the previous performance increase. For this example, we’ll begin with a generic table containing information about people. On the “Person”…

T-SQL: Rank()

Ranking Functions There are several new impressive advancements in the latest version of t-sql; this article will focus on “Ranking” functions. Prior to the release of SQL Server 2005 with its t-sql enhancements, working with blocks of related data was clunky at best. T-sql authors mostly relied on “GROUP BY” statements and then had to…

T-SQL: Format Date Values

Leveraging Format() for greater control over date values. When displaying date values from a resultset, it is common to reformat them according to various specified business rules. Using the t-sql Format along with specifying pattern provides an easy-to-use method, especially when abstracted into a reusable user-defined function.

T-SQL: Row_Number

Ranking Functions There are several new impressive advancements in the latest version of t-sql; this article will focus on “Ranking” functions. Prior to the release of SQL Server 2005 with its t-sql enhancements, working with blocks of related data was clunky at best. T-sql authors mostly relied on “GROUP BY” statements and then had to…

T-SQL: Synonym

Simplifying T-SQL syntax. Length T-SQL is unfortunately the byproduct of many business requirements in supporting an application. As the parts of each statement grows (database.schema.object), so the overall length of the entire query. Synonyms provide a painless method to drastically decrease code bloat in queries by allowing for an arbitrary name to be used in┬áplace…