I've been force-fed his chops...

DBADave (1/22/2009)

---

Let's see how you like this one. I just spoke with a technical contact for the vendor regarding various topics and on the subject of enabling AUTO_UPDATE_STATISTICS_ASYNC he...

Bob Hovious (1/22/2009)

---

GilaMonster (1/22/2009)[hrWell, it's not the join keyword and it's an old way of doing things, and the outer join syntax only works in SQL 2000 and earlier, but

from...

GilaMonster (1/22/2009)

---

gyessql (1/22/2009)

---

Is there any difference between joining in these 2 ways?

select ...

from table t1

inner join t2

...

The Upgrade Advisor will catch that, as well...

Me neither. Same things Gail said. Plus, 2005 offers a few things that improve performance, reducing contention, helping to prevent deadlocks.

Oops. There I go again not reading everything before posting.

You can't.

gyessql (1/22/2009)

---

I have a couple of questions in the below query which joins 4 tables:

select t1.*

from table1 t1

inner join table2 t2

...

You also might consider using EXISTS rather than a count. It will work faster

IF EXISTS (SELECT * FROM TabA)

BEGIN

END

ELSE IF...

Plese don't cross-post. This leads to multiple people attempting answer the questions in more than one location.

I have also posted an answer to this question here: http://www.sqlservercentral.com/Forums/Topic641528-149-1.aspx

You really need to get the execution plans to understand where your bottlenecks are. It might be indexes or it might be TSQL or it might be your structure. Remember,...

Built in to Management Studio is a way to view the diagram. Connect to a server. In the Object Explorer pane expand databases, pick a database and expand that. There'll...

You can do an upgrade one of three ways, an inplace upgrade, as you've been discussing, a back up & restore or detach and attach. Any of the three will...

Generally speaking, no, non-clustered indexes aren't going to hurt your clustered index, but...

On another reading through the code, I think I'm going to eat crow and agree. That was a better approach and I'm wrong about it. I should have looked more...