I generally prefer several smaller tools that do jobs really well. Take for example type ahead. It's built into SSMS, but it stinks. Get a copy of Red Gate SQL...

So you've got identical execution plans on identical databases on the same server, but one is running slow and the other is not?

Contention is the first thing that comes to...

You've effectively written two different queries, and yeah, each query needs a different execution plan. Recompile is probably your best option.

fminns-1058143 (12/3/2009)

---

Hi Grant

But who/what is using up the other connection?

The reason I want single user mode is because I want to try testing a restore of the master database which...

fminns-1058143 (12/3/2009)

---

I have tried everything.

No matter what I do, and no matter how many other processes I kill off I still always get the same message telling me that only...

I'm with Lynn here, spend $50 on the Developer's edition of SQL Server. If you're trying to invest in your future... $50, please.

Next, I'd recommend reading Brad McGehee's book, "How...

And what happens when database A or B become terribly problematic due to size, contention, number of users, what have, and you need to move them to another server? Linked...

If restarting the service doesn't clear the trace, then you've got something running within SQLAgent or as a startup script that refires it. If SQL Server is shut down, so...

Generally a security policy would be defined as who has access to what information and how do you insure that this is being enforced. So you need to pieces of...

Sounds like named pipes isn't set up. I wouldn't use it personally. TCPIP should be about everything you need.

Kwisatz78 (12/3/2009)

---

Hi Gila

My system is OLTP and uses 4 cores. Currently MAXDOP is set to 0 with threshold...

Depending on the volatility of the system, you could take a look at the output from the default trace. It should be available on the server with the log &...

GilaMonster (12/3/2009)

---

Please post queries, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Why? Is that index...

Um, restarting the server would definately stop the trace unless you put it into a boot script that fires when SQL Server starts up.

Plus, that trace, that's the black box...

I'm probably extremely confused, but wouldn't this do what you're looking for?

SELECT c.categoryID

,SUM(c.categoryID)

FROM @Customers c

...