Steve Jones - Editor (6/10/2010)

---

JF, I posted a note to people to see if someone wants to help you out.

As a short note, when you run queries on your laptop,...

Any insight on this? Where should I look for a disk, or RAID specialist, that we could hire for a few days, so he can help us setup our environments?

You have duplicate ID in the table 2, therefore, the left join is showing you every match from table1, that has been found, or not, in table 2. If there...

Hi Roy,

From what I can see, the casting to smallDatetime seems to be the problem. It has an accuracy of 1 minute, therefore, it does round the 57 seconds to...

This has to be the worst advice ever... Can't believe someone actually posted that...

Here's what I'd do:

Run sp_who2, once your command is blocked, so you know what blocks you (Column...

Ouch... that really is something you should do in the front end, it's simple address formatting, don't you have developers that can handle those cases?

If not, well, you could do...

Good, you might want to post the parcel of code if someone else is looking for the same answer?

And we might review some of it, maybe it can be constructive...

Ray K (6/3/2010)

---

I just found sp_executesql in BOL.

I'm going to mess around with this a little. If I get anywhere with it, I'll be sure to post whatever solution...

I really think you should use Dynamic SQL, for handling those special cases. And by the way, you will get a better performance than when using a "Catch All" plan...

No problem man,

I betthe problem is a lot less tough to handle now!

Have a nice one,

It WILL wait, until the first exec is done, to start anything else.

EXEC ('WaitFor Delay ''0:00:02''')

Go

EXEC ('Select 1')

GO

EXEC ('WaitFor Delay ''0:00:02''')

GO

EXEC ('Select 2')

Try this piece of code, you will see...

Why do you do that? An execute statement be it dynamic or not, will "stop" your code, so it executes only 1 thing at a time, no need to implement...

Next thing to check, is if it scales well, depending on your indexes for the table you are using within the function. Can you execute it once, and post the...

Well, I cannot test any of the code I just did, but can you test this, and let me know if you get any improvement?

ALTER FUNCTION [dbo].[GetEventTrackSearchResultsForDateRange]

...

Does it get worse than this?

I think the posts are getting even clearer and clearer everyday...