Don't look at indexed views as panacea to improve performance. If you have a high proportion of write activity to reads, it could make things worse. Instead, consider...

Assuming the server also runs the database engine and that xp_cmdshell is enabled, create a stored procedure that executes the dtexec command, and give him permission to run the stored...

No, there's no limit, but the more jobs you attempt to run at the same time, the more likely you are to experience concurrency issues (blocking and deadlocks) and contention...

I don't think there's any easy way round this. As you've seen, there are quite a few constructs that aren't allowed in indexed views. Consider whether you need...

Hadrian

There's no correlated subquery there, is there? Do you get an error message when you attempt to create the view?

John

Hadrian

Check that the indexes are actually being used, and that they're being maintained properly. Indexes that size are not a problem in themselves. Indeed, you may find performance...

Yes, it does seem a strange requirement. But why would you want to use a loop, anyway?

INSERT INTO MyTable (Empid,empname,D1,D2, D3,...,D30)

VALUES (1,'asd',2,2,1,...,<Val30>)

John

Or this - probably more efficient since it only involves a single scan:

SELECT DISTINCT

ID

,IDDATE

,FIRST_VALUE(FROMID) OVER (PARTITION BY ID, IDDATE ORDER BY JID) AS FROMID

,FIRST_VALUE(TOID) OVER (PARTITION BY ID, IDDATE ORDER...

I think I've seen jobs failing after owner logins have been deleted. But it's easy to test - why don't you try it and let us know how it...

You need to cast @NumRows as a character data type. At the moment, since it's int, it's attempting to add instead of concatenate.

John

Join the Inserted and Deleted virtual tables, and then you can do a comparison between the old and new values.

John

Yes. Windows and any other processes you have on the server - other SQL Server components, for example.

John

Maybe they decided that if they allow users to set such a default, too many people would end up blowing tempdb when they do their index maintenance. I think...

Not as far as I know. It's a property of the create or rebuild operation, not of the index itself. Therefore there wouldn't be a lot of point...

Craig, I know this doesn't answer your question, but if you have any influence over the structure of your database, please do not use this Entity - Attribute - Value...