microsoft sql

t-sql

ALTER TABLE

After you've spent time designing the perfect table, someone is going to come along and ask you a question that will lead you to changing your table. It can be

t-sql

SQL 201-SELECT INTO

I've already shown you how to create a table, and how to INSERT data into that table. But did you know you can do both in one statement? The SELECT INTO

microsoft sql

SQL 201 – Locking Hints

If you've spent any time looking at another programmers code, I'm sure you've see something like this: SELECT columnName FROM tableName (NOLOCK) I'm sure you

t-sql

SQL 102 – Foreign Keys

In the simplest terms a Foreign Key in one table refers to the Primary Key of another table. Let's go back to our demo tables products and productSales. -

SQL201

Optimizing Queries

This is the first article in a never ending series of articles on how to optimize your queries. Honestly, this is a topic I'm still learning volumes about. I

SQL102

SQL 201 – Statistics

Microsoft SQL Servers collect statistical information on indexes and column data stored in each database. These statistics are used by the query optimizer to

SQL201

SELECT CASE

A useful skill to learn in SQL is how to translate a value into a description.  You’ll use it all the time.  Whether you’re turning M|F into Male or

SQL102

SQL 102 – Jobs

Now that you're familiar with stored procedures, it's time to introduce you to jobs. Jobs are like stored procedures, in that they are a set of steps performed

microsoft sql

SQL 201 – Indexes

Indexes in Microsoft SQL are just like indexes in a book. They help you jump to the information you want more quickly. In Microsoft SQL you can index one or

SQL102

SQL 102 – GRANT

As an administrator, you can execute the SELECT from the Components table and the v_Components view, and execute the usp_GetBatmobileComponentsList procedure;

t-sql

SQL 102 – Users

Before you got started working with SQL Server, someone had to set up a user account for you. Now that you're learning to become a database administrator you

SQL102

SQL 102 – Primary Keys

In SQL 101, I showed you how to create a table.  I want to build on that today by introducing the concept of a primary key.  A primary key is a column, or