• Troubleshoot SQL Server database performance with T-SQL

    Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications.

    alimcitp250 pointsBadges:
  • Part 1: How cursors work

    T-SQL cursors are like skyscraper window washers traveling up and down the skyscraper to stop at each window. Here Hilary Cotter explains exactly how cursors work.

    ITKE380,445 pointsBadges:
  • Create a user-defined server role in SQL Server 2012 with T-SQL, SSMS

    Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012.

    ITKE380,445 pointsBadges:
  • Nine T-SQL best practices

    Choosing the right data type and avoiding dynamic SQL are two of the nine T-SQL best practices that author Basit Farooq explains here.

    alimcitp250 pointsBadges:
  • Using T-SQL data types in SQL Server 2008

    Learn the numerous data types used in SQL Server 2008's Transact-SQL language in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide."

    ITKE380,445 pointsBadges:
  • Pitfalls of using T-SQL cursors

    Cursors have a bad reputation: They're considered poor performers, resource hogs and a favorite tool of every inexperienced DBA. But they do have a place. Contributor Hilary Cotter explains how cursors work and their pros and cons.

    ITKE380,445 pointsBadges:
  • Date, time and number data types in SQL Server

    In this book excerpt on basic T-SQL programming constructs, date and time, integer numbers, approximate numbers, exact numbers, monetary and binary data types are defined and examples given.

    ITKE380,445 pointsBadges:
  • Character string data types

    There are four different character data types that store character strings: char, varchar, varchar(max), and text. There are also four character data types for storing unicode data: nchar, nvarchar, nvarchar(max) and ntext. This book excerpt on T-SQL constructs explains these data types.

    ITKE380,445 pointsBadges:
  • T-SQL performance problems and solutions

    Don't assume all SQL Server performance problems are database-related. Poorly written T-SQL code could be to blame. Learn about common problems and workarounds in this clinic.

    ITKE380,445 pointsBadges:
  • Sample T-SQL stored procedure: P_DisplayProductDetails

    This sample T-SQL stored procedure to be debugged displays product details from the AdventureWorks database using a function to rank the unit price for each product subcategory.

    ITKE380,445 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.