SQL Server 2005 sucks so far.
I finally had to take the plunge into SQL Server 2005 since HostMySite only offers 2005 and not 2000 on their VPS plans. Needless to say I’ve heard nothing good about 2005. I’ve talked to countless DBAs telling me that it’s dog slow and EXTREMELY clunky to use. Well I’ve come to the conclusion that they are right.
Mind you I’m just now getting into it, but already I found 2 gotcha.
First off the Script Generator sucks. The interface is so horrible, I feel like I’m programming in Visual Basic with the way you have to choose your options. Not to mention that thing is SLOOOOOOW. It took 3 times as long to generate scripts for my database as Enterprise Manager did. The big kick in the nuts is that it doesn’t write the script correctly! The old 2000 script generator would write the scripts for the tables first and then the scripts for all your views next. Not 2005’s, it intermingled the tables and views scripts so if a view has a table in it that hasn’t been created yet… it FAILS!!! Is that fucking stupid or what!?! The only way around this is to generate and run the scripts for your tables first and then generate and run the scripts for your views. Great, so not only do I have to wait longer, I have to do double the work as well. Thanks Bill!
Second thing I found was another speed issue. I don’t know how many of you have ever used the import / export wizard in Enterprise Manager; I use to use it all the time and it was a life saver. Well needless to say now in 2005 the import / export process takes a loooooooooooooong time…… I’m talking long like the Nile, like line at Domino’s in a fat camp, long like John Holmes! I couldn’t believe something that use to take 30 seconds before took 10 minutes. Thank God I only have to do that once in a while.
My other gripe is the Management Studio in general. Why Microsoft now feels that everything should look like Visual Studio is beyond me. Enterprise Manager (though ugly as hell) was very clean and uncluttered, compare to Management Studio which looks really slick but a total mess when it come to finding things.
I guess I just need sometime to figure everything out. I’m sure I’ll find other quirky things along the way in my journey and if I do I’ll post them.
UPDATE: I was about to rip Angus (see comments below) a new one when it kinda dawned on me that I never checked what service level SQL Server 2005 was on. I guess I just assumed that it would be at the latest level since it’s a VPS and HostMySite applies the upgrades to the VPS. Well let me fall on my sword by saying that I checked late last night and I was wrong. SQL Server was at SP1 not SP2. I tried installing SP2 and it wouldn’t let me, so now I have a ticket opened with HostMySite to see if I can get it updated to SP2. I’ll post something about my new experience with SQL Server 2005 once SP2 is installed.