At my old job, as a development DBA, I had minimal self-directed time. I was in a dev support role so I had a list of tickets to work...

Just to make sure we're not...

We just started testing Ola Hallengren's maintenance scripts and they're very well thought out and thorough. However, it logs to a text file, not a table which will make...

Both would also probably need to be SQL 2008 or higher too although I haven't tested that.

I agree with all of that. In the end, each of us are responsible for our own development. ...

kasirisha (5/11/2011)

---

I am accessing a Event table which has huge volume of data. So I would like use temporary index in my Query.

I cannot create additional index on the Event...

I just tried it on my machine and it ran fine. I do remember...

Revenant (5/10/2011)

---

"... you're being paid for that job, so you are responsible. That means you have to learn how the technology in your environment works and how to solve...

Eric M Russell (5/10/2011)

---

I'm not sure how many users monitor their guest book or blog posts close enough on a daily basis to notice if one (out of a couple...

I'm not quite sure I agree that if Facebook lost 1 out of 1,000 posts that no one would care. I do agree that with Google most people wouldn't...

It's not just access patterns you need to be aware of when deciding where to put the data. You also need to keep in mind how quickly the data...

Obs (5/6/2011)

---

Creating compressed backups is supported only in SQL Server 2008 Enterprise and later, but beginning in SQL Server 2008, every edition can restore a compressed backup.

http://msdn.microsoft.com/en-us/library/bb964719%28v=SQL.100%29.aspx

I dont have...

Paul Randal (5/6/2011)

---

There's no choice but to have it behave that way because something in the transaction log that gets recovered at the end of the restore good disable compression...

Resender (5/4/2011)

---

So what do you do if tempdb get deleted and not yet its location, the article states what happens if the partition is removed not if the data on...

What I find interesting is that everyone is jumping on the human error portion of this. Yes, it was an individual that started the tear. However, it was...