dev
SQL 102 – UNIQUE INDEX
Ok, you understand how to create an INDEX. You understand the differences in CLUSTERED and NONCLUSTERED indexes. Did you know you could index a view? You can.
dev
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
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
dev
sql server 2000 + How to display date time
Over on Experts Exchange I saw a question that I get all the time, "How do I format this DATETIME like x?" If they're asking to learn, I point them over to the
dev
SQL Session – Migrating From DTS to SSIS
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
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
dev
Default Values
When you start creating tables and setting them so they can't have NULL values, you'll eventually need a way to define a default value for the column. A default
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