Agent shouldn't restart SQL Server. If it is, I'd call MS. Perhaps keep an eye on it to be sure it wasn't coincidence.

There are very few secrets. Is SQL Server doing something that Oracle can't? Hardly.

I heard Jason Fried of 37 Signals speak last week. He talked about how often they blog...

Thanks Keller, I've updated the feed. Not sure it's working, but that's the one I have from Mevio.

Feed broken at times, working on that, or I've been trying to get...

Read the articles by Jeff Moden. He covers some great basics you might want to avoid.

There isn't a good way to do this. You could script grabbing 10% of rows in all tables, but the issue is that you'll have FKs and child rows that...

Is there a unique index on the table?

Haven't seen the error, but I'm amazed it would restart the server. Did the SQL Server instance restart or was it Windows? Or SQLAgent?

I'd probably call Microsoft on this one.

You have a syntax error there with the name of the column. What is the column name of the table?

I think you're kidding, and I hope so. Soft Skills are important. Even in the military, where it's a top-down, no-nonsense, do what I say attitude, soft skills are needed...

Thanks!

1. order in the WHERE clause does not matter.

2. What's the dat? This doesn't make sense in SQL Server.

3. Not sure, might depend on the isolation levels set on the...

Haven't tried it, but this might help you: http://www.sqlservercentral.com/scripts/Miscellaneous/31062/

I'd suggest you do some reading at the SQLCat team's site at: http://sqlcat.com/. They do a lot of work with large installations and you could get some data there.

As far...

You can capture the new database using a DDL trigger or an event notification. If you store that data off in some table, then you can track it. You can...

You could compress them, but you'd need to either Sp_OACREATE to grab an object handle to some zip utility or shell out (xp_cmdshell) to do the command line call.

You might...