ALZDBA (1/13/2011)

---

Did they develop/implement new code or has a part of the application been used that they didn't use previousley.

If it is a new dev part, they should have used...

Thought you may like to know the outcome. The issue seems to be related to a recent photo module which has been added to the system, hence the BLOB data....

Thanks very much for the input guys. I'd forgotten all about default trace, although I read that very article a while back. I'll look into all your suggestions.

Kind...

bitbucket-25253 (1/7/2011)

---

cengland0 (1/7/2011)

---

Tom.Thomson (1/7/2011)

---

Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending...

I had to go back to Kimberly Tripp's excellent article for the answer to this. Well worth a read for those who haven't encountered it.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Yeah good question. Knew the answer wasn't "enable" so I took a choice between "create" and "new" since I couldn't remember the syntax. I picked wrong 🙁

Wow,

sounds like you guys have worked for some shifty employers! In 10 years of working in IT I've never even heard of anyone being involved in any kind of...

Profiler is an essential tool in the DBAs box of tricks. Be careful though. I would advise against running profiler against a production server as it can impact performance....

Agreed, I was expecting it to be a trick question. A 2 New Delhi option would've made it less obvious. It is still good to be reminded that...

vk-kirov (9/9/2010)

---

Sorry, but this...

Thanks very much for writing this article. SSRS is a technology with which I would like to become more familiar. I am very much looking forward to the...

Jim McLeod (7/18/2010)

---

I agree with (d) and (e). Remember that a backup strategy should also be a restore strategy. If you only take log backups (d), and your...

Will let you know if it's any good.

rdouglas66 (7/15/2010)

---

Yin Halen (7/8/2010)

---

Just barely failed the 70-450 test today.

Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass...

GilaMonster (7/10/2010)

---

Chris Houghton (7/10/2010)

---

Am i right in thinking then that data doesn't "move" from the transaction log (ldf) to the data file (mdf). The database engine modifies data pages...