Indexes That Have Not Been Used but Are Being Updated

Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.

Storing a variable with a SELECT, and why it didn't work.

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.

SELECT with DISTINCT and TOP

SET vs. SELECT

SELECT (Transact-SQL)

Indexing - Take the Hint and Leave it to the Experts

The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.

Understanding the SQL Server SELECT @@VERSION command

Check out this tip to learn about the SELECT @@VERSION command in SQL Server.

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.

How many Records Will Get Selected

Display Rows Vertically or Alphabetically

Display a row vertically when a table has hundreds of columns to avoid scrolling.