Asked and (partially) answered here

http://www.sqlservercentral.com/Forums/Topic707203-146-1.aspx

If you don't do any changes at all, mark the databases as readonly and SQL will take no locks when querying it.

There's no other way to make read uncommitted the...

Steve Jones - Editor (4/29/2009)

---

You can't necessarily judge someone by their points, but if they aren't very knowledgeable, likely they'll never get to 1000 posts. They'll get constantly berated or...

What you're seeing is perfectly normal. A login that's a member of the sysadmin group does not automatically get a user created in each database, rather they are 'mapped' to...

You may find this useful

http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/

I think this blog post pretty much says it all.

http://www.sqlskills.com/BLOGS/PAUL/post/Auto-shrink-e28093-turn-it-OFF!.aspx

tosscrosby (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his latest post.

The...

What indexes are there on the STB table?

Integrity check shouldn't grow a DB, it just reads data. Index rebuilds will grow the DB

Are you shrinking the database? Manual or autoshrink?

I usually only worry about fragmentation if it's above about 25-30%.

Take a look at the two article I posted earlier in the thread. They're a series that shows an example of finding and fixing perf problems (though in the case...

Look up sp_rename in Books Online

WayneS (4/28/2009)

---

I'm trying to set up a deadlock event as outlined in BOL. The job gets created. When I run the supplied code, I do end up getting the deadlock....

Schadenfreude-Mei (4/29/2009)

---

As you may recall we have had many chats about this sort of thing in the past and while this is not something i would do in a production...

I think that's a topic for a different thread. If you're interested, there's a good description in Itzik's book Inside SQL Server 2005: T-SQL Querying.