Viewing 15 posts - 1,441 through 1,455 (of 7,636 total)
The problem is that the SQL Server maintained Dependency information in SQL Server 2000 and 2005 is not itself dependable.
[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 7, 2009 at 6:53 pm
Lynn Pettis (10/7/2009)
Roy Ernest (10/7/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 7, 2009 at 5:19 pm
A Quick & Dirty way around this problem is to include the "IF NOT EXISTS" test in the CREATE VIEWs script and then when you execute it in the target...
[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 7, 2009 at 4:52 pm
Paul White (10/6/2009)
RBarryYoung (10/6/2009)
RBarryYoung (10/6/2009)
Paul White (10/6/2009)
4. How many questions on the homework paper?:laugh:
*ding* *ding*, Looks like you cynicism tank is almost full Paul. ...
[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 6, 2009 at 9:27 pm
Moved here from another thread:
RBarryYoung (10/6/2009)
Paul White (10/6/2009)
4. How many questions on the homework paper?:laugh:
*ding* *ding*, Looks like you cynicism tank is almost full Paul. 🙂
Ah yes, it's...
[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 6, 2009 at 5:08 pm
Note: I am moving this to the Thread...
[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 6, 2009 at 5:02 pm
Lynn Pettis (10/5/2009)
RBarryYoung (10/5/2009)
Now all I need to do is to keep this up for three years... And for at least four...
[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 6, 2009 at 4:56 pm
Paul White (10/6/2009)
4. How many questions on the homework paper?:laugh:
*ding* *ding*, Looks like you cynicism tank is almost full Paul. 🙂
Ah yes, it's been six months, hasn't it?...
[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 6, 2009 at 4:39 pm
Another thing to consider is that Interactive/OLTP sessions are not usually the principal beneficiaries of parallelism: there's not much to be gained by parallelizing requests that should execute in say...
[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 6, 2009 at 4:09 pm
Hmm, you might get better results from an Indexed View.
[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 5, 2009 at 9:57 pm
Steve Jones - Editor (10/5/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 5, 2009 at 9:03 pm
Woo-hoo! Back in 6th place. 🙂
Now all I need to do is to keep this up for three years... And for at least four people to die......
[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 5, 2009 at 8:53 pm
You'll probably get a better response if you use the [ code ] tags and try to format things a little:
benjones62 (10/5/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 5, 2009 at 8:43 pm
Huh, cool. I learned something new too. 🙂
[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 5, 2009 at 6:36 pm
Lynn Pettis (10/5/2009)
Jack Corbett (10/5/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 5, 2009 at 6:21 pm
Viewing 15 posts - 1,441 through 1,455 (of 7,636 total)