Is there an error logging switch? Some loaders can throw the bad records elsewhere.

Otherwise you need to look at the error and then try to figure out which row(s) it...

Change the script, figure out which process is doing what you need and don't kill that one.

The bcp/truncate works well if you can. I typically delete large sets of data in batches, 10k rows or so at a time. Seems to work faster.

You always want free...

What is "gets done"? Do you mean updated?

This is what you want. We don't want to have to update all instances with patches. You apply the patch twice.

SQL Server doesn't automatically delete the files, someone had to move them or delete them. I'd investigate moves. Search for them on the drives, a shaky mouse hand could have...

The groups will cause the user to be validated against AD with the trusted connection. This is what you're after, though it might seem a bit funny. When the user...

The design is fine for storing the data, but having those LIKE queries will slow you down and guarantee that the server works hard on every query.

You want to query...

Perhaps a silly question, but have you rebooted? i've seen that clear up some bad query plans.

Do you have any reference execution plans to examine the slow queries and see...

We tried this at one point and almost no one commented. Once they hit another site, they tend to comment there.

I think comments are best left on that site, with...

Good point, and it might be something we ask Instant Forums (the maker of the software) to include it. I can see value in the OP.

Popping a new window doesn't...

The backup name shouldn't matter, it's the data in there. You need the logical names to "move" the files, but you should just restore this file as a database name...

You've got incorrect pathing, and the error is you're creating a folder that exists. There isn't error checking here on this, as the maintenance plans are very basic.

You don't want...

If you have the required horsepower, and I don't think it changed much for Express, I'd go with 2008. No reason to go with 2005, which will be out of...

I'd recommend Itziks' books. If they get too complicated, move to the next section, but he does a great job going over things.

I think source control is good, but if you have a lot of developers, it can be rather cumbercome and confusing. What I'd do is once they think they have...