GilaMonster (10/6/2008)

---

Less on the security and more on the performance, see if you can secure a separate server for dev/test. Letting developers develop on the prod box is asking for...

Thanks for the replies. My manager has made it pretty clear that he wants me to straighten things out (security, backups, performance...), and I think he's let the developers know.

We...

What are the collation settings for all the databases involved ?

Or buy (or create) a tool such as Idera Compliance Manager to monitor SQL activity.

Ideally, you would put a comment in the SP noting the revision #, date, description...

I don't mean to sound like a wise-guy or anything. But why don't people back up their databases ?? How many posts have there been over the...

Patrick Womack (10/3/2008)

---

Is it legal to purchase 1 license for SQL Server 2000 Enterprise and install the software on multiple servers in our company?

The same question for SQL Server 2005...

Also, I think most companies give you a trial period so you can download them and give them a try. That's the best evaluation to see if it suits your...

Idera makes several tools that I was happy with.

Redgate & Quest also make good tools

What about "zones" ?

I should have posted this in the 2000 section, not 2005. D'oh !! :pinch:

That is specifically for TempDB, and often will only show real perf improvements if there is existing blocking on the allocation structures in TempDB. It is good practice to have...

At my last job, I used Idera's SQLSafe backup tool on our 275 Gig database, and our backup time went from 90 minutes to 30 minutes, and disk space for...

GilaMonster (9/29/2008)

---

Replication makes a big difference to logs. On a replicated DB, the log record can't be discarded...

Replication shouldn't make any difference. When was your last FULL backup ?

What's the name of your backup file ??

I was helping someone the other day, and when he created the backup file, he forgot to put .BAK as the extension. When...