T-SQL

Compare Dates in an iterative manner for a particular set of records

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000

Report upcoming SQL Jobs

Which jobs are ready to run the next 24 hours / this weekend?

UNION error

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