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...

Everything is in a schema. Likely it was in the dbo schema, so change it back to that one.

If you are just looking for the instance, and not the server, you can have the service send a message when it's down. Otherwise you need another server running software,...

The explanation above is essentially correct. You can have users without logins as orphans after a restore, but essentially the login gets you access to the server, the user to...

bkubicek (5/17/2010)

---

Steve, a EULA is not going to keep your common DBA from opening up a stored proc and messing with it. If there are having problems most likely...

Fair enough, perhaps you can do something worth protecting in SQL Server. I'm not sold, but I'll stipulate I could be wrong.

In terms of a fence, perhaps there is some...