SQL Server Summing Time
This post describes how you can sum a column with a data type of Time in SQL Server. […]
Blog
Excel Combine Worksheet Data
The objective for this post is to learn how to combine (merge) more than one Excel worksheet file […]
SQL Server Indexes
This post is a discussion of the basics of indexes in SQL Server. It is based partly on […]
SQL Server Ranking Window Functions
Ranking calculations are implemented in T-SQL as a window function. When you rank a value you do not […]
SQL Server COUNT
In T-SQL, COUNT returns the number of items in a group. COUNT works like the COUNT_BIG function. The […]
SQL Server Data Validation Part 3
3. Fruit Code and Fruit Variety Code – Case 1 This is a continuation of the post called […]
SQL Server Data Validation Part 2
2. Fruit Name and Fruit Code – Case 1 This post is a continuation of SQL Server Data […]
SQL Server Data Validation Introduction
This post is about validating data in a single table. We have gathered data from the Internet and […]
SQL Server Aggregate Window Functions
Aggregate window functions in SQL Server are similar to grouped functions (SUM, AVG and so on) except that […]
SQL Server Window Functions
Window functions are used in SQL Server to perform data-analysis calculations. A data-analysis calculation is one you apply […]
SQL Server Collation
Collation is not a simple topic in SQL Server. There is an article written by Robert Sheldon called […]
Unicode and Character Sets
This post is based on an article by Wikipedia and Joel Spolsky. Joel Spolsky is the co-founder of […]