t-sql

t-sql

Get Rid of the Duplicate Records

Time after time I'll get a table that has duplicates in it and I have to clear out all the duplicate entries while leaving a distinct set of records. There's a

t-sql

SQL 102 – CLUSTERED vs. NONCLUSTERED Indexes

Previously, I covered the basics of creating an index using CREATE INDEX. Today, I'm going to dig a little deeper. I'd like to teach you the difference in an

t-sql

SQL 301 – Views

At this point I'm sure you know how to CREATE and ALTER a VIEW. But today I'd like to go into a little more detail on views. I'd like to cover updatable views,

t-sql

Find Tables Containing a Certain Column

Today I had to find all the tables that contained a certain column. I was going to rename the column, so it made more sense when you see it in my tables. In

t-sql

Correlated Subqueries with Comparison Operators

If you haven't used a sub query yet, I'm surprised. They can be incredibly useful. They can also be a crutch...but like I say time and again, each tool has it's

t-sql

Insert Triggers

An insert trigger is a Data Manipulation Language (DML) trigger that acts when a new record is added to the table. CREATE TRIGGER t_tableName_insert ON

transaction

Return a Success/Failure to a Job based on a SQL query?

Over on Experts Exchange, someone posted a question I felt I could answer.  The user posted a question on how to return a failure and not run a job.  I

t-sql

Triggers

Triggers are one of the most misunderstood features in Microsoft SQL server. Most of that misunderstanding comes from people implementing triggers with little

t-sql

SQL Session – What’s new in Katmai (SQL Server 2008)

If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the

examples

Exception Handling

Learning to handle errors better can be one of the skills that will really set you apart from other SQL Developers. You can do constant unit testing after each

microsoft sql

Identity Columns

An IDENTITY column is a column that automatically gets it's value set by the database engine when a new record is added. This is one of the oldest ways

t-sql

Computed Columns

What is a Computed Column A computed column is a column that users will not enter data for, but the SQL Server will compute and store a value in. The expression