THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server "Denali"
SQL Server v.Next (Denali) : Breaking change to system databases / database_id / DB_ID()
Currently you may have code that makes decisions based on sys.databases.database_id or the built-in DB_ID() function. I have seen a lot of code out there that checks the database_id, and behaves differently based on the assumption that a value between 1 and 4 (as well as 32,767 - the resource database) means it is a system database, and anything ...
July 8, 2011
SQL Server v.Next (Denali) : Breaking change to fn_virtualfilestats
Yesterday I posted a general warning about changes to Denali that will potentially break your existing code base, with a strong suggestion to grab the summer CTP as soon as it is available and start testing. I posted an example of a breaking change that will not be documented since it affects a commonly-used but undocumented DBCC command (DBCC ...
June 28, 2011
Brought to you by