:::: MENU ::::

Posts Categorized / T-SQL Enhancements

  • Nov 05 / 2008
  • 0
dbDigger, Security and Permissions, T-SQL Enhancements

Trustworthy (TRUSTWORTHY) in SQL Server 2005

Trustworthy option is used to control access to resources outside the database. When trustworthy is set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, database modules like user-defined functions and stored procedures that use an impersonation context can access resources outside the database. When Trustworthy is set to FALSE, database modules that use an impersonation context cannot access resources outside the database.
  • May 29 / 2008
  • 1
dbDigger, Enhancement in new versions, T-SQL Enhancements

SQL Server 2008 major enhancements

As with SQL Server 2008, there are many new features that have major impact regarding to optimization and control. Major updates are

  • compression
  • plan freezing
  • changes in MERGE statement
  • star join performance
  • parallel scan of partitioned tables
  • External Key Management
  • Enhanced Auditing
  • Enhanced Database Mirroring
  • Hot Add CPU
  • Performance data collection
  • Extended Events
  • backup compression
Pages:123
Consult us to explore the Databases. Contact us