Additional Articles

Clean unused space when a variable-length column is dropped from a SQL Server table or indexed view

by Additional Articles

MSSQLTips.com

Administration

Whenever rows or columns are deleted from a table, SQL Server reuses space to accommodate new data. However, this is not the case when a variable length column is deleted. The space used by this type of column is not reclaimed automatically. Variable length columns can be of data types varchar, nvarchar, varchar(max), nvarchar(max), varbinary, varbinary(max), text, ntext, image, sql_variant, and xml. In this tip, I have tried to put forth a solution to reclaim this space and this should work for SQL 2005 and later versions.

2011-04-18

3,911 reads

SQL Transparent Hierarchical Processing of Relational, XML and IMS Data

by Additional Articles

Other

The SQL-92 standard introduced the LEFT Outer Join operation which offers a powerful alternative to standard relational processing to perform full hierarchical processing naturally and inherently. This enables SQL to transparently integrate relational data with XML, IMS and other forms of legacy hierarchical data. This can also allow the so far overlooked integration of IMS and legacy data with the Internet and XML, and visa versa.

2011-04-15

3,437 reads

Read and Write Binary Files in SQL Server with CLR

by Additional Articles

MSSQLTips.com

SQLCLR

You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.

2011-04-14

4,324 reads

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

by Additional Articles

SQL Server Performance

Replication

This article demonstrates how to prevent primary key violation issues in transactional replication.

2011-04-13

2,438 reads

Send email in a tabular format using SQL Server database mail

by Additional Articles

MSSQLTips.com

Database Mail

Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself contains the table data. This way the recipients would be able to look at the data in a tabular format, making it easier for readability. Hence we arrived at the question of how to send email from SQL Server with data in a tabular format.

2011-04-12

5,799 reads

Database Design Example: Curriculum Vitae

by Additional Articles

InformIT

Database Design

I’ve explained the database design process in a series of articles that you can find here. In this tutorial, I’ll put that information to good use and design a database from the start of the process to the finish. To keep this example to a single article, I’ll not repeat the information from those previous articles, so make sure you look those over before reading this one.

2011-04-11

5,179 reads

Continuous Integration for SQL Server Databases

by Additional Articles

SimpleTalk

software development

When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. “Database source control is no longer negotiable”. In this article, published originally in his Blog, Troy explains how to do Continuous Integration from a database that is in a Version Control System (VCS).

2011-04-08

4,700 reads