Steve Jones - Editor (2/28/2008)

---

It's a question of rethinking the way we do things and trying to be more efficient. Not use less energy, but properly reuse it where we...

With log files that small - of course they have to grow every time "someone is doing something on the DB". Log files record (even if temporarily) what is...

Backups and restores are just one option. Depending on how much activity occurs - it may or may not be what you need. Restoring a 40GB database that...

Using CLR is not much different security-wise than developing T-SQL procedures. Once it's built - the same permissions apply (whether built in T-SQL or CLR).

Your question really comes down...

that's is in a nutshell...assuming that your activity is fairly spread out. Schedule your log backups more often (start at 4 times a day, and go up or down...

DBADave (2/27/2008)

---

On our SQL Servers we only use SAS drives that are 15k.

Does anyone know of any good links that explain the basics of SAN technology? I need to...

Srdjan Svrdlan (2/28/2008)

---

I forgot to mention that tables that are used in the query were not ported from 2000 but created from a DDL script, and all indexes, keys, constraints...

If you're worried about people seeing the data - don't use a pattern. Especially if you're handing that stuff out on "demo CD's". Patterns are altogether easy to...

Paging #77 - some suggestions for you to inspect....:)

As to auto-inserting their user name - look up "security principal" in .NET. Should get you want you want. don't bother the DB for that (do it right...

Jack Corbett (2/28/2008)

---

Matt Miller (2/28/2008)

---

I never really understood the "no gaps thing", which is a wrong-headed control measure. Having to resequence your bills of lading because someone calls and...

Jeff Moden (2/28/2008)

---

Ian Crandell (2/28/2008)

---

Thanks for the info. I have seen you use or refer to the tally table in many of your posts and now that I read...

w.johnson (2/28/2008)

---

We had this exact problem and i've just found out it was me loggin into Quest Spotlight for SQL Server!!!!!!!!!!!!!!!!!!!!!!! I cant believe this software can change the recovery...

This is not a common method - but if you really are doing it just once a day, why not restore from the production backups?

The nice part about...

Ah - but that's not what should be used as a pk/fk. Using a sequence as a clustered key (What Manie seems to be looking to do) is usually...