Posts tagged with "SQL"

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

MS SQL: Parameter Sniffing

May 21, 2012 by Christoff Truter

A while ago one of our clients reported a bit of a peculiar performance problem when accessing a certain report in one of their systems.


Interesting Exceptions: C# - Cannot load dynamically generated serialization assembly

June 19, 2011 by Christoff Truter - 2 Comments

Post about a System.InvalidOperationException that occurs when using webservices and the XmlSerializer class within SQLCLR procedures

C#   SQL  

MS SQL Basics : scope_identity(), @@identity, IDENT_CURRENT

March 31, 2011 by Christoff Truter

How to retrieve the last inserted identity (id) in MS SQL


Miscellaneous : Coalesce

November 2, 2010 by Christoff Truter

The basic purpose of a coalesce function/operator is to return the first non null value in a list of values

C#   PHP   SQL  

SQL 2005/2008 - XML Type : modify method

September 13, 2010 by Christoff Truter

How to update/remove/insert nodes in a sql 2005/2008 xml field