Displaying posts categorized under

2008

SQL 2008 RTM today

Well it looks like SQL 2008 RTM’d at TechEd in South Africa.  Take a look at Aaron Bertrand’s post or sqlmag

Did You Know? SQL Server 2008 includes Resource Governor

Resource Governor enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests. In an environment where multiple distinct workloads are present on the same server, Resource Governor enables you to differentiate these workloads and allocate CPU and/or memory as they are requested, based on the limits that [...]

Did you know? SQL Server 2008 includes Transact-SQL Debugger

The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functions by observing their run-time behavior. You can start the debugger when you are using the Database Engine Query Editor window. By using the Transact-SQL debugger, you can do the following: Step through the Transact-SQL [...]