SQL Server COUNT
In T-SQL, COUNT returns the number of items in a group. COUNT works like the COUNT_BIG function. The […]
sql
SQL Server Collation
Collation is not a simple topic in SQL Server. There is an article written by Robert Sheldon called […]
SQL Server Apply
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause. APPLY allows the […]
SQL Server Error 15517
There is a good article at SQLServerCentral.com that helps you troubleshoot this error 15517 on SQL Server. I […]
SQL Server Logical Query
As a SQL Server practitioner, it is important to understand logical query processing. The following list is found […]
Sample Relational Databases
You can use existing databases for testing purposes. If you are testing queries or just wanting a sample […]
SQL Joins using Geographic Data
In this post we illustrate SQL joins using a common example of geographic data in a Microsoft Access […]
SQL Server Insert Into Select Part 2
This post shows you how to insert data into an existing empty table from two other tables using […]
SQL Server Wrong Server Name
In your SQL Server code are you using @@SERVERNAME? This can return the wrong information. For me it […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
SQL Server Documentation
There are several ways to document a database. This post will only discuss some of the queries you […]
SQL Server Linked to Excel
You can link Excel to a SQL Server database so that you can read data from SQL Server […]