Paul, nice test. I was wondering if that was a hole, and you've shown it.

I still think the best thing is to run the insert, then check for a rowcount...

The SQL Server Error log keeps getting added to as long as SQL Server runs. It restarts when the instance restarts.

sp_cycle_error_log simulates the restart process. Errorlog becomes errorlog.1, errorlog.1 becomes...

It almost sounds like a hardware issue with the new NIC.

You can't name the table and procedure the same thing.

Excellent Job, Bill!

Jamie,

I think we'd still like to know why you're doing things this way, and if you don't trust SQL Server to handle concurrency somehow.

Roy, did that blog help?

Also, where are the errors occurring? First connection, randomly while people are working? Do you get any errors from the local connections like from Agent?

If this is a regular problem, you need to buy more space. It's that simple.

Mapping shared drives will work...sometimes. However it likely will fail when your database fails, and then...

Michael Lysons (5/8/2009)

---

Good grief, sweeping generalisation about developers there, Steve. Seems to me that if a developer is implementing incorrect indexes etc, then it's actually the DBAs fault for...

Blinkering?!?! Blimey, major, Great Scott, you bloody well confused me!

throw him a pork chop, Bob!

I'm not sure what his problem is either. I think he's written a sh**ty application and now wants to overengineer the SQL code to back...

To move just tables in the same db, you need to create a new filegroup on that new drive. Then rebuild the clustered index on that filegroup, and the data...

First, why shrink the log? If you load again tomorrow and it grows, what have you accomplished? Nothing.

Your strategy of backing up the log every hour is sound. You should...

I tend to agree on the restore. It's not a hard thing to do if the db was running in SQL 2005. Worst case, build a DTS/SSIS package into the...

Kurt,

I've tended to agree. I never missed Intellisense in T-SQL, and never wanted it, but I have used it and liked it in VS. I think part of that is...