Counting references to a record in a table via Foreign Keys
I have recently needed to solve the task for my own purpose: to calculate the number of external...
SQL Server: Useful Tips for Newbies
In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
XML performance tips
Parsing data from XML using XQuery is a routine practice. In order to do this most effectively, little effort is required. Suppose we need...
