OK, I just retested this thread with all of my browsers, just to be sure and here is the tally:

Browser version Jeff1(Long) Jeff2(short)

------- ------- ----------- ------------

Chrome 0.2 ...

I have Chrome and Firefox 3(dang forced upgrade!) and it does not work for me in either. Opera still works, I think, but it has a bunch of other...

chileu17 (10/16/2008)

---

Hi everyone I am having a similar problem here, well on my dev server I have 4 cpu, I dunno why I get so much CXPACKET wait time, well...

If you really want to force it to check those first, then you can make a Temp table to hold the results of that join. Populate it first and...

Run "EXEC sp_helpservers" and show us the results.

The big companies and sites have people who specialize in it. Even Microsoft field offices pretty much throw all of that stuff to resellers and software licensing partners because...

Microsoft Licensing is ferociously complicated right now. What I would suggest is trying to talk to someone from Microsoft about it Jack. Or else you could see if...

Maybe I am out of date, but isn't IIS free?

NotManyPoints (10/16/2008)

---

The simple 4 line sp:

CREATE PROCEDURE FindUserDetails(

@WhereClause varchar(2000),

@OrderByClause varchar(50)

)

AS

declare @sql varchar(2000)

set @sql = 'SELECT UserID, CustomerID, FirstName, LastName, EMailAddress, CompanyName, CompanyID, CompanyEmailAddress, CompanyPhone, CompanyLocation

FROM CustomersDetails JOIN

CompanyDetails

ON CompanyID = UserCompanyID'...

Here's the link to Jeff's original post: http://www.sqlservercentral.com/Forums/Topic586399-361-1.aspx#bm586699.

You can see that even though it has the horizontal scroll bar, the width is still messed up.

Well, actually I would need another thread to demonstrate the first one completely, as the second one messes the width up for the whole thread.

OK, I've got part of it figured out anyway>

Here's one of Jeff's recent post's that showed up with scroll bars:

DROP TABLE JBMTest

GO

--===== Create and populate a 1,000,000 row test table.

...

Yeah, I would take that to Microsoft, because it sounds like a bug to me.

Insofar as we are application code's use of SQL, then I agree. However, if we...

Glad I could help!