Viewing 15 posts - 1,396 through 1,410 (of 7,636 total)
First, get SQL Server Developer Edition, either 2005 or 2008. It has all of the features of Enterprise Edition, but you can get it for $65 or even...
October 18, 2009 at 7:59 pm
Paul White (10/18/2009)
Ah yes, it was SqlBulkCopy I was thinking of: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx
Yep, thats what I used. I could never get it within more than 66% of BCP's speed...
October 18, 2009 at 4:51 pm
Steve Jones - Editor (10/18/2009)
Or maybe they've changed the rules now that Jeff isn't serving :-D:-P:w00t:
BWAA-HAAA!!!! ... ROFLMAO! :laugh:
October 18, 2009 at 4:27 pm
Steve Jones - Editor (10/16/2009)
whoop upside?what's next, shocking keyboards? loud raspberries when someone responds?
Can we get that?!? :w00t:
October 18, 2009 at 4:19 pm
Matt Miller (#4) (10/17/2009)
Jeff Moden (10/17/2009)
Matt Miller (#4) (10/17/2009)
October 17, 2009 at 11:58 pm
jordon.shaw (10/16/2009)
Completely understand; however, with the economy, there is no training money this year!
Is there money for recovering corrupt databases, application downtime and lost data?
I don't mean to impugn your...
October 17, 2009 at 11:47 pm
IMHO this is a completely fair question. We are after all DBA's and Developers, and these little details matter a lot in our profession. 🙂
October 16, 2009 at 5:46 pm
GilaMonster (10/14/2009)
Bob Hovious 24601 (10/14/2009)
Which galaxy?This one. What would be the point of conquering any other?
Practice? 😀
October 15, 2009 at 9:32 pm
They should not be a problem, they accumulate naturally when Service Broker is not in use. See here for more information.
October 15, 2009 at 8:55 pm
We are going to need the datatypes of all of these columns first.
October 15, 2009 at 8:19 pm
Sounds like parameter sniffing. Have you tried using EXEC(@string) instead/
October 15, 2009 at 8:13 pm
Yes, this can be done with the SQL Server 2005 XML data type methods (esp. .Nodes()), and possibly recursive cte's. If you provide us with more details, we can...
October 14, 2009 at 10:43 pm
IIRC, the issue has to do with how ADO (not ADO.Net). ADO uses the rowset count notices as indicators of when the rowset is ready for consumption, as well...
October 14, 2009 at 10:09 pm
Viewing 15 posts - 1,396 through 1,410 (of 7,636 total)