SWiK
» tagged pages
» logout
User:Staple
Return to User:Staple

SQL Server DBA FAQs and Tips - 296 Questions/Tutorials

(or Cancel)

(Editing anonymously: to be credited for your changes, login or register a new account)

other page actions:

Tags Applied to this Topic

No one has tagged this page.
Tag this Topic | Tagging Details

User:Staple Wiki Pages

See all 26 Pages
Syndication Feed on http://dba.fyicenter.com/faq/sql_server/atom.xml
Edit This

Wednesday, July 11, 2007

SQL Server FAQ - Writing Inner Joins with the WHERE Clause

How To Write an Inner Join with the WHERE Clause? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with I...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - Writing Character String Constants or Literals

How To Write Character String Constants or Literals? - A collection of 18 FAQs on Transact-SQL language data constants or literals and value ranges. Clear answers are provided with tutorial exercises on entering data constants or literals; quoted charac...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - WHILE - Statement Structure for Loops

How To Use WHILE Loops? - A collection of 5 FAQs on Transact-SQL language conditional statements and loops. Clear answers are provided with tutorial exercises on IF ... ELSE statements; WHILE loops; statement blocks; BREAK and CONTINUE statements.
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is Transact-SQL Language

What Is Transact-SQL Language? - A collection of 19 FAQs on Transact-SQL language basics and data types. Clear answers are provided with tutorial exercises on writing Transact-SQL statements; entering comments; ending and running statement batches; GO a...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is SQL Language

What Is SQL Language? - A collection of 19 FAQs on Transact-SQL language basics and data types. Clear answers are provided with tutorial exercises on writing Transact-SQL statements; entering comments; ending and running statement batches; GO and PRINT ...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is Microsoft SQL Server

What is Microsoft SQL Server? - A collection of 14 FAQs on SQL Server 2005 Express Edition download and installation. Clear answers are provided with tutorial exercises on installing SQL Server 2005 Express Edition; installing .NET Framework Version 2.0...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is Index Fragmentation

What Is Index Fragmentation? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes created by primary key and unique co...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Transact-SQL Statement Batch

What Is a Transact-SQL Statement Batch? - A collection of 19 FAQs on Transact-SQL language basics and data types. Clear answers are provided with tutorial exercises on writing Transact-SQL statements; entering comments; ending and running statement batc...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Transact-SQL Statement

What Is a Transact-SQL Statement? - A collection of 19 FAQs on Transact-SQL language basics and data types. Clear answers are provided with tutorial exercises on writing Transact-SQL statements; entering comments; ending and running statement batches; G...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Table

What is a table? - A collection of 16 FAQs on creating and managing tables on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting tables; reviewing, renaming, deleting and adding table columns; changin...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Subquery in a SELECT Query Statement

What Is a Subquery in a SELECT Query Statement? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN,...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a SELECT Query Statement

What Is a SELECT Query Statement? - A collection of 20 FAQs on SQL SELECT query statements. Clear answers are provided with tutorial exercises on simple SELECT query to select specific rows and returning specific columns; applying group aggregation func...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Database

What is a database? - A collection of 16 FAQs on creating and managing databases on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting databases; setting current database; bringing databases offline a...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Constant or Literal

What Is a Constant or Literal? - A collection of 18 FAQs on Transact-SQL language data constants or literals and value ranges. Clear answers are provided with tutorial exercises on entering data constants or literals; quoted character strings; date and ...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is a Boolean Value

What Is a Boolean Value? - A collection of 14 FAQs on Transact-SQL language Boolean values and logical operations. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE expressions; BETWEEN and IN ...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Is an Expression

What Is an Expression? - A collection of 14 FAQs on Transact-SQL language numeric expressions and functions. Clear answers are provided with tutorial exercises on writing numeric expressions; arithmetic operations; implicit data type conversions; explic...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Causes Index Fragmentation

What Causes Index Fragmentation? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes created by primary key and uniqu...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Are Views

What Are Views? - A collection of 21 FAQs on SQL Server database views. Clear answers are provided with tutorial exercises on creating and dropping views; defining and viewing view columns; creating views from multiple tables; inserting, updating and de...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Are Logical/Boolean Operations

What Are Logical/Boolean Operations? - A collection of 14 FAQs on Transact-SQL language Boolean values and logical operations. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE expressions; BET...
posted at 02:39 PM. tags: .

Wednesday, July 11, 2007

SQL Server FAQ - What Are Indexes

What Are Indexes? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes created by primary key and unique constraints; ...
posted at 02:39 PM. tags: .
Page 1 | Next >>
Username:
Password:
(or Cancel)