Recent Blogs and Articles

Welcome to SQL Matters

SQL Matters is a resource for SQL Server Developers, Architects, DBAs and others interested in SQL Server and related technologies . Our site contains a wide range of articles, tips, blogs, quiz questions and other information about the SQL Server range of products. This includes Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and some other products that we feel might be of interest to the SQL Server community such as PowerPivot and Report Builder.

Here are some examples of technical information that you might be interested in :

Featured Tip

How to Add, Delete or Rename a Column in a Table Using SQL

In many circumstances columns in a table can be removed, added or renamed without having to drop and recreate the table. This tip describes how to do this using SQL commands such as ALTER TABLE and sp_rename.

Featured Script

Creating a comma separated list of all columns in a table

This SQL script creates a comma separated list of all columns in a table. This can be useful for creating SQL INSERT and SELECT statements etc.

Quick Quiz : DATALENGTH results

What is the result of the following SQL query ?
DECLARE @MyStr NVARCHAR (100)
SET @MyStr = 'ABC'
SELECT DATALENGTH(@MyStr)
Choose one : a) 3    b) 6    c) 50    d) 100