I'm not saying that you should necessarily use something else. I'm saying that it's possible for index usage stats to be cleared between the last time the database was...

There are certain events that cause index usage stats to be reset, and it looks as if taking a database offline is one of them. If you want to...

OK, so you don't need 6000 columns. Your table will look a bit like this:

CREATE TABLE StockData (

CheckDate date NOT NULL,

StockCode int NOT NULL,

StockHigh decimal(9,2) NOT NULL

StockLow decimal(9,2) NOT...

Does each stock type have the same 30 attributes (columns)? Please will you give some examples?

John

Some default traces last longer than others. If your applications are well designed and don't constantly perform DDL operations, then you've a fighting chance of having a few days'...

You can try the default trace. It's usually stored in the same folder as your errorlog and SQL Server Agent log files. You can open the file with...

Yes, that was my question, as yet unanswered. Also, it may help to investigate this part of the error message: "Multiple-step OLE DB operation generated errors".

John

Your test data script doesn't work. But anyway, have you tried the NTILE function?

John

What is the query in your jobstep that is causing the error? What do you get if you run this query?

SELECT name, product, provider, data_source, location, provider_string, catalog

FROM sys.servers

John

Selectivity of the columns that make up the index key, not of the table itself. So if your index key only has a small number of distinct values, it's...

Oh, I see. I'm afraid there's no way of doing that, as far as I know.

John

Then I'm afraid there's no easy answer. You're going to need to go through that column and clean it up. Once you've done that, change the data type...

You want running a report to cause a job to stop? Not something I'd recommend, but if you want to do it, just put an sp_stop_job command at the...

What do you want to do if the result is Cancelled - show Succeeded, or show the most recent non-Cancelled outcome?

John

If you only need the time portion for ordering, you should be OK just converting to int:

ROW_NUMBER() OVER (PARTITION BY DIA.reference ORDER BY dia.entry_date,CAST(dia.entry_time AS int))

Of course, it all depends...