Each index (not heap) has a "natural order" ie the order in which it was defined, but you just don't get a guarantee that the results will be returned in...

I think you get a log message whenever a cache is flushed, along the lines of :

SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore...

Gail was referring to resource governor ... new in 2008. It lets you assign connections to different workloads, then place those workloads into groups which can be assigned min...

I didn't see it mentioned above, you might want to check sys.dm_os_waiting_tasks for the spid running the query and see what it is waiting on.

Depending on how complex the query is, you might look at adding/modifying indexes or changing the query to generate a different plan. Without seeing the existing query or plan...

Use SSMS, select the ABCCom database on X and right click, tasks, restore database. Choose the backup file you want and go to the options tab. Select "overwrite...

As for your other question - having namekey in the first position is correct, but then other factors come into play. The optimiser knows that the index is a...

Using the phone book analogy, you are searching for people with a first name of 'Bob' but the book is listed by last name then first name - you have...

Because the index doesn't cover the entire query, it is faster to scan the clustered index to get the information. Add mydate as the first column and it will...

Your index is on mydate, col1, col2, col3 - in that order?

GilaMonster (4/24/2008)

---

The advice about making an indexes first column the most selective is often mentioned. I tend to disagreee with it. The index columns should be arranged so that the...

You should put the most selective column first ie the column with the greater number of distinct values.

The index would be ordered by the first column then second column so...

I would bet on one of two things:

a) the stats are old, or inaccurate for the date range

b) it's more efficient to just use a scan - the selectivity of...

It depends on whether the user is the owner, or is in the db_owner group. From BOL:

If the database being restored does not exist, the user must have CREATE...

I would think that you can easily put together a job that queries sys.dm_exec_sessions and sys.dm_exec_requests to find any tasks run by a subset of users that are using excessive...