The Percent Sign in T-SQL

Top 10 Transact-SQL Statements a SQL Server DBA Should Know

Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all. MAK shares his top 10 T-SQL statements that a DBA should know.

Keywords

Automatically Generate Stored Procedures

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database

Custom Sequence Numbering

This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function

Standard Deviation

Showplan Operator of the Week - Merge Interval

When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting ways that the series helps to understand how the query optimizer works. With the Merge Interval, Fabiano comes up with some insights about the way that the Query optimizer handles overlapping ranges efficiently.

Display More Than 8000 Characters (SQL Spackle)

SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).

RowCount

Get the rowcount in all tables

BIT of a Problem

The BIT data type is an awkward fit for a SQL database. It doesn't have just two values, and it can do unexpected things in expressions. What is worse, it is a flag rather than a predicate, and so its overuse, along with bit masks, is a prime candidate for being listed as a 'SQL Code Smell'. Joe Celko makes the case.