Add appropriate indexes and make sure that the query is written so as to use them. Without seeeing the query (and preferably also the execution plan) it's hard to be...

You're not resetting SQL agent. Those commands you listed...

Jeffrey Irish (8/26/2008)

---

Out databases use a ton of Clustered Indices. It would be really handy to exclude the Indexes in favor of just holding onto the code that creates the...

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic558976-1063-1.aspx

Take the indexes that DTA recommends for one table, find all the queries that affect the table. Run the queries one by one and note how they perform. Apply one...

The amount of stuff on the drive doesn't influence the speed of reading/writing data.

Coming...

In that case it's unlikely that anyone will be able to help you properly.

SQL's probably gone and interpertted that as the 6th day of the 25th month.

No need for separate parameters, just a couple small changes.

ALTER PROCEDURE dbo.usp_Stock_Receipts

...

What parameters are you using?

One problem with using the yyyy/mm/dd format is that it's ambiguous. If I write 2008/04/10 does that mean the 10th of April or the 4th of...

That's saying that there's high IO latency on the E drive. A large number of IOs that were issued hadn't completed 15 seconds later. SQL prefers IOs to take under...

SET STATISTICS IO ON

GO

SET STATISTICS TIME ON

GO

then tun the proc. That will give you IO and time breakdowns for each statement.

G Bryant McClellan (8/26/2008)

---

By 'existing index almost adequate', I am assuming you mean one that may have most but not all the elements in the suggestion and could thus be...

Ok, then try something like this:

ALTER PROCEDURE dbo.usp_Stock_Receipts

@receiptDate datetime,

@originatorName varchar(50)

AS

...

That just means you have an IO...

Take its suggestions as just that. Suggestions. It's less accurate even than the Database Tuning Advisor.

Missing indexes is populated by the query optimiser as it's optimising queries. It will note...