Viewing 15 posts - 1,591 through 1,605 (of 7,631 total)
Lynn Pettis (9/9/2009)
GilaMonster (9/9/2009)
GilaMonster (9/8/2009)
Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009My money's on the pigeon.
The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon...
[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]
September 9, 2009 at 9:32 am
Adam Machanic (9/9/2009)
Paul White (9/9/2009)
How can I boil the perfect egg?
This one I can actually answer 😀
Put the eggs in the pan with cold, salted water
Bring to a boil
Immediately upon...
[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]
September 9, 2009 at 9:18 am
I think Jack has the thing (Data Conversion Task) that I was trying to remember. You can always do it in scripts also, put that's probably the harder way...
[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]
September 9, 2009 at 9:13 am
GSquared (9/8/2009)
CirquedeSQLeil (9/8/2009)
Now if we only knew...
[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]
September 8, 2009 at 9:37 pm
Paul White (9/7/2009)
TheSQLGuru (9/7/2009)
BTW, are you going to PASS this year? Would love to meet you.This is NOT an on-line dating service :laugh:
??? . It isn't?!? Dag'nabbit, you...
[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]
September 8, 2009 at 9:25 pm
We cannot see the error from here. Could you tell us what it is?
[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]
September 8, 2009 at 12:54 pm
You might want to take a look at this Connect issue: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=473669&wa=wsignin1.0
[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]
September 8, 2009 at 12:52 pm
Are any of your CLR assembles installed with the UNSAFE permission set?
[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]
September 8, 2009 at 8:48 am
I don't know of any Freeware that does this (I actively looked for it about a year ago). A colleague of mine tried to write his own after that...
[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]
September 7, 2009 at 7:22 am
Good analysis and writeup.
And yep, I'd agree, looks like an optimizer bug in SQL Server 2005, though as you imply, it seems to be fixed in 2008.
[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]
September 7, 2009 at 7:01 am
You cannot change datatypes just via mapping. You will need to use a script component or a SQL Transform or component where you can explicitly apply one of the...
[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]
September 7, 2009 at 6:55 am
Here's the link to Grant's latest book, which I can highly recommend: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_3?ie=UTF8&s=books&qid=1252289317&sr=1-3
[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]
September 6, 2009 at 8:14 pm
You do realize that a Rollback will undo your triggers actions also, don't you?
[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]
September 6, 2009 at 5:48 pm
If you can give us the table definitions and some sample data, we can show you how to do this.
[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]
September 6, 2009 at 5:37 pm
Kwisatz78 (9/4/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]
September 6, 2009 at 5:02 pm
Viewing 15 posts - 1,591 through 1,605 (of 7,631 total)