SQL Server Engine Tips

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

Browse by Tags

Tagged Content List
  • Blog Post: Using catalog views in SQL Server 2005

    Did you know that the catalog views in SQL Server 2005 exposes metadata for various objects in a database and at the server-level? This is the preferred method of accessing metadata. It is a much richer mechanism that doesn't require access to system tables or undocumented columns or status bits. If...
  • Blog Post: Use of INFORMATION_SCHEMA views to access temp tables.

    An MVP recently sent us an email asking how to use the INFORMATION_SCHEMA views to access temp tables. This MVP thought the session ID (spid) was needed to construct the suffix. Here was our response: ========================= Hi, The algorithm for generating the temp table name suffix changed...
  • Blog Post: Determine primary keys and unique keys for all tables in a database...

    With SQL Server 2005, there are new ways to obtain richer metadata in a database and more efficiently. We have introduced new catalog views that exposes all the metadata that SQL Server uses and can be created by various DDL statements. The older ANSI SQL style INFORMATION_SCHEMA views are also still...
  • Blog Post: Direct dependencies on a column...

    I came across a question recently about discovering the constraints that are dependent on a column like CHECK constraint, defaults and so on. In trying to solve that problem, I came across few interesting solutions that uses some new relational features and the catalog views available in SQL Server 2005...
Page 1 of 1 (4 items)