FYI: sql server 2005

[jkm, the stolen pifwafwi]

is the suck

my god have they butchered it...

[NormanPride]

That's what you get for using something crappy.

What have they done, specifically?

[jkm, the stolen pifwafwi]

i guess i should clarify, its more the new "management studio" that sucks. the database is still decent. whoever had the ingenious idea to take out dts, needs to be dragged around the farm and thrown in a creek.

[jkm, the stolen pifwafwi]

and for the DNN crowd, who writes stored procedures that won't work in a binary sorted database? hello? optimization?

[mdklatt]

PostgreSQL

YWIA.

[jkm, the stolen pifwafwi]

i don't know what the heck they are thinking with this release. you only have the ability to run sql or import/export data. if you choose import/export, they don't give you an option to not drop the table and just append the data. here is the kicker, they have a flag that says "optimize for many tables" which translates to when we drop and then create the tables again, we are going to create them without identities, PKs or indexes. gee thanks.

you can import the packages into VS 2005 but they don't give you the ability to see the code. my irritation at seeing objects is about to hit the boiling point.

[JohnnyMack]

http://www.souptree.net/blog/images/rabbit_pancake.gif

[HoserSooner]

Makes me glad we are sticking with 2000.

[BeetDigger]

This thread should have said: Database nerds only. :D

[mdklatt]

This thread should have said: Database nerds only. :D

I thought the "sql server 2005" bit covered that.

[jkm, the stolen pifwafwi]

don't get me started on the concept of "partial class"

[RacerX]

Like school in the summertime....

[BeetDigger]

I thought the "sql server 2005" bit covered that.


I actually had hopes that the title of this thread was misleading. Unfortunately, ....

[Stoop Dawg]

whoever had the ingenious idea to take out dts, needs to be dragged around the farm and thrown in a creek.

SSIS is *supposed* to better. Though I haven't looked into it yet.

I assume bcp and BULK INSERT are still available?

[Stoop Dawg]

don't get me started on the concept of "partial class"

Given the incredibly poor job that the IDE did of updating code, I like the idea that they put auto-gen'ed code in a seperate place. However, having peices of your class scattered all over tarnation is, uh, concerning.