Viewing 15 posts - 166 through 180 (of 1,082 total)
I agree with the latter two posts as well.
It also looks like your Error message is being raised from Usp_MessageBoard_InsertReply
However the proc you posted for us is [usp_MessageBoard_InsertMessage].
Please could you...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 6:17 am
The Max lengh for a VARCHAR in 2000 is VARCHAR(8000)
Could you show us the table definition of the Messages table in your proc please
Also is the error in SQL or...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 5:44 am
Could you show us your code PLEASE...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 5:36 am
could you post some code please
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 3:42 am
I'm not 100% that that code is indicating what we thinking.
I tested it on my table:
where RowNum = SomeInt -- 1678
where 1 = 1 -- 5
where RowNum = RowNum --...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 3:23 am
The reason I ask the above and I guess it's related to the OP.
for me with a table of 1mil rows I get very much the same results for the...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 3:00 am
nice one.
I've done some testing with clustered and non-clustered indexes and combinations of both and the results are the same.
I was also thinking this might be a target for a...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 2:54 am
That is very very interesting I must say, I wonder if this happens everytime?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 2:37 am
I totally see what you mean.
But you right we need some advice here, I'll try and get some data together and see if I can work it out from a...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2009 at 2:07 am
This all sounds very very interesting, could you explain a bit more about what you mean by Shortcircut OR ?
I've also noticed that
@Param IN (0,Column2)
produced a different order of the...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 19, 2009 at 9:33 am
I'd be very interested in seeing the execution plans if that is still possible.
I have done some testing on my demo table of a mill rows and the results are...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 19, 2009 at 9:10 am
As Gail mentioned please supply more information
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 19, 2009 at 8:57 am
Ok you need to make some var changes.
You are using a CHar(20) which has a set lenght and SQL is struggling to convert that.
Have you tried changed @e_Ncas to a...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 19, 2009 at 2:34 am
Hi Gail,
When you say that a Clustered index is included in every non-clustered index, what do you mean by this?
Do you have where I could read up about this and...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 15, 2009 at 2:43 am
DECLARE @MyTable TABLE
(Id INT,
Team CHAR(1))
INSERT INTO @MyTable
SELECT 1, 'A' UNION ALL
SELECT 2, 'A' UNION ALL
SELECT 3, 'A' UNION ALL
SELECT 3, 'B'
SELECT
Id,MAX(Team)
FROM @MyTable
GROUP BY Id
Look at how the Group...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 14, 2009 at 10:16 am
Viewing 15 posts - 166 through 180 (of 1,082 total)