I'd get two of the Inside SQL Server 2008 books, T-SQL Querying by Itzik Ben-Gan and Internals by Kalen Delaney. The vast majority of what you need to know is...

GilaMonster (10/19/2010)

---

Grant Fritchey (10/19/2010)

---

Just a side note, a Microsoft consultant told me that all I needed to use was the checksums for validation of the backup, but I still prefer...

Brandie Tarvin (10/19/2010)

---

I would just like to let everyone know that I live very green.

My sheets are green, my clothes are green, my food is green, my cats are green......

You can't deny...

This is not something I've tried before. When I tried to replicate what you said happens, with duplicate rows and editing them using SSMS, I got this error:

This is a...

Brandie, EXCELLENT point on testing backups. That is something we do, but I forgot to mention it. It's a must.

Just a side note, a Microsoft consultant told me that all...

If you can't see the tables, it's probably a security issue.

I don't know what the Plesky software is, so I can't help there.

If you can't run performance monitor on the server, but you are still interested in getting some of...

If you just take away their trace permissions on the server, they'll never know. Do they currently use trace? If not, they'll never miss those privs. If so, there's little...

MpriorJ (10/19/2010)

---

Thank you for the help so far, i will try to trace the changes. This will be my first time. 🙂

My idea was to use the application, by entering...

Tossed in a penny. Let's hope it helps.

The name "Maintenance Plan" pretty much defines what you're going to be building. A set of routines for maintaining your database and server. This is not the same thing as...

GilaMonster (10/18/2010)

---

I nearly got side-swiped into a concrete barrier this...

Oh hell, I posted. If he goes off on it or whatever, I'm...

Developers may not want to use stored procedures, I get it, but you should at least use parameterized queries. This avoids T-SQL injection and will lead to plan reuse. This...