SQL Server Apply
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause. APPLY allows the […]
Blog
Value Based Management
There is a website called Value Based Management that is a reference site for many different models for […]
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 Example
This post is a continuation of the post called SQL Server Logical Query. It is based on the […]
SQL Server Saving Changes not Permitted
In SQL Server you may get the message “Saving changes is not permitted. The change you have made […]
SQL Server Logical Query
As a SQL Server practitioner, it is important to understand logical query processing. The following list is found […]
SQL Server Exists Predicate
The term “predicate” is used to refer to an expression that determines whether something is true or false. […]
SQL Server Searching for Words
This post discusses the query you will need to be able to search inside a column in a […]
Sample Relational Databases
You can use existing databases for testing purposes. If you are testing queries or just wanting a sample […]
SQL Server Functions
This post describes how you can create a user-defined function in SQL Server. We will start off with […]
Credit Card Transactions
How do credit card transactions work? What is the process? There is an article at Grid + called […]
SQL Server SELECT TOP into variable
You need to select the TOP 1 into a variable in SQL Server. In other words you need […]