Finally we get a T-SQL debugger back into SQL Server Management tools. Evidently it was announced at the Launch Event in LA that Microsoft has decided to put the T-SQL Debugger into SQL Server Management Studio. This is something that was in Query Analyzer for SQL 2000 but we haven’t had it for 2005 up [...]
One of the things I’ve been doing lately for an upgrade from SQL 2000 to SQL 2005 is restructuring databases, adding filegroups and files to split out the data and non clustered indexes, leaving only the system tables in the primary filegroup. This is actually fairly simple as we’re just dropping the clustered indexes and [...]