
	SQL Server

What's New...


			Avoid SQL database design disasters Would you be embarrassed if an outsider took a good look at your SQL Server database design? In this tip, SearchSQLServer.com contributor Brian Walker shares some alarming design disasters for you to avoid.

			Tuning your SQL Server hardware

			Hacking SQL databases with free tools

			Move from SQL local disk storage to SANs

Tips for tuning SQL Server 2005 to improve reporting ...
EXPERT ANSWER - We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million ...

MORE ON SQL SERVER PERFORMANCE AND TUNING

Using DATEADD and DATEDIFF to calculate SQL Server ...
TIP - Here's how to use DATEADD and DATEDIFF in SQL Server to calculate datetime values in T-SQL queries, modify data and to use within your table definitions.

MORE ON SQL/TRANSACT SQL (T-SQL)

SQL errors and other failures fixed from the trenches
TIP - Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.

MORE ON SQL SERVER PERFORMANCE AND TUNING

SQL Server consolidation: Why it's an optimization ...
TIP - SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.

MORE ON SQL SERVER UPGRADE AND MIGRATION

SQL Server Administration
SQL Server availability, SQL Server backup and recovery, SQL Server security, SQL Server performance and tuning, SQL Server clustering, SQL Server DW/BI, SQL Server replication, SQL Server database design and modeling ...

EDITOR

Heidi Sweeney
Have an idea or suggestion? Let me know.

SQL Server Development
.Net development, C#, SQL/Transact SQL (T-SQL), Stored procedures, Visual Basic, Web services/SOA, XML

SQL Server Platform
SQL Server 2005 (Yukon), SQL Server 2008 (Katmai), SQL Server overview, SQL Server upgrade and migration

SQL Server Management Issues
SQL Server ROI and TCO, SQL Server career advice, SQL Server competitors, SQL Server licensing, Strategy and planning

Temporary tables in SQL Server vs. table variables: Learn about using temporary tables vs. table variables in SQL Server when storing data for executing T-SQL code.
SQL Server errors, failures and other problems fixed from the trenches: Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance...
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005: Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as ...
SQL Server stored procedures tutorial: Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to...
Simplify queries with SQL Server 2005 common table expressions (CTEs): Use SQL Server 2005 common table expression (CTE) for an improved query and recursive query. Learn to create SQL...

SQL Server.

SQL Server news, technical tips and industry experts available at your fingertips! Use our site map below to navigate resources on top of mind topics such as: SQL Server Administration , SQL Server Development , Security and SQL Server 2005 (Yukon) .

SITE FEATURES

	All-in-One Guides

	Ask the Experts

	Windows IT Downloads

	Events & Conferences

	Glossary

	ITKnowledge Exchange

	Learning Center

	Meet the Editors

	Multimedia

	News

	New Product Showcase

	Polls

	Products & Vendors

	RSS

	SQL Server Topics

	Tips & Newsletters

	White Papers

GO TO FULL SITE INDEX

MEMBERS

MORE INFO

About Us

For Advertisers

GET E-MAIL UPDATES

Receive SQL Server-related news, tech tips, and more delivered directly to your Inbox. Sign-up by selecting one or more topics and submit your e-mail address below.

		Database Installation, Upgrade and Migration
		Data Warehousing and Business Intelligence
		Security



Not a member? We'll activate your FREE membership with your subscription.

MEMBER BENEFITS

	This tip gives solutions to common SQL Server errors and failures.

	Register to get free newsletters on the SQL Server topics you choose!