Welcome to weblogs.com.pk Sign in | Join | Help

SQL Server 2005 :: The First Impression

  • I strongly recommend not configuring SQL Server 2005 Developer Edition and SQL Server 2005 Express on your development machine, unless you have lot of memory and system resources.
  • Don’t install SQL Server 2005 Management Studio and SQL Server management Studio Express CTP on a single machine; you will get weird exception in SQL Server 2005 Management Studio.
  • SQL Server 2005 Installations are long….it just takes too much time..
  • SQL Server 2005 client tools are heavy, seems like they are built in .NET
  • SQL Server 2000 client tools doesn’t work completely with SQL Server 2005, you cannot create scripts, see source of views, stored procedures and tables in Query Analyzer and cannot manage database objects from Enterprise Manager. Some functionality is slower due to compatibility overheads; like seeing parameters or table schema in Query Analyzer.
  • After SQL Server 2005 installation; if you see CPU being used by .NET Optimization services; its because; native images of .NET assemblies are not generated during SETUP; they are queued for generation. If you want to get over with it; issue >ngen executequeueditems command. For more details also see http://blogs.msdn.com/davidnotario/archive/2005/04/27/412838.aspx
  • SQL Server 2005 takes more resources to run; don’t compare it with SQL Server 2000 or mySQL; just like Exchange is not only an email server, SQL Server 2005 is also not only a database server. SQL Server 2005 has loads of things; and if you are good DB administrator; you can tune it up…
Published Thursday, December 29, 2005 2:20 PM by khurram
Filed under: ,

Comments

# re: SQL Server 2005 :: The First Impression

Thursday, December 29, 2005 2:33 PM by Ali Khan
Really!
God! I was so happy (but not any more after reading this post) on getting free DVDs for SQL Server 2005. :(

# re: SQL Server 2005 :: The First Impression

Thursday, December 29, 2005 2:49 PM by khurram
Ali, if its Beta DVDs, installing that version might affect syntax highlighting of SQL Server 2000's Query Analyzer. However with the release build; I am not facing that issue...

# SQL Server 2005 :: The First Impression

Saturday, December 31, 2005 10:10 AM by Mohamed A. Meligy Weblog
New Comments to this post are disabled