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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 18, 2009 at 4:19 pm
Matt Miller (#4) (10/17/2009)
Jeff Moden (10/17/2009)
Matt Miller (#4) (10/17/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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? 😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 15, 2009 at 8:55 pm
We are going to need the datatypes of all of these columns first.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 15, 2009 at 8:19 pm
Sounds like parameter sniffing. Have you tried using EXEC(@string) instead/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 15, 2009 at 8:13 pm
Heh. Glad we could help. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 15, 2009 at 7:40 pm
OOOOHhhhhh!!! Dang! Ya got me! :laugh:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 15, 2009 at 7:10 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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 14, 2009 at 10:09 pm
Viewing 15 posts - 1,396 through 1,410 (of 7,636 total)