Changed it to a DMV from a table. We generically seem to use "table" for system tables, views, and DMVs, which isn't correct.

The question has been edited to say "batch"...

Buck wants to go back to the MMC, things like the right-click-MyComputer-Manage.

There were plug ins for managing SQL 2K.

I liked Enterprise Manager. Personally I'd like to replace SSMS with a...

Thanks, but even I've had periods where I haven't posted much. Course, I have to keep this baby going, so I don't get too much of a break.

I doubt I'll...

If you have separate domains, I don't think Windows Auth gives you much, and the need to sync passwords, to me, is a problem. Might as well be on the...

Likely he's busy and no time to post. Seems that people go through phases of posting and then stopping because of work.

I'll be out the next three days. Family in...

Dave Schutz (5/18/2010)

---

Sometimes in the midst of trying to solve a problem it is difficult to learn from the situation. One thing I've done is to take notes during the...

Are you a 8 hour a day company? Does business get done all day/night long? Those are good sized dbs, but not huge.

Also, is that data size, or database size?...

Ross Petersen (5/18/2010)

---

Now, I am not writing as a DBA or anything like that, but I have quite a lot of life experience and I am just wondering if because...

It sounds good overall. I don't ever append to files. If the file corrupts, especially with fulls, you're dead. Overwrite all the time, IMHO.

The thing to think about is recovery....

It could be DBAs or developers. There's no definite way to define this, however it should be someone that understands how to do it.

They'll also learn not to do that, or how to shrink it themselves.

Auto shrink causes more problems, performance problems, and isn't worth it. This is one of those cases where...

You need to split the file name into strings. You can use searches to find the slash and the period and get the substring between them.

Some hints:

http://www.sqlservercentral.com/Forums/Topic679052-148-1.aspx

http://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx

Build a resume like you would for any job. Focus on your SQL skills.

Here are some hints. http://www.groovejob.com/resources/resumes/tips.html

I've used Stefan's suggestions before successfully. Batch this into smaller transactions, say 10k at a time and it will probably go quicker.

Have you been testing it on your machine? Maybe the cache is primed and none of it is loaded on the server?

Likely there are a few things different. I'd check...