Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()

Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.

Get Record count of all tables of current database

This script will return record count of all user tables from the current database

SQL Server Schema Binding and Indexed Views

How do you handle this error? "Cannot create index on view, because the view is not schema bound".

Object Names

Faking Multidimensional Arrays in T-SQL made easy!

Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!

Text Data

Compare Dates

The following article shows how to compare dates in an iterative manner for a particular set of records in a single query

Introduction to New T-SQL Programmability Features in SQL Server 2008

This paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements.

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?

Audit data using SQL Server 2005's COLUMNS_UPDATED function

Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.