If it is executed 4 times a minute, maybe you can build XML from the parameters and run the update in one go in a stored procedure?

Try to run this query:

select b.text, a.* from sysprocesses a cross apply sys.dm_exec_sql_text(sql_handle) b

where blocked0

You seem to have a lot of blocking, perhaps there is an uncommited transaction in...

Have you tried to create clustered index on ndate? They are very good at range queries.

Regards

Piotr

Thanks Hugo, I was thinking about something along these lines. Somehow I missed the fact that the table was altered, not recreated. I read once post of Tony Rogerson that...

Problem with scalar functions used this way - where you pass a column as a parameter - is that they are not inlined by the query compiler. This means they...

Hi,

What ANSI_PADDING you have when you script the tables? It is interesting why MaxLen is different than MaxDataLen in your file. LEN according to BOL returns length of data without...

The indexed views have a rather long list of limitations regarding their creation. Please refer to Books On Line, Designing And Implementing Views, these are few first lines:

"

A view must...

Indexed view must not reference other views, only base tables. You will need to expand definition of the first view in the view you want to index.

Piotr

And do you mind if I ask what do you need these messages for?

I came across the 'top 5' requirement. I needed to identify rows that have some values not smaller than 5 biggest values in the table. I guess it's a pretty...

You didn't say anything about technology you use to run these commands, but for .NET, you should look at the InfoMessage event fired by SqlConnection:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.infomessage.aspx

HTH

Piotr

Hi,

In my opinion you have two options - one is linked servers, second is SSIS.

Linked servers can be more problematic I think, regarding version of Oracle and you might run...

True, so first you would have to have the rowset sorted by some other, meaningful criteria. For example if there are three employees with the same manager_id, you could sort...

And what if c3 is not 0? Is the insert statement different then, or the parameter value is different?

As a starting point, this would be one of the ways to...

The sort transform returns the first row if duplicates are found in columns specified by sort criteria. At least it worked this way for us :), but if I were...