(Robert Marda) A derived table is a select statement inside parenthesis, with an alias, used as a table in a join. A simple example is: SELECT a.LastName, b.State FROM UserTable a INNER JOIN (SELECT UserID, State FROM AddressTable) b ON a.UserID = b.UserID

(Don Schlichting) An Identity column is used in SQL server to create a surrogate key value for a table. This will be a unique identifier usually in sequential order. Starting at some predefined number, the Identity column increments every time a new record is added to the table. For MS Access users,

The risks associated with your organization’s “data dependence” have never been greater. Customers and partners are accessing your data. Government regulations require audit trails of data activity. Bad data can lead to poor decision making. Internal misuse – intentional or not – can mean lost r

(Gregory A. Larsen) This is the second article in a series discussing benchmarking T-SQL query performance. The first article in this series discussed different methods of capturing the elapsed time of a T-SQL batch, pieces of a batch, or a single T-SQL statement. This article will discuss how to de

(Mark Kaelin) Achieving and maintaining optimal operational performance is the holy grail of every database designer and administrator who has created a normalized table. And, like that elusive icon, the search is seemingly never-ending and all-consuming. (R)

This will generate all default DDL in a given database. (R,script)

(Andy Warren) This is a follow up to an earlier article called Snapshot Replication for the Beginner. This week we’ll actually get some data pushed to a subscriber! At the end of the previous article we had completed construction of a publication containing one table, so we’ll pick up from there. (

(Kalen Delaney) Security concerns affect almost every action of every SQL Server user, administrator, and developer. SQL Server manages multiple collections of entities that are organized hierarchically, with the server at the top. Beneath the server level is a collection of databases, and beneath t

(Alexzander Nepomnjashiy) This article describes a well-known concept, (Data Mining algorithms, built into Microsoft SQL Server 2000 Analysis Services) and what I would like to see in the final “Yukon” SQL Server release (i.e. my expectations in a field of new / improved data mining algorithms).

(Vinod Kumar) This topic is a delicate one to handle. But here is a tool that allows you to analyze how your database is organized. To walk you through some of the detials of the tool. The tool uses excel macro and SQL-DMO to query the database. The data from the database are entered into the corres