Use the sys.master_files view to get a list of all the files of all the databases known to SQL. It does contain the sizes of the files.

Is that what you're...

Is there anything useful in the SQL Error log?

Do you have a backup from before this started?

Which row?

What I'm looking for is the required output so that if I write a query for you, I can test it and tell if...

Is there any blocking? If you check in sysprocesses while the query of the second table is running, do you see anything listed for LastWaitType? If so, what?

how long does...

Sorry, my mistake. The exec line should have been.

EXEC (@sSQL)

Note the brackets.

The reasons table is dynamic (we add reasons once in a while) and I'm making a summary of this...

What error are you getting?

Shouldn't. It'll slow the insert a little, but unless you have lots and lots of indexes you should...

Based on the sample you gave, what do you want returning?

Could be fragmentation, could be out of date statistics. There are reasons for SQL not to use an index that looks perfect.

Edit: Sounds like it could also be parameter sniffing.

Could...

Please could you post your table definition, sample data (as insert statements) and desired output

see - http://www.sqlservercentral.com/articles/Best+Practices/61537/

You can't use variables within an alter table statement. You're going to need dynamic SQL for this.

DECLARE @Reason nvarchar(10), @sSQL NVARCHAR(500)

DECLARE cr cursor local FAST_FORWARD for

SELECT DISTINCT [Reason]

FROM Reason_T

open cr

fetch...

Ah. In that case, please could you post the schema for the table you have the DB names in, a couple of rows from that table and the result you...

DamienB (7/7/2008)

---

A cursor seems suited to this job from what I've read, but maybe someone can offer a better way? I can see the common suggestion to never use cursors...

In that case, you need to cover that query for the index to be remotely useful. It's not selective enough otherwise.

CREATE NONCLUSTERED INDEX idx_gpsdatahistory1April_RegistrationNoGpsDate

ON gpsdata_history1_April (Registrationno, gps_datetime)

INCLUDE...

Jeff Moden (7/7/2008)

---

I just took a look at the "Developer" requirements from MS... there seems so be a fair number of areas on cursors and optimizing cursors. Does that,...