Thoughts on some of the latest items removed.
Perusing the list here are a few notable ones for me. We can’t let these go by without a commentary on my favorites, so enjoy!
Features not in the next version
1) Compatibility level 80 – Finally after ten years we’re getting away from SQL Server 2000. Unfortunately where I sit today, still seeing some SQL 2k boxes. Uh oh.
2) AWE – wasn’t this confusing as hell anyway? Glad it’s gone.
3) sp_dboption – just used this the other day. They’re seemingly rolling everything into ALTERs.
4) SET ROWCOUNT – still like using it, not sure why they have to get rid of it. Oh well.
5) *= and =* - the threat has finally become reality!
6) sqlmaint utility – working with SQL Server the past 13 years and I still haven’t figured this one out.
Features to be removed within the next 20 yrs
1) Database compatibility level 90 – really?
2) The following
- SET ANSI_NULLS OFF and ANSI_NULLS OFF database option – Sure will miss geeking with nulls when this goes away.
- SET ANSI_PADDING OFF and ANSI_PADDING OFF database option – don’t care.
- SET CONCAT_NULL_YIELDS_NULL OFF and CONCAT_NULL_YIELDS_NULL OFF – always going to be set to ON now. Um, yeah probably a good idea. Never really wrote an expression where I actually wanted NULL as my result set.
3) DBCC DBREINDEX, DBCC INDEXDEFRAG, DBCC INDEXDEFRAG, DBCC SHOWCONTIG, DBCC PINTABLE – Sorry to see these old friends go away.
4) XP_API – isn’t this really the ODS API? What on earth is XP api? Anyway, hate to see this one go as well. There was something to be said for writing extended stored procedures. Ken Henderson spoke at a local sql user group 7-8 years ago; taught me how to write them. These were fun to write and filled lots of hours of mine, dorking with the c/c++ code. They were special.
5) sp_configure 'allow updates' – have run this one 14,000 times in my day it seems.
6) SQLMail – We can only thank Jesus, Mary, Joseph, and all of the Angels and Saints for this one.
7) WRITETEXT, UPDATETEXT, READTEXT – was there ever a worse implementation of something in SQL Server?
8) Three-part and four-part column references in SELECT list – yeeeichs! Better fire up SQL Server Upgrade Advisor/SQL Server Upgrade Assistant for new upgrades/migrations!
9) Numbered procedures – I always loved these. Most people never knew that you could number them!
10) Not ending Transact-SQL statements with a semicolon – see #8. Ugh.
11) Use of #, ## as temporary table and temporary stored procedure names –they finally removed my favorite table name. Only a few of us knew about this. It’s the one… with no name! haha
Lee
--------------------------
You’ll not find these types of interesting facts anywhere but on this blog site.
Site: http://msdn.microsoft.com/en-us/library/ms143729.aspx
6a80e491-f4ce-400d-99f7-d80c361d717a|0|.0