MSSQL 2005 beta 2 DE first impressions
I admit it is real. First, it took long time to install the thing. I had to uninstall MSSQL 2005 beta 1 EE, then to uninstall .net framework beta 1. Then install .net framework and client tools. And then I had to reboot, the other way it will not continue to install. So on this step I only had the warning of hardware incompatibility. Celeron 466 192 MB RAM handles the whole thing and is still alive. After the installation I had to start SQLSERVER agent manually. Strange. BTW, I did it via SQL computer manager. Also it didn't ask me whether I wish to put the data on the separate partition. I think it's a bug. Microsoft SQL Server Management Studio is the IDE you work with. It has the functionality of Query Analyzer, though it is much heavier plus some of the Enterprise Manager functionality. Though it is not enough, imho. DTS, Profiler, SQL Computer Manager are physically separated. No sample databases. Bye-bye Northwind. So you have to download and install Adventureworks sample database. After installation run the sql script. Something like instadwb.sql. And start to play. Just tested the following:
declare @x int set @x = 15 select top(@x) * from HumanResources.Employee
Saturday, July 31, 2004 8:03 AM
