Viewing 15 posts - 436 through 450 (of 1,082 total)
what happens when you run a select * from SSMS? (are there still no rows)
If this is only happening from the .NET side have you tried running a trace to...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 8, 2009 at 9:53 am
I agree with the others.
Have some more questions.
What are the actual speeds that are showing across the line? perhaps there is conjetion.
Also is this the only query where you have...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 8, 2009 at 9:23 am
I guess we gonna have to ask for the execution plan.
I did notice that you don't have a covering index for OrgId, OrgName
but lets see what the plan says...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 8, 2009 at 8:35 am
is a query in access? or is it a dynamic string run via ADO?
Also what are the connection speeds between your access app and the SQL server?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 8, 2009 at 8:15 am
HI Gail,
Thanks again,
I have just created a few tables and played around with different data selectivity and with the columns being returned. I tried to work out before running the...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 7, 2009 at 9:02 am
Hi Gail,
After the first seek is done are the other filters done on the index or resultant dataset return from the first filter(Index seek)
Also I guess I need to ask,...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 7, 2009 at 8:46 am
what are the statistics on those indexes?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 7, 2009 at 8:32 am
Also could you post the queries that you expect are giving diff results.
With samples of how the results are different. 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 7, 2009 at 7:45 am
Also here is another way to do what you doing:
DECLARE @strSKU VARCHAR(20)
SET @strSKU =...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 7, 2009 at 7:38 am
mmm
I wish I could lie to you , but yes it is possible, but as most people here will tell you, you should avoid using cursor and definitely avoid nested...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 7, 2009 at 5:38 am
Welcome to SQL servercentral 🙂
Please click on the link in my sig for help on how to post to get the best results.
could you give us some sample data and...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 6, 2009 at 4:54 am
you would call it the same way you would if it was outside of a stored procedure.
What kind of function is it.
If you show us the function we can show...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 6, 2009 at 4:29 am
The concept of Merge Join IS also used in SQL Server.
Here is a link to BOL
http://msdn.microsoft.com/en-us/library/ms141775.aspx
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 6, 2009 at 2:45 am
I guess it just depends how he wants his output?
Does he want a value of length 16 or is the max length 16?!?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 2, 2009 at 9:28 am
could you give us some examples please.
What would you expect to be returned from the following
12345678 = 0000000012345678?
123 = 00000000123 or 0000000000000123
0 = 000000000 or 0 or 0000000000000000
etc...
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
January 2, 2009 at 9:16 am
Viewing 15 posts - 436 through 450 (of 1,082 total)