-
Translating information requests into SQL SELECT statements
Learn how to translate information requests into suitable SQL SELECT statements in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." Y...30 Jul 2008
-
Using DISTINCT in SQL to eliminate duplicate rows
Learn how to use the DISTINCT keyword to eliminate duplicate rows in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn ho...30 Jul 2008
-
SQL SELECT statement and SELECT query samples
Discover sample SQL SELECT statements and result sets in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." These sample databases and ...30 Jul 2008
-
Using the ORDER BY clause of the SELECT query in SQL
Learn how to use the ORDER BY clause of the SELECT query to specify the sequence of rows in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edi...30 Jul 2008
-
How to use the SELECT statement in SQL
Learn the basics of the SQL SELECT statement in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use SELECT to ac...30 Jul 2008
-
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
Understanding date/time data types in SQL Server can be difficult, especially when you add TIMESTAMP into the mix. In this tip, you'll learn how data is stored within DATETIME and SMALLDATETIME and...29 Jul 2008
-
How to configure Database Mail in SQL Server 2005 to send mail
Sending mail via SQL Server has become a much more reliable process. Here, SQL Server expert Roman Rehak explains how to configure Profiles and Accounts within the Database Mail architecture for se...23 Jul 2008
-
SQL Server stored procedures tutorial: Write, tune and get examples
This SQL Server stored procedures tutorial covers three areas for simplifying database development. A stored procedure, sometimes called the work horse of the database, also provides an important l...21 Jul 2008
-
Virtual database storage for SQL Server: Friend or foe?
With careful management, virtualized storage offers amazing flexibility when migrating data between disk drives. Yet, without careful monitoring, this same flexibility can make life a lot harder fo...17 Jul 2008
-
Upgrade live applications to SQL Server 2005 for high availability
Part four in this series takes you through the stages of maintaining live applications. Find out how to push live data from one cluster to another using a conversion database and replication techni...09 Jul 2008
-
How to use rank function in SQL Server 2005
SQL Server 2005 T-SQL includes a set of functions that let you rank the rows in your result set. SQL Server expert Robert Sheldon defines and gives examples of how to use the four ranking functions...07 Jul 2008
-
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to a...03 Jul 2008
-
Tutorial: SQL Server 2005 Analysis Services
These tips outline helpful features and give examples of Analysis Services in SQL Server 2005 functionality. Get the scoop on how to use SQL Profiler for Analysis Services, how to work with cubes f...02 Jul 2008
-
SQL Server high availability when upgrading to SQL Server 2005
The pursuit of minimal downtime is complex when upgrading an Active/Active cluster to SQL Server 2005/Windows Server 2003. In part three of this series, SQL Server expert Matthew Schroeder outlines...01 Jul 2008