Brandie Tarvin (10/24/2008)

---

Jeff may disagree with me on this, but here's my take on interviews.

Know your stuff, but if you can't answer the question, be honest about it. Tell the...

Like I said... lemme see if I can find the code I made previously...

Dang... you're right... there is an edit on Jerry's post. Thanks for the reminder, Seth. You'd think folks would at least admit to making a correction, but it...

Adi, it would be my pleasure! Absolutely ok with me for you to add the link to your signature. If more folks would do that, we might get...

Hi Jim,

Thanks for the feedback.

It's amazing, to me, how many posts this article elicited... and it was my very first article, to boot! 🙂

As you probably already know,...

True enough.... but not until you find out [font="Arial Black"]WHY [/font]it grew to 50GB in the first place and fix it. Otherwise, it's just gonna grow again. 1...

:hehe: If you have SQL Server, you don't need CLR's or any of that other stuff with the exception of maybe some RegExReplace. 🙂

... and, like I suggested before, please tell us what Task.exe actually does. There may be no need for such computational shenanigans at all. 😉

rishgup (10/24/2008)

---

You can say each trigger update each field. Say You have table employee and address, whenever data is inserted into the table employee only emp_ins field will be incremented...

Greg Snidow (10/24/2008)

---

Now wait a minute...no one ever mentioned that one to me before. I'm not sure exactly what that...

Sandy,

Along with the other recommendations for regular DB, index, and other forms of maintenance, if you still are having performance problems after that, there's a pretty good chance that the...

Also, running DBCC commands, even (gasp) SHRINKFILE or SHRINKDB can be done ONLINE... it will slow things down a bit but the system will still be available.

The_SQL_DBA (10/24/2008)

---

Jeff...correct me if I am wrong 🙂

After the shrink, as users add rows etc in the database, the file has to grow again.

Growing a database file is an...

balv (10/24/2008)

---

The info required is found using a key and is located on table-a or table-b. The result gave the info on table-a (if available), else found the info...

Garadin (10/24/2008)

---

I figured I'd let you answer one of these, since I've snagged like the past 10 :hehe: (Although this one didn't quite work out the way...