You didn't answer the question about the clustered index. But assuming that 's not possible (or not desirable), don't just blindly accept index recommendations from the execution plan. ...

All of the columns? Are you sure you need them all in the index? If you do, have you considered making this index the clustered index?

John

Try experimenting in dev with the SORT_IN_TEMPDB option, but be aware of the consequences for the size of tempdb. If you have Enterprise Edition, consider using the ONLINE option....

RonKyle (5/23/2016)

---

I'm with you on all things but the 1433 port. I could easily be convinced, but could someone explain that more or point me to a source that...

Partial solution. Will only work if all elements are four characters long (which they are in your sample data).

SELECT

SUBSTRING(Diagnoses_For_Spell,1,4)

,SUBSTRING(Diagnoses_For_Spell,6,4)

,SUBSTRING(Diagnoses_For_Spell,11,4)

,SUBSTRING(Diagnoses_For_Spell,16,4)

,SUBSTRING(Diagnoses_For_Spell,21,4)

,SUBSTRING(Diagnoses_For_Spell,26,4)

,SUBSTRING(Diagnoses_For_Spell,31,4)

,SUBSTRING(Diagnoses_For_Spell,36,4)

,SUBSTRING(Diagnoses_For_Spell,41,4)

,SUBSTRING(Diagnoses_For_Spell,46,4)

FROM #temptable

John

So you want to choose the first BL Number in your list for each combination of Port and Vessel? But how do you decide which is the first? ...

No, I don't think so - only if you're connected in Object Explorer or a query window. But try it if you're not sure.

John

Yes. Use the Registered Servers window.

John

Use [font="Courier New"]RESTORE HEADERONLY FROM DISK = '...'[/font] to get size information for the backup(s) in your file (a file can contain more than one backup). Use [font="Courier New"]RESTORE...

That'll depend on a number of things, such as the transaction isolation level. But you can find the answer for yourself by putting a few strategically-placed [font="Courier New"]EXEC sp_lock[/font]...

I'm sorry - I'm out of my depth here. I don't know why you're seeing this behaviour.

John

It depends what sp_HostProcess does. For example, if it creates a permanent table (or a global temp table) then you're likely to get an error in one of the...

I don't know anything about AS/400, but when using linked servers you have to use the four-part naming convention, specifying (I think) the server, the catalog, the library and the...

Yes. You have to change MyDatabase for the actual name of the database on the remote server.

John

DELETE FROM DB2400_WRITEPROD.MyDatabase.PALTEMP.CNTUPDR

John