SQL Server Apply
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause. APPLY allows the […]
sql
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 […]
SQL Server Course at Udemy Philip Burton
If you like watching videos to learn topics, consider Udemy.com This post is about a series of videos […]
SQL Server Duplicates Part 2
This discussion of finding duplicates in SQL Server is a continuation of Part 1. We will look at […]