Author: {coding}Sight

A community platform for IT specialists

Counting references to a record in a table via Foreign Keys

Constraints, Database development

I have recently needed to solve the task for my own purpose: to calculate the number of external...
Read More

SQL Server: Useful Tips for Newbies

Database development

In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Read More

XML performance tips

Database administration, Performance Tuning

Parsing data from XML using XQuery is a routine practice. In order to do this most effectively, little effort is required. Suppose we need...
Read More