HowardW (5/5/2011)

---

On the original question, I suspect with most work profiles, you'd get better overall system performance from putting TempDB on physical disk and allocating the RAM you were going...

http://www.ssrstips.com (5/4/2011)

---

I would agree that the overall security structure when you get to many admin tasks is confusing, and it's not well designed from an ergonomic standpoint. It's as flexible...

I might make...

GilaMonster (5/5/2011)

---

Bear in mind...

Usually it's the latter, but opening connections doesn't affect the transaction log. If you have login auditing running, it will enter data in the SQL Server Error log and potentially...

Thanks, I liked this one.

http://www.ssrstips.com (5/4/2011)

---

Forgive me in advance for a bit of a rant but by raising lack of knowledge about SQL Server security and then failing to offer any solution (other than...

If it's for high level administrators, then why not this?

Create procedure MoveDate

@id int

as

insert Final

select *

from temp

where temp.id = @id

There isn't a good way to figure out what's in tables. If I create a C0101 table, SQL Server has no idea what I store in there. You're depending on...

They are. I'm trying to pick items that I think...

DTS isn't really built for this. It would be more like something you would do in a web page or reporting services. To make this work you would have to...

If there is an application, or a specific set of data you are looking to find, here's what I'd suggest. Make note of some values that you want to query...

Craig Farrell (5/3/2011)

---

Side topic, has anyone here looked for employee or resume submittals via SSC? If so, what was your quality of recipients? We're running into a dearth...

4 heap structures. If you read the reference, it states this.

You can mount your production database on the QA server with Red Gate's Virtual Restore (http://www.red-gate.com/products/dba/sql-virtual-restore/). There are also a few other products that can do something similar (one from...