I'd recommend you just download it again. I've pulled it from Codeplex twice and had no issues, although I did have to get iFTS and Filestream working.

Or use SET IDENTITY_INSERT ON

In either case, you can't use select *, you need to specify columns at least in the INSERT part of the statement.

I think PostgreSQL is a more mature product. But mySQL proves that it can handle loads. The thing is you need the talent that Yahoo and others have, and most...

Check the properties for the database and see if your files are restricted in size or set to autogrow.

Check the recovery model in the same place (is it full or...

Yep, this is code, no need to open each table. You wouldn't do that anyway, the GUI just makes it seem you would.

I'd honestly just use SQLCMD, run them all...

Correct, use admin to install, create a "normal" user with no rights. I'd leave it at everyone in the AD group membership. Then the installation program will assign rights.

I'd recommend...

I'd run this with recompile as well and see if it's sniffing something.

The execution plan, as Jack mentioned, is where I'd start looking for answers.

I'd agree with Andy and Simon_L, help or ignore them, don't bash them.

And Andy has stars under his name!?!?!?! Might need to do something about that;)

But not necessarily a bad excuse. I'd agree with Jeff you want to avoid cursors and almost always can. However they are a tool that can work in places.

Still tracking for < Dec 31.

It's hard to get you something to do because there isn't enough information here. The low cahce hit ratio makes me wonder if your data is significantly diverse that you...

We like to think we have a good signal/noise ratio here and most people are professional, but I definitely need to clean things up on a regular basis.

I try to...

There are wizards in SSMS for importing and exporting data. They create basic SSIS packages, which might help you.

The PK is the unique identifier for a row. Your data will tell you this one. It can be clustered or non-clustered, depending on how you query, though I lean...

Would I quit my job over backups? Probably not, but I'd want someone to put it in writing that I was absolved of issues because of this. And I might...