• 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.

    ITKE352,430 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.

    ITKE352,430 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.

    alimcitp135 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."

    ITKE352,430 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.

    ITKE352,430 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.

    ITKE352,430 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.

    ITKE352,430 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.

    ITKE352,430 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.

    ITKE352,430 pointsBadges:
  • 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, why T-SQL in SSIS has pros and cons and what to do...

    ITKE352,430 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.