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

...

Gail's already focused on the core of the question, you're only going to see two plans in the cache for a given query (assuming the same parameters, yada-yada).

But, you can...

laurav (12/3/2009)

---

Great editorial. I had been trying to make the same argument at a "smaller" company (that I left) - we need safeguards in place. As a DBA,...

What, no video?

Excellent editorial. The link seems to be missing to the T-Mobile story in the UK. Any chance of posting it?

We're working with a tough piece of software. SQL...

thefourthdoctor (12/2/2009)

---

So, if I understand correctly, the general approach for moving from one server to another is:

- build the second box

- backup dbs on the first

- restore on the second

-...

After you move the database you need to be sure that you set the compatibility level to 10. You should also update all the statistics on the database.

The safest way...

Speaking from a pure paranoia standpoint, I'd want to be able to have both servers online at the same time. That way you can leave your existing system in place...

Whatever context SQL Server is running under, it does not have access to that network share. Even if you do, and you're running the command, it doesn't matter, the SQL...

When you insert a row, it has to be placed in the correct place in an index. When you do a batch insert of umpty-x number of rows, they also...