SQL/Transact SQL (T-SQL)

MUST READ How to use rank function in SQL Server 2005 TIP - With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions. Optimize T-SQL data types in SQL Server TIP - To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server. Top 10 T-SQL tips for improved SQL Server development TOP EXPERT TIPS - Find out how to script SQL Server backups, why T-SQL in SSIS has pros and cons and what to do about poorly written T-SQL code that's causing SQL Server performance problems. T-SQL error handling with Try…Catch blocks TIP - T-SQL Try…Catch block for SQL Server exception handling has new, improved functions to handle errors when executing T-SQL code in SQL Server 2005. T-SQL performance problems and solutions TIP - Not all SQL Server performance problems are database-related. Poorly written T-SQL code could be to blame. Identify query problems and then get the workarounds in this clinic.

EXPERT TECHNICAL ADVICE: 1 - 3 of 146

SQL/TRANSACT SQL (T-SQL) EXPERTS
			Joe Toscano SQL Server Business Intelligence consultant/Instructor ASK A QUESTION		Greg Low Lead SQL Server Consultant ASK A QUESTION

	SQL Server data conversions from date/time values to character types Submitted By: SearchSQLServer.com | 11 Aug 2008 TIP - Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.

	Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005 Submitted By: SearchSQLServer.com | 29 Jul 2008 TIP - Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.

	How to configure Database Mail in SQL Server 2005 to send mail Submitted By: SearchSQLServer.com | 23 Jul 2008 TIP - Learn how to set up SQL Server Database Mail in SQL Server 2005. In this tip, you'll see how to configure Profiles and Accounts for sending mail.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL/TRANSACT SQL (T-SQL)

REFERENCE & LEARNING: 1 - 3 of 72

	SQL and SQL Server Tutorial and Reference Guide SearchSQLServer.com | 31 Jul 2008 LEARNING GUIDE - This Back to Basics SQL tutorial and reference guide provides a great starting point and foundation for learning SQL or brushing up on your skills.

	SQL SELECT statement and SELECT query samples SearchSQLServer.com | 30 Jul 2008 BOOK CHAPTER - Discover sample SQL SELECT statements and SELECT query examples to help you learn to apply these operations.

	Using the ORDER BY clause of the SELECT query in SQL SearchSQLServer.com | 30 Jul 2008 BOOK CHAPTER - Learn how to use the ORDER BY clause of the SELECT query to sort the result set in this book excerpt. Also, learn how to save your SELECT statements.

	VIEW ALL REFERENCE & LEARNING ON SQL/TRANSACT SQL (T-SQL)

NEWS: 1 - 3 of 5

	Microsoft kills standalone WinFS file system SearchWinIT.com | 26 Jun 2006 ARTICLE - Microsoft has pulled the plug on one of Bill Gates' pet projects just over a week after he turned the technical mantle of his company over to Ray Ozzie.

	SQL Server DBMS' growing popularity is no coincidence SearchSQLServer.com | 05.26.2006 OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...

	Best SQL Server products of 2005 SearchSQLServer.com | 16 Jan 2006 SPECIAL REPORT - The editors of SearchSQLServer.com sat down this past fall to assess the 2005 crop of products. Here are the winners in the General Database Utilities category.

	VIEW ALL NEWS ON SQL/TRANSACT SQL (T-SQL)

WHITE PAPERS

	Best Practices for BlackBerry Administrators Published by: BlackBerry | 18 Aug 2008 WHITE PAPER - This paper "Best Practices for Blackberry Administrators" provides various functions that help administrators to solve various IT issues and maintain their security policy.

	Innovative Business Continuity Solutions with Syncsort BEX Advanced Recovery. Published by: Syncsort | 13 Aug 2008 WHITE PAPER - This paper describes a brief history of data protection solutions, and concludes with a description of an authentic, easily deployable product.

	Backup Express and NetApp: A Better Backup and Recovery Solution Published by: Syncsort | 13 Aug 2008 WHITE PAPER - The new technology which fulfills the ambitious goal combines the benefits of disk-based backup, continuous blocklevel incremental backup, synthesized virtual base and file-level restore.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

DOWNLOADS: 1 - 1 of 1

	PromptSQL Published by: PromptSQL | 23 Nov 2005 DOWNLOAD - PromptSQL is an add-on application that provides auto-complete functionality as you type for programs used to create SQL statements. It works with QA, UltraEdit32, Visual Studio.NET 2003, Visual Studio 2005 and SQL Server ...

	VIEW ALL DOWNLOADS ON SQL/TRANSACT SQL (T-SQL)

BEST WEB LINKS: 1 - 3 of 3

	SQL Server 2000 Survival Guide http://www.akadia.com/services/sqlsrv_programming.html | 22 Jul 2005 BEST WEB LINK - Here you find step-by-step resources for architecting, administering and managing SQL Server 2000.

	Microsoft SQL Server: Programming Forum http://www.tek-tips.com/ | 22 Jul 2005 BEST WEB LINK - This active forum dedicated to SQL Server will give answers to SQL Server's most difficult questions.

	SQL exercises SQL exercises | 03 May 2005 BEST WEB LINK - Use this site to improve your skill in building SQL Data Manipulation Language statements.

	VIEW ALL BEST WEB LINKS ON SQL/TRANSACT SQL (T-SQL)

DEFINITIONS: 1 - 3 of 8

	T-SQL 25 Apr 2002 WORD - T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error handling, row processing, ...

	OLE DB 30 Jul 2001 WORD - OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. OLE DB includes not only the Structured Query Language (SQL) capabilities of the Microsoft-sponsored ...

	query 27 Jul 2001 WORD - In general, a query (noun) is a question, often required to be expressed in a formal way. The word derives from the Latin quaere (the imperative form of quaerere, meaning to ask or seek). In computers, what a user of a ...

	VIEW ALL DEFINITIONS ON SQL/TRANSACT SQL (T-SQL)

	SEE ALSO - Topics Related to SQL/Transact SQL (T-SQL):  Web services/SOA, SQL Server stored procedures, Visual Basic in SQL Server, XML in SQL Server, C#, .NET development for SQL Server