Viewing 15 posts - 7,186 through 7,200 (of 7,631 total)
Not a feature as far as I know, the button works on all of my Sql2005 boxes.
The only other thing that I can think of is a permissions issue, either...
[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]
April 9, 2008 at 6:18 am
Jeff Moden (4/7/2008)
rbarryyoung (4/7/2008)
Well, NOT IN has had some bugs in SQL Server 2000, so that is certainly possible. They are mostly cleared up in Sql2005.
What kind of bugs,...
[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]
April 8, 2008 at 11:55 pm
Does the output file exist yet? My recollection is that on 2005 (unlike 2000) the button will be disabled (dimmed) if the file has not been created yet.
[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]
April 8, 2008 at 11:48 pm
Yeah, that's the conclusion that I came to also. I probably will load all the records into XML in the trigger and then cursor them out in an intermediate...
[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]
April 8, 2008 at 11:45 pm
Bob Fazio (4/8/2008)
Steve, does this look familiar?
No, that's an rk07. Rk07's were not see-thru as far as I can recall. Maybe something from the RM or...
[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]
April 8, 2008 at 11:38 pm
You're welcome.
[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]
April 8, 2008 at 11:22 pm
mark (4/8/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]
April 8, 2008 at 10:44 pm
This is the supported way to address it. It is also, by far, the safest, most reliable and fastest way to address it, particularily before Sql2005 (which gives us...
[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]
April 8, 2008 at 10:37 pm
What I have done in the past with similar situations is to right my working queries against a set of local Views with the same names as the tables in...
[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]
April 8, 2008 at 4:40 pm
wavesmash (4/8/2008)
This is what I use, however it would need to be modified to insert into a table if you wanted to select against it.sp_msforeachdb 'use ?;exec sp_spaceused'
cheers,
Andrew
That's how I...
[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]
April 8, 2008 at 4:33 pm
bitbucket (4/8/2008)
Thanks for your unique point of view - it works like a charm ... will be added to my bag of "tricks"
Thanks for the feedback Bit.
[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]
April 8, 2008 at 4:30 pm
cannot see any reason why you couldn't do this same thing with TRY..CATCH blocks.
[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]
April 8, 2008 at 12:33 am
Rajan John (4/7/2008)
rbarryoung - if you dont mind please share when the dependancy tables are getting updated, or the process for that.
The only way that I know of to insure...
[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]
April 7, 2008 at 11:13 pm
Jeff Moden (4/7/2008)
rbarryyoung (4/6/2008)
Jeff Moden (4/6/2008)
Heh... I handed Babbage gears 😉Good one. 🙂
I was serious about my Uncle though, he really did do all of that stuff.
I...
[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]
April 7, 2008 at 6:36 pm
Sergiy (4/6/2008)
Don't remember exactly how many rows were...
[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]
April 7, 2008 at 12:04 am
Viewing 15 posts - 7,186 through 7,200 (of 7,631 total)