All the more reason to wall them off. Almost no real way to keep them from doing really bad stuff, but at least it will be isolated from the other...

Hey Steve! Where did you get pictures of my cousin?

DBA-640728 (4/27/2015)

---

thank you Grant for your reply. this is a 2 Tb db, this table in question is 15 Gbs. I will try your second approach.

"Drop...

I reject your test as completely invalid and a waste of my time and superior intellect along with my ability to craft nonsensical run-on sentences for no purpose other than...

Pretty common request, but usually you don't need live data. Run a restore once a day.

By the way, be very, very cautious around giving full access to production data for...

If you really need to manage stuff by domain name, I'd suggest adding a column to the table. Either load the domain from the email address, or make it a...

Give them a new schema that they can have full control over, but just let them have read access to the DBO schema.

Be extremely cautious using repair_allow_data_loss. There is zero guarantee that it will fix the problem by dropping one or two pages worth of data. It can, in some cases, nuke...

SequelDBA (4/27/2015)

---

I have a SQL 2014 Express instance that a developer installed. Currently, we do not "officially" support SQL 2014. I want to move the 2014 database to a 2012...

It's a memory error. It could be pretty benign, just a momentary read/write error in memory that's not going to repeat. It could also be corrupt pages in one of...

If the transaction log is growing a lot, two things. One, take more frequent log backups. That will free up the committed transactions more often. Two, maybe you just need...

I'd go with the latest service pack, yes.

I'm not sure this will address any performance issues you're hitting. This may or may not be related. I would capture wait statistics,...

You need to look to what the execution plan is telling you for how it's going to resolve this query. Your indexes are not being used or the statistics are...

Here's the documentation on CREATE PROCEDURE. That will get you started in putting your query into a procedure. Then, as Jeff said, it's a question of calling it using the...

It's most likely a data problem within the cursor itself. I'd focus on what that cursor is doing specifically within the code in order to understand where the problem might...