Home
>Topics
>Microsoft SQL Server Administration
>SQL-Transact SQL (T-SQL)

SQL Server Topics:

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.

In this topic:

Display in sets of:

1 - 10 of 19 in Reference & Learning

<< Previous 1 2 Next >>

Supertype and subtype tables in SQL Server 16 Sep 2008
Book Excerpt - ...
SQL Server and data manipulation in T-SQL 16 Sep 2008
Book Excerpt - 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 and...
How to use SQL Trace definition 19 Mar 2007
Step-by-Step Guide - 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 incorporating...
T-SQL Learning Guide 20 Jul 2006
Learning Guide - ...
Visual Studio debug windows 06 Jul 2006
Feature - ...
How to run the stored procedure 06 Jul 2006
Feature - ...
Where to start debugging the stored procedure 06 Jul 2006
Feature - ...
Sample T-SQL stored procedure: P_DisplayProductDetails 06 Jul 2006
Feature - ...
Working with typed DataReader and SqlResultSet data 15 May 2006
Book Excerpt - ...

1 - 10 of 19 in Reference & Learning

SQL-Transact SQL (T-SQL) - SQL Server Topics

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Exchange
Windows Development
Windows IT
Windows Server

Business Analytics
- How to improve business intelligence performance with BI automation
  
  Get tips on how to improve business intelligence performance with the help of BI automation. You’ll learn about the value of BI automation, potential roadblocks and more.
- Myth: Midsize companies need specialized business intelligence skills
  
  Find out if IT workers and business users at midsize companies need specialized business intelligence skills and how businesses can leverage the BI skills they already have.
- Business intelligence cost concerns shouldn’t stop midsize companies
  
  Read about business intelligence cost myths for midsize companies and learn about the advantages that midsize businesses can get from in-memory analytics and other BI technologies.
Data Center
- Improve benchmark performance with simple optimizations
  
  While benchmarking is great for measuring system performance, benchmarking tools themselves are applications capable of overtaxing the CPU. However, simple optimizations can ensure benchmark performance by preventing these tools from overwhelming the system.
- Customize data center cooling design for increased energy efficiency
  
  Choosing to customize your data center cooling design can have a big impact on data center energy efficiency. Rather than opting for one-size-fits-all products that consume an unnecessary amount of power, look to customize cooling for specific components in your facility, says one expert.
- HP reloads for 'converged infrastructure' war with Cisco
  
  HP and Cisco customers may get caught in the crossfire of the two vendors' converged infrastructure' skirmish.
Data Management
- School districts tap open source integration software to aid reporting
  
  A consortium of more than 60 school districts plans to deploy open source data integration software to simplify its complex, manual processes.
- The truth about retail data modeling software
  
  Find out if there are any high-quality retail data modeling software tools and if general-purpose tools in the data modeling market can help with retail data model projects.
- How to organize an enterprise conceptual data model development effort
  
  Find out why it’s important and how to organize an enterprise conceptual data model development. Learn how a data governance organization can help your ECDM effort.
Exchange
- The Outlook Social Connector
  
  The Outlook 2010 social connector combines users' social networks into one area, making it easier to find and manage this information within Outlook.
- The conversation view in Outlook 2010
  
  The conversation view in Outlook 2010 lets users sort through inbox clutter to easily view past email conversations within a specific message chain.
- The ignore option in Outlook 2010
  
  Using the ignore option in Microsoft Outlook 2010 allows you to remove yourself from irrelevant email conversations.
Windows Development
- Using the UniformGrid panel
  
  UniformGrid creates a mesh of equally sized cells. It's available in WPF and Silverlight and is very handy for creating game-boards for games like chess.
- Screen capture in a WPF application
  
  Using a screen capture tool is second nature to most computer users and your customers may expect to find screen capture features in your application. How much work is required to add this feature to a WPF application?
- The 'VB.NET or C#' debate: It's all in the syntax
  
  Microsoft development experts say Visual Basic and C# have become nearly identical in function as the .NET Framework has matured. Choosing whether to use VB.NET or C# is more or less a matter of which syntax style you prefer. Despite the similarities, many developers still carry a stigma against VB, said Lance Keene, president of .NET consultancy Keene Systems.
Windows IT
- SharePoint is a hit for Microsoft but still clunky for IT
  
  SharePoint is Microsoft's fastest growing server software, but IT managers still grouse about its lack of acceptance and the difficulties in supporting this increasingly common collaboration platform.
- Should Windows users have full administrative rights?
  
  Giving Windows users full administrator privileges can help reduce your workload, but it also leaves your environment vulnerable.
- Microsoft offers Windows, Exchange SP1 betas
  
  At TechEd 2010, Microsoft executives breezed through service pack news in an effort to assuage IT managers' concerns about the company's shift to cloud computing.
Windows Server
- Increased Windows support could help spur UCS adoption
  
  Though new to IT, the adoption of unified computing systems could accelerate as Microsoft partnerships lead to better UCS support for Windows servers and apps.
- Windows server management guides and learning resources
  
  Check out our collection of guides, tutorials, FAQs and more covering a wide array of Windows server administration topics and technologies.
- Free Windows performance monitoring tools not to be missed
  
  Unbeknownst to some admins, the latest versions of Windows Server include new or updated tools that can minimize the need for third-party options.