Viewing 15 posts - 2,176 through 2,190 (of 7,631 total)
David Webb (6/8/2009)
If you have a lot of customers, the management overhead of the design you are proposing...
[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]
June 8, 2009 at 5:33 pm
Reddy B (6/8/2009)
My question is, Is it a...
[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]
June 8, 2009 at 5:20 pm
Hmm, took a look at Access, I forgot that they went to these fixed-character input masks back on the 90's, so I think that I was wrong before. 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]
June 8, 2009 at 4:56 pm
Oh yeah, what's the mask that you are using?
[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]
June 8, 2009 at 4:32 pm
I haven't done an Access form in years, but there should be a way to tell it to left-justify, even with the mask. Or, might be collapsible mask characters,...
[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]
June 8, 2009 at 4:31 pm
OK, this is a little bit hard to test with out your table. Try this:
'INSERT INTO LOG_TABLE (TABLE_NAME,Activity, YourXMLcolumn) SELECT ''' + @TABLE_NAME + ''', ''DELETE'''
+ ', ...
[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]
June 8, 2009 at 2:41 pm
GilaMonster (6/8/2009)
RBarryYoung (6/8/2009)
EdVassie (6/8/2009)
If you are asked 'Is anyone in the office wearing a red shirt' what do you do?
Well the first thing that *I* do when asked this 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]
June 8, 2009 at 2:21 pm
Hmm, probably needs this extra comma:
'INSERT INTO LOG_TABLE (TABLE_NAME,Activity) SELECT ''' + @TABLE_NAME + ''', ''DELETE'''
+ ', (SELECT * FROM deleted FOR XML PATH, TYPE)'
-- ^
[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]
June 8, 2009 at 2:19 pm
karthikeyan (6/8/2009)
1) What is mean by pseudo cursor?
Pusedocursor is a name that some people (including me) use for the SQL Server (and Sybase too, I believe) trick of being able...
[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]
June 8, 2009 at 2:13 pm
Florian Reischl (6/8/2009)
RBarryYoung (6/8/2009)
Florian Reischl (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?Deja Vu (on a German forum...?!?)
Huh. Something must be wrong with...
[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]
June 8, 2009 at 1:39 pm
GilaMonster (6/8/2009)
Tom Brown (6/8/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]
June 8, 2009 at 1:30 pm
GilaMonster (6/8/2009)
Lynn Pettis (6/8/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]
June 8, 2009 at 11:43 am
Florian Reischl (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?Deja Vu (on a German forum...?!?)
Huh. Something must be wrong with my fonts, everything...
[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]
June 8, 2009 at 11:39 am
EdVassie (6/8/2009)
If you are asked 'Is anyone in the office wearing a red shirt' what do you do?
Well the first thing that *I* do when asked this is to make...
[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]
June 8, 2009 at 11:07 am
This also may have been parameter sniffing. I believe that inline-TVF's are treated as table expressions (like Views and CTEs) and thus would not be susceptible to parameter-sniffing.
[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]
June 8, 2009 at 11:00 am
Viewing 15 posts - 2,176 through 2,190 (of 7,631 total)