using the following;

;WITH table1(col1) AS (

SELECT objects.[object_id] FROM sys.objects

)

SELECT DISTINCT TOP(2000) Table1.col1,Table2.col1,Table3.col1

FROM table1,table1 TABLE2,table1 table3

ORDER BY table3.col1

-- option(force order)

The above comes back in 151ms

after...

It says you need the trace enabled for hotfix. Not sure about CU4

Using the SQL I posted earlier, I see the "No Join Predicate". I add the option(force...

I have CU4 on all my systems, so I can't test this.

However as I read it, even though you have a valid join, it may interpret it wrong resulting in...

sntiwary (3/5/2008)

---

I have a query which is running slower in SQL 2005 SP2, syntax as mentioned below.

SELECT DISTINCT TOP 200 Table1.col1,Table2.col1,Table3.col1 FROM Table1(NOLOCK), Table1(NOLOCK), Table1(NOLOCK) WHERE and order...

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en">

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Then from the performance dashboard, you can drill down to what you want.

It makes the DM views much more accessible.

Depends on the market that you are in. Obviously things are tighter now than they have been in the past, so I wouldn't suggest making a jump at the...

Wow was that a lot to read. I haven't been active for a while, but it's been a while since we heard from the OP.

I'll respond to a couple...

Jeff Moden (3/6/2008)

---

CRUD... for some reason, this thread will no longer allow me to add a reply... in fact, it keeps overwritting THIS message when I try and the previous...

-- There is obviously a TZ issue here. This was posted after the next 2... Sorry if it gets confusing.

On the contrary - when dealing with large data sets,...

The more I look at this, there is almost nothing that you are going to be able to do to help this query. The only suggestion I have for...

Have you looked at the explain plan, statistics, Memory usage, etc.

Actually have you looked at the performance of the machine? This isn't the most complex query I have ever...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Obvious you still didn't read that. Not only are we trying to help you, but also to help others.

I do appreciate letting us know that it worked, but it...

However, this will NOT change references in stored procedures, triggers and functions that reference the old schema.

Understand this was by design. The whole idea behind schemas was to eliminate...

You can't rename the schema as far as I know, but if you have 2 schemas you can move objects from one to the other.

Assuming two schemas testing and testing2

CREATE...

smitavarma (2/22/2008)

---

update T1

set C1=CASE WHEN exists(select saleid

from T1

...