Email Alerts
-
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. Feature
-
Top 10 SQL Server development tips of 2008
Here are the top 10 most viewed SQL Server development tips of 2008. From converting date/time values into character types, working with DATETIME and SMALLDATETIME in SQL Server 2005, using a stored procedure to find the size of SQL Server tables and... The Year in Review
-
Supertype and subtype tables in SQL Server
Learn how to physically implement supertype and subtype tables and clusters on a SQL Server in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones. Book Excerpt
-
SQL Server and data manipulation in T-SQL
Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson an... Book Excerpt
-
Top 10 SQL Server development questions
Development in SQL Server can put you in a crunch and seeking for a quick solution. We've compiled a Top 10 list of your frequently asked questions when it comes to SQL Server development. In this quick reference you'll get solutions to combat proble... FAQ
-
FAQ: Creating and altering SQL Server tables
Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help. FAQ
-
FAQ: SQL Server stored procedure how-tos
Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines. FAQ
-
Top 10 T-SQL tips for improved SQL Server development
Having difficult with your T-SQL programming extensions or simply want to make improvements within your SQL Server development? We've compiled a Top 10 list of the most popular tips your peers are reading. Find out how to script SQL Server backups, w... Top Expert Tips
-
Script example for SQL Trace
Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace, from how to use trace definition through incorporatin... Step-by-Step Guide
-
How to use SQL Trace definition
Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace, from how to use trace definition through incorporatin... Step-by-Step Guide
- See More: Essential Knowledge on SQL-Transact SQL (T-SQL)
-
SQL Server freebie: PromptSQL for word completion
This add-on application, available for a 30-day free trial, provides auto-complete functionality as you type for programs used to create SQL statements. News | 23 Nov 2005
-
Step 3: Consider using implicit transactions
Get up to speed on server-level options to add another layer of integrity protection. Article | 13 May 2005
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. The Reluctant DBA
-
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. Tip
- See More: Tips on SQL-Transact SQL (T-SQL)
-
SQL Server trigger vs. stored procedure to receive data notification
Learn why using a SQL Server stored procedures vs. a trigger can be a preferred method to retrieve data notification from a database field. Ask the Expert
-
Manipulate column names in a SQL Server table
Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns. Ask the Expert
-
Command to seed identity column in a SQL Server table
Take a look at this command using a variable to seed an identify column in a SQL Server table. Ask the Expert
-
INSTEAD OF trigger to update a SQL Server table
Find how to use INSTEAD OF trigger to update a SQL Server table for myDate and myTime. Ask the Expert
-
VARCHAR and NVARCHAR data types in SQL Server 2005
Having trouble with using VARCHAR and NVARCHAR data types in SQL Server 2005 Express or Enterprise Edition? Learn which properties could be the problem. Ask the Expert
-
Executing a trigger before SQL Server table is updated
Triggers in SQL Server can be executed before a table is updated. Get triggers to read and extract table values before and after the table is updated. Ask the Expert
-
SQL vs. T-SQL
SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert Adam Machanic. Ask the Expert
-
SQL Server 2005 T-SQL debugging alternatives
With no T-SQL debugger in SQL Server Management Studio you can use Visual Studio 2005's T-SQL debugger, but if you're not a fan of step-debugging, SQL Server 2005 expert Adam Machanic has detailed some alternatives. Ask the Expert
-
How to find and delete file names
SQL Server Development expert Joe Toscano suggests working with the FileSystemObject and ActiveX Script Tasks when listing file names in .bak and .trn extensions. View his helpful sample codes. Ask the Expert
-
Trouble seeing source fields
SQL Server Development expert Greg Low offers a suggestion about invisible source fields. Ask the Expert
- See More: Expert Advice on SQL-Transact SQL (T-SQL)
-
T-SQL (Transact-SQL)
Word
-
OLE DB (OLEDB or Object Linking and Embedding Database)
Word
-
query
A database query can be either a select query or an action query. A select query is simply a data retrieval query. An action query can ask for additional operations on the data, such as insertion, updating or deletion. Word
-
SQL (Structured Query Language)
SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Word
-
Collaboration Data Objects (CDO)
Word
-
fetch
Word
-
DAO (Data Access Objects)
Word
-
ACID (atomicity, consistency, isolation, and durability)
Word
-
commit
Word
-
container
Word
-
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. Tip
-
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. Tip
-
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. Feature
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. The Reluctant DBA
- See More: All on SQL-Transact SQL (T-SQL)
About SQL-Transact SQL (T-SQL)
Transact SQL, often called T-SQL, is Microsoft's implementation of the SQL language. Developers for SQL Server database management systems are using T-SQL statements for any application communicating with an instance of SQL Server does so by sending Transact SQL statements to the server. Improve your T-SQL skills with these T-SQL overviews, best practices and stored procedures. In this reference, 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.