• Configure SQL Server at database level with new scoping syntax

    SQL Server 2016 adds ALTER DATABASE SCOPED CONFIGURATION to its new T-SQL statements. The statement lets DBAs control database configuration at the level of a single database.

    ITKE413,390 pointsBadges:
  • How do the T-SQL commands TRUNCATE TABLE and DELETE differ?

    TRUNCATE TABLE and DELETE are T-SQL statements with similar functions, but that doesn't make them interchangeable. They operate differently and use different amounts of SQL Server resources.

    ITKE413,390 pointsBadges:
  • What is the most important difference in use between the TRUNCATE TABLE and DELETE T-SQL statements?

    ITKE413,390 pointsBadges:
  • SQL Server 2016 T-SQL features add to DBCC CHECKDB and more

    Expert Ashish Kumar Mehta shares some of the enhancements to T-SQL ahead in SQL Server 2016. This includes a DROP IF EXISTS option and MAXDOP for DBCC CHECKDB.

    ITKE413,390 pointsBadges:
  • How will you use the new T-SQL enhancements for SQL Server 2016?

    ITKE413,390 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.

    ITKE413,390 pointsBadges:
  • 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.

    ITKE413,390 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."

    ITKE413,390 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.

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

Following