Viewing 15 posts - 5,791 through 5,805 (of 7,631 total)
Good one. I got everything else right, except that I missed that "GO;" would correctly execute the "GO" sproc (since it usually returns the aforementioned error).
By the way, 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]
August 25, 2008 at 6:50 am
Oops, I got the order of the last 2 fields of the index wrong. Should be:
[ShiftID]
,[TableID]
,[StationID]
,[EmployeeID]
,[CounterDateTimeStamp]
,[CounterTimeSpan]
,[MusselCount]
[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]
August 25, 2008 at 6:38 am
I think that this is a much easier way:
Select Parsename(strg,4)
, Parsename(strg,3)
, Parsename(strg,2)
, Parsename(strg,1)
From (
Select Replace(
Replace('\ Application \ Microsoft Office \ Word \ Error ',' \ ','.')
, '\ ',...
[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]
August 24, 2008 at 11:44 pm
I think that you should do what the error message is telling you:
Contact your primary support provider for more information.
[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]
August 24, 2008 at 10:58 pm
Jeffery, Shouldn't that be:
SELECT [columns]
FROM table
WHERE column LIKE 'user1 %';
?
[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]
August 24, 2008 at 10:39 pm
Try this:
Select [ShiftID]
,[TableID]
,[StationID]
,[EmployeeID]
,[CounterDateTimeStamp]
,[MusselCount]
,[CounterTimeSpan]
,MusselCount - Coalesce( (Select B.MusselCount
From [ShiftCountersRawData] B
Where B.ShiftID = A.ShiftID
And...
[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]
August 24, 2008 at 8:37 pm
You know it brother! 😀
[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]
August 24, 2008 at 7:46 pm
Jeff Moden (8/24/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]
August 24, 2008 at 7:06 pm
Matt Miller (8/24/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]
August 24, 2008 at 2:42 pm
Jeff Moden (8/24/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]
August 24, 2008 at 2:38 pm
skenzie (8/24/2008)
I've been thinking of applying for a job that involves looking after a Management Information System, i.e. mainly showing people how to use it and querying it to provide...
[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]
August 24, 2008 at 2:25 pm
Arman (8/21/2008)
Thanks Gila, Thats what i did earlier and found few queries which were taking most of the CPU. There is a need of indexes on them.
I am curious how...
[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]
August 24, 2008 at 2:02 pm
I agree with Carl, breaking this function apart into a master function with separate subfunctions is your highest return.
You already have almost all of the code, you just need to...
[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]
August 23, 2008 at 9:01 am
amicusoft (8/22/2008)
the statements are the same, only the way i call the statements is different.
....
the function-call takes 16 minutes, the script-call only 30 seconds.
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]
August 22, 2008 at 4:59 pm
Grant: I think that the UDF listing is back on page one...
amicusoft: I seems very likely that the run-time difference here is due to "parameter-sniffing". You have lots of...
[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]
August 22, 2008 at 11:54 am
Viewing 15 posts - 5,791 through 5,805 (of 7,631 total)