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

    ITKE351,905 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.

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

    ITKE351,905 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.

    ITKE351,905 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.

    ITKE351,905 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.

    ITKE351,905 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.

    ITKE351,905 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.

    ITKE351,905 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.

    ITKE351,905 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...

    ITKE351,905 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.