Viewing 15 posts - 916 through 930 (of 7,631 total)
Here is one of several of my Blog posts that talks about this: http://www.movingsql.com/dnn/Default.aspx?tabid=125&EntryID=190. In fact if you go my Blog site and click on the "Dynamic SQL" topic...
[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]
February 19, 2010 at 11:38 pm
Heh. I did do a presentation on it. And I posted the presentation kit, including SQL code examples and Client code at my blog, here:http://movingsql.com/dnn/LinkClick.aspx?fileticket=pa1HXFdJ5Bs%3d&tabid=125&mid=911 But, 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]
February 19, 2010 at 11:11 pm
ziangij (2/19/2010)
i just checked it out.. without indexes, update query takes 30 sec.
with the indexes in places, it takes 2 min !
RBarryYoung (2/17/2010)
[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]
February 19, 2010 at 10:51 pm
See, these are ALL much better answers than trying to change a system procedure. Here's another "insane" one: Write you own SSMS Add-in that modifies it's behavior to call...
[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]
February 19, 2010 at 10:46 pm
Though it does seem to me that what this is really supposed to do is to just drop the NULL-valued clauses completely from the dynamic sql, rather than executing them,...
[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]
February 19, 2010 at 10:34 pm
Kevin Rathgeber (2/18/2010)
One of the standards out there in application development is to use stored procedures for allowing the users to insert, update, delete or select data from a table....
[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]
February 18, 2010 at 2:49 pm
Leon Orlov-255445 (2/18/2010)
Yes, you shouldn't mod sys procs... but remember "insane reason" to do so.
Um, no. You should remember "Newbie", "dangerous" and "unnecessary". I would no more tell...
[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]
February 18, 2010 at 2:40 pm
Kevin Rathgeber (2/18/2010)
RBarryYoung (2/18/2010)
Kevin Rathgeber (2/18/2010)
RBarryYoung (2/18/2010)
Kevin Rathgeber (2/18/2010)
RBarryYoung (2/18/2010)
[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]
February 18, 2010 at 2:25 pm
These last few lines of your dynamic query:
...
And (tEx.BoatID = 0 Or 0 Is Null)
And (tEx.EventID = 0 Or 0 Is Null)
And (tPh.Weight >= Or Is Null)
And (tPh.Weight...
[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]
February 18, 2010 at 1:49 pm
Kevin Rathgeber (2/18/2010)
RBarryYoung (2/18/2010)
Kevin Rathgeber (2/18/2010)
RBarryYoung (2/18/2010)
[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]
February 18, 2010 at 10:58 am
Andy DBA (2/18/2010)
RBarryYoung (2/18/2010)
...Cursors are much, much more undesirable than Dynamic SQL, and should be avoided at all costs.
All costs? Sounds like trolling, to me.
I'm trolling? Heh,...
[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]
February 18, 2010 at 10:53 am
Glad I could help! Note also that I have changed the wording of my reply slightly.
[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]
February 18, 2010 at 10:45 am
Add a line like "PRINT @strSQL", right before the "Exec (@strSQL)" line. Then run the procedure again and post the PRINT output for 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]
February 18, 2010 at 10:43 am
Kevin Rathgeber (2/18/2010)
RBarryYoung (2/18/2010)
[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]
February 18, 2010 at 10:01 am
I would also guess that this is a "cut and paste" matter, from a query where tblExperience had the alias "tEx".
[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]
February 18, 2010 at 9:59 am
Viewing 15 posts - 916 through 930 (of 7,631 total)