I would bulk insert all 1000 rows into a staging table. Then do the insert in a single transaction, or roll back if some failure occurs.

If the process dies in...

Probably the way you are doing it now is the best and most efficient considering what result you need.

You could use a common table expression to produce the value then...

There should be no issues as long as all references are via that mapped drive letter.

I'd love to go but there is no way I'd get the paid time off (and hotel/airfare) to attend something like this.

excellent point, Steve I completely forgot about the convenience of using the configuration manager.

some of it depends upon the nature of the application running on it (it is using some CLR code that does external access?). Other than that it should be a...

Matt Miller (#4) (1/23/2012)

---

So developers and DBA's are on the hook for not spitting out solutions they don't understand, but it is imperative to remember that they're the end of...

Amen.

If only these "code jigglers" would be fired, or reassigned to do something less disastrous we wouldn't have so many problems. However all to often these "jigglers" secure...

I have seen way too much of this delimited data in on varchar() column crap. It is typically implemented by a programmer who knows about RBAR processing with VB or...

you can write a small .net wrapper program to execute the procedure and return the output param as an exit code (assuming it is an integer).

Another option is to...

I bet DBAs in general have a unique perspective on this subject. To be really good at what we do we have a broad base of experience from software development...

No but you can create your own backup procedure and use any format you want.

I don't use maintenance plans for my backups, I have dedicated procedures that runs against a...

You can bulk insert into a table with an identity. The identity will maintain the insertion order.

I would suggest doing it something like this:

SELECT *

FROM #TempData A

LEFT JOIN #TempCodes B

ON

A.codes like '%'+CodeRef'+'%'

I'd put any regex directives (ie '%') right in the CodeRef...

doesn't view->object explorer work?