Great question Hugo.

Put me in the camp of answering too quickly. I guess I didn't consider adding a clustered index on another column. DOH!!! I read the section on...

isuckatsql (6/12/2012)

---

I used a Temp Table, but it made the query a lot slower!

I also used the loop joins and nolock because they improved performance.

By combining CTE, loops joins and...

You are welcome. Did you also read the string splitter article? That splitter will blow the doors off just about anything for performance. It should be in everyone's arsenal of...

You need to either a bunch of response.writes with response.end or send error messages to the browser.

Please don't cross post.

Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1315101-150-1.aspx

What error are you getting? You can have IIS7 send error messages to the browser for debugging purposes. Just open the ASP item in IIS and then expand Debugging. You...

Yeah I would think you might get a couple dozen more page loads in a month span. Not even a drop in the bucket for a site with as much...

ChrisM@Work (6/13/2012)

---

Anatoly Ukhvanov (6/13/2012)

---

Thanks, I'll «store it in my mind». 🙂

P. S. Did I choose the correct English idiom? Do American/English people say like this?...

And your response? Again there is no correct answer, except to be honest.

It seems that it would be nearly impossible to have an idea of how many potential readers you don't get because they don't want to register. I know that from...

If I was asked that question in an interview I would hope the person asking is ready for a deluge of questions coming back. There is not much to go...

Here is a simple example...

DECLARE @cmd NVARCHAR(255)

SET @cmd = 'This string has it''s content escape''d so it won''t have an issue.'

SELECT @cmd

Hi and welcome to SSC! The first step to finding your answer is to read the first article linked in my signature.

Also Why are you using inner loop joins? Those loop joins can be a major performance issue unless you are 100% certain (and can explain) why you need that join...

I would also suggest what Gus said but to add to that, your original query is selecting top but there is no order by. This means your max was not...