Problem solve

SQL Transact SQL T SQL

• T-SQL tricks for SQL Server 2012: T-SQL functions

  In this second in a series of tips about new T-SQL features in SQL Server 2012, expert Robert Sheldon explores more tricks for getting the most out of T-SQL functions. Continue Reading

• T-SQL tricks for SQL Server 2012: The joy of data values

  In the first article in a series by about changes and new features in T-SQL in SQL Server 2012, expert Robert Sheldon explores the PARSE and TRY_PARSE functions. Continue Reading

• More T-SQL statements in SQL Server 2012 you need to know about

  In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more. Continue Reading

• Three new T-SQL commands in SQL Server 2012 to make your life easier

  Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors. Continue Reading

• Split root table with T-SQL in SQL Azure Federations

  SQL Azure Federations can help manage massive amounts of data, says Roger Jennings. In Part 2 of this two-part series, read on for instructions on splitting the federation root table. Continue Reading

• Manage, query SQL Azure Federations using T-SQL

  Can SQL Azure help you manage “big data?” SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables.Continue Reading

• The most dangerous game: Hunting down bad SQL query performance

  SQL Server is faster when the queries behind your applications are faster. Learn how to spot bad SQL query performance, and then work with developers so you can improve throughput.Continue Reading

• Exploring T-SQL metadata functions in SQL Server 2008

  Metadata functions in T-SQL can help uncover information about database names, objects and more. Learn the basics of metadata functions and how to apply them here.Continue Reading

• Uncovering database file information with T-SQL metadata functions

  Admins can use metadata functions to reveal detailed information about SQL Server files and filegroups, including file names, IDs and file properties.Continue Reading

• Inspecting property settings with T-SQL metadata functions

  There are plenty of other uses for SQL Server 2008 metadata functions beyond just the basics. This includes the ability to view object properties, such as columns and data types.Continue Reading

• An introductory look at T-SQL system functions

  Get the basics on working with various system functions in T-SQL to help assess the finer details of your data.Continue Reading

• Digging deeper with T-SQL system functions and language tools

  Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server.Continue Reading

• The basics of SMO scripting for database objects

  The use of SQL Server Management Objects streamlines the process of scripting database objects, allowing DBAs and developers to customize code using basic SMO scripting know-how.Continue Reading

• Dissecting the SELECT query syntax in T-SQL

  With so many possible options and extensions, translating complex SELECT statements can be a challenge. DBAs can clear the air by breaking them down piece by piece.Continue Reading

• Combining T-SQL subqueries with operators in SQL Server

  Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.Continue Reading