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...

File sharing sites like the one I removed are copyright...

Glad it went over well. This one was hard to write without trying to trick people. I wanted it to make you think, but be solvable without misleading anyone.

And we'll always have those errors. Cables pulled out of servers, something dropped, something spilled.

You haven't necessarily defined a problem that well so far and there have been some questions asked that you haven't answered.

I would look at Target Server Memory for all instances...

RTO applies to the system, and it could be defined in various ways. However #4 doesn't say all clients or every client. An outage could easily be unevenly distributed. A...

Craig Farrell (5/4/2011)

---

Hm, I see where you're going in that case. I'll have to rethink a few things, thank you. The idea of production data on a workstation...