Yes, and check that there are no index hints in any of your code for any of the indexes you propose to drop.

John

Please will you check your INSERT statement? You're trying to insert two columns into a single-column table.

John

Something like this:

ISNUMERIC (Left (DESIGN_NO,1)) = 0 ? DESIGN_NO : ( ISNUMERIC (Left (DESIGN_NO,5)) = 1 ? Left (DESIGN_NO,5) : Left (DESIGN_NO,4) )

The syntax may not be 100% correct, but...

Create a table and insert the date value into it. Add an Execute SQL task to your package that interrogates the table for the date. Store the date...

I imagine so, yes, but I'm not sure. You should be able to open up the package and script out what it's going to do.

John

The ALTER INDEX statement that was the deadlock victim will roll back. What happens after that depends on the severity of the error and how your code handles it.

John

Since SSIS isn't designed to run interactively, I would recommend running this as a report in SSRS, so that users can pass in the required date as a parameter. ...

Without seeing your data, I'd be just guessing. But I think you need a splitter function. Search for that and see whether you find anything that helps.

John

Mark

It's not just performance - if columns are added to or removed from a table then your application may break.

But with regard to performance itself, get a copy of your...

GO isn't a T-SQL command - it's a batch separator. It's recognised by SSMS but not by many other providers. When you use EXEC('...'), you're not running your...

Right-click on the table in SSMS and go to the storage tab. You'll see the size of the table and the number of rows: from that you can calculate...

Have a look at this. Make sure you do this on a test server.

John

Yes, as you acknowledge, you never quite know what you're getting when you use the GUI, which is a good reason to shy away from it in many circumstances. ...

OK, so for the operation to be allowed, you need City to be other than Sandnes, or you need P_ID to be other than 0. So just change the...

I think he's confused his requirement: he mentions "already inserted rows" and "already inserted columns" almost in the same breath. I think Gianluca's solution will work for him; alternatively...