Tag: sql-server

All the articles with the tag "sql-server".

• Setting your database Compatibility Level to match the SQL Server version

  Published:7 Mar 2010

  2 min read

  This article explains how to set the Compatibility Level of a database to match the version of SQL Server. It provides a script that can be used on SQL Server 2005 and 2008 instances.

• Limiting CTE recursion depth in SQL Server

  Published:14 Dec 2009

  3 min read

  This article provides a few different methods for limiting the recursion depth of Common Table Expressions (CTEs) in SQL Server, such as reaching the default maximum recursion depth, setting the MAXRECURSION query hint, or manually controlling the recursion level.

• SQL Server 2008 SP1

  Published:13 Apr 2009

  1 min read

  Service Pack 1 for SQL Server 2008 is available for download, offering a rollup of cumulative updates and bug fixes. Despite lacking new features, the service pack is worthwhile due to the bug fixes it includes.

• Renaming a computer running SQL Server

  Published:15 Jan 2009

  1 min read

  After renaming a computer running SQL Server, the value returned for @@SERVERNAME may not be updated. To fix this, run the sp_dropserver and sp_addserver stored procedures using the current @@SERVERNAME value for the old name and SERVERPROPERTY('ServerName') for the new. Restart the service for the change to take effect.