For a non-political, non-apologetic, non-gun/abortion/religion moment... WTF is up with SQL Server? I'm sure there are valid reasons - beyond me - why a shop would like it... clearly it's well integrated with Microsoft tools. But as someone who just needs to manipulate data and build reports, I fucking hate it. HATE it.
- No multiple row inserts - got a bunch of rows of data and wanna insert it in one swipe? Nope. At least not without a supremely ugly hack. Really, wtf. - No insert-or-update - got some data, wanna selectively update existing rows or insert new ones based on a common key? Hah! Another ugly hack. I've read both of these things are finally addressed in SQL Server 2008 - but really, did it take that long for two very useful features that people have been used to on every other sql db for years? Did I mention how painfully limited the SQL Server Mgmt Studio is in some respects? Hey, ever wanted to simply import some tabbed or csv data into a table? Or, for that matter, dump a table to the same? Well, you can copy/paste - which works just dandy when you have hundreds of megs of data. How about something equally common - importing a large file with SQL statements, or dumping a table and its definitions to a text file in a way that can be easily restored? Again, you could try copy/paste into the appropriately named "SQL Pane" - except it chokes beyond a few megs of data. Of course, everything is possible if you care to work in VS.NET or even PowerShell, but that's another layer of shit in between me and my data. Ok, I know this isn't the right forum... but just annoyed this morning, coffee is still brewing, and no one is around the office to hear me bitch yet. _______________________________________________ OSX-Nutters mailing list | [email protected] http://lists.tit-wank.com/mailman/listinfo/osx-nutters List hosted at http://cat5.org/
