From http://msdn.microsoft.com/en-us/magazine/cc135978.aspx:

Identifying the Most Costly Indexes

-- Create required table structure only.

-- Note: this SQL must be the same as in the Database loop given in the following step.

SELECT TOP...

charles.gary (9/17/2008)

---

Isnt this an incorrect filter?

where d.database_id = d.database_id and d.object_id = d.object_id

Also you can get more info on this from

http://msdn.microsoft.com/en-us/library/ms345405(SQL.90).aspx

This article will show you...

jsheldon (9/16/2008)

---

We have a SQL server that has a hodgepodge of applications. One of the biggest application is SharePoint and as we continue to use our SharePoint server we...

See this great link on the same topic:

Uncover Hidden Data to Optimize Application Performance:

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

Gail already mentioned some of the caveats of the missing-index DMVs.

Here are a couple more:

(1) Because the data in the DMVs are kept in memory, they are at risk of...

Jeff Moden (9/14/2008)

---

Depends on what type of DBA you have (see previous post). And, again, it doesn't matter if you limit the people on the Dev box or not...

rian67 (9/12/2008)

---

I understand being a gate keeper is a tough job. But no one has still being able to answer my main question?

Who handles the creation of Integration Packages, Replication...

I'm looking into automating this, so using the xp is the way to...

Adam Bean (9/11/2008)

---

You can right click SQL Server Logs and go to configure.

But here is the command:

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, X

Where X is the amount of error logs...

GilaMonster (9/11/2008)

---

It's not stored anywhere in SQL. It's in the registry.

I can't remember offhand where, easiest way to find where is to run profiler and filter the trace based on...

I've been able to convince myself your query is right, based on test samples I've run.

However, my...

Is that what the original query with...

Jeff Moden (9/7/2008)

---

Can't tell from your last post if your serious or not so I'll assume you're serious. 🙂

It's a clever bit of code that Peso wrote....

If you want to enable...

Are there other SQL instances, other SQL services (SSIS, SSAS, SSRS etc) running on this machine?

Are other applications, beside SQL server, running on the machine?