Viewing 15 posts - 5,386 through 5,400 (of 7,631 total)
Well, in the absence of any other information I'd suggest you try something like this:
INSERT into Table1(col1,col2,col3)
Select T2.data1, t3.data2, t4.data3
From (Select data1, row_number() Over(order by (1)) as...
[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 4, 2008 at 10:23 pm
What error are you getting?
Make sure that you have the job step's database set correctly.
[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 4, 2008 at 8:56 pm
We cannot see your XML. Try attaching it as a .txt file.
[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 4, 2008 at 8:48 pm
venki_1276 (10/3/2008)
IS there any Possibility to use if on cte
Sure:
IF id=10
BEGIN
with mycte(id,name,status)
as
(
...
[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 4, 2008 at 8:41 pm
Do you have a separate index on every column that you can search on? You ned this at a minimum to get any kind of performance out of 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]
October 4, 2008 at 8:31 pm
I would be happy to check out this SQL code if you could post it in a form that we can use it. If you are having difficulty cutting...
[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 4, 2008 at 7:51 pm
I believe that this is either a SQL Server bug or a corruption of one of the system databases. I would recommend contacting Microsoft.
[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 4, 2008 at 3:17 pm
GilaMonster (10/4/2008)
The clustered index scan of Inv_AeX_AC_Client_Agent, which estimates 1901 rows and gets over 6000. It may be that 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]
October 4, 2008 at 3:01 pm
Where are you getting the estimated time from?
Subtree cost of the root node of the second statment.
The costs aren't times. They're a unit-less measure calculated from estimated time, estimated CPU,...
[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 4, 2008 at 2:18 pm
OK, here is the SHOWPLAN XML Statistics from after a run. Note that this is not from the production system, but rather from my laptop after I copied 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]
October 4, 2008 at 1:26 pm
GilaMonster (10/3/2008)
That looks like the estimated plan. Is there any possibility of seeing the actual plan please?
Probably not from the production environment in the time that I have left (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 3, 2008 at 1:39 pm
Not sure. I am considering parameter sniffing as a possibility for why the query plan for a query is so wrong. I have attached it as a .TXT...
[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 3, 2008 at 12:05 pm
You'll have to give me a clue as to what is wrong with the results from my query if you want me to change it for you.
[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 1, 2008 at 4:54 pm
I agree also. Common code reuse is one of the few things that I support using SQLCLR for.
[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 1, 2008 at 7:38 am
Yes, raid 5 is counter-indicated. Best practice is raid 10.
[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 1, 2008 at 7:30 am
Viewing 15 posts - 5,386 through 5,400 (of 7,631 total)