Ok, I'm still a bit vague, but will try.

You want all stockcount entries that don't have matching entries in FunctionStock for a particular date?

What's the join between FunctionStock and StockCount?...

The optimiser will sometimes use a technique called index intersection, where it will seek multiple indexes to satisfy different conditions, then do the equivalent of inner joins on the resultsets...

Mark Chimes (10/15/2007)

---

How do I modify the above SP only take into account those rows in FunctionStock that are greater or equal to StartDate and less than or equal to...

The only upgrade available is from full MCDBA (requiring 228, 229, one server 2003 exam and an elective) to ITP Database Admin. Even with that upgrade, you'll still have to...

Without a table schema and sample data I can't give you exact code. You're probably looking for something like this.

This will get you all the records in A that...

Maxer (10/12/2007)

---

Examples:

1. CustomerID = y

2. OrderID !=x and customerID = y

3. OrderID > x and customerID = y

Example 1 will not use the index because it references OrderID first, and...

TheSQLGuru (10/12/2007)

---

One thing to add for this is that since you are on SQL 2005, consider making Amount an INCLUDE column instead of part of the actual index list of...

Maxer (10/12/2007)

---

I've also heard that if you create an index on (for example): OrderID, CustomerID (say in tblCustomerOrders) that if you query that table you need to make sure...

In my experience it has the most impact when the aggregated columns are also in the index.

Consider a simple table

CREATE TABLE Payments (

PaymentKey INT IDENTITY PRIMARY KEY,

CustomerID int,

InvoiceID int,

PaymentDate...

rerichards (10/11/2007)

---

Thanks Gila. That confirms my first question, when having the ability to Lock Pages in Memory in 64 bit EE, essentially that the OS cannot trim SQL Servers working...

Lock pages prevents the OS from swapping SQL out of memory if there's memory pressure on the box.

When the OS gets short of memory, it will ask all processes, including...

Anton, see the PM I sent you.

Order of columns doesn't really have a meaning in SQL. If you name columns in select/insert (which you should) the order that the columns are speified in the metadata is...

All simple recovery mode does is to automatically truncate the transaction log on a checkpoint. The deletes will still be logged.

If you have any NC indexes, drop them. If you...

I haven't seen orphened transactions on this particular server. One of our other servers gets them often (usually from jdbc connections)

I chatted with a SQL engineer and he suggested that...