jpSQLDude (5/14/2013)

---

Thank you all, these are very helpful!

This is a production server, so I can't make *any* changes like installing software, not even Who is Active.

But what I can do...

Someone previously provided methods to return what sessions are currently accessing the database and what execution plans consume the most read and writes.

Something else that might be useful is...

Identify a specific INSERT or UPDATE statement is believed to benefit from this cache flushing. It's possible that the actual I/O isn't slow, but rather the execution plan is stale....

mah_j (5/4/2013)

---

Hi

I want to archive the data of a 400G table,what is the best way of archiving?

My table has a clustered index on 2 fields (int,datetime).We just do select on...

kellyascent (5/5/2013)

---

OK so today I did a clean install of SQL still on the same hardware with the same settings, removed the AWE and set the Max worker threads back...

chrisolivierrsa (5/3/2013)

---

Hi,

I am pretty sure if you stop and start the service, it stops the rollback operation, after that, you can drop the table removing the keep history button, since...

Ryan007 (4/30/2013)

---

Hi,

We are running one job which runs SELECT query from a view from another linked server. We are getting blocking in the linked server where SELECT query from View...

Jon.Morisi (4/30/2013)

---

Hi,

I have a system with a lot of blocking. From the last occurrence I found a statistics update causing a lot of the blocking:

SELECT StatMan([SC0], [SC1], [SC2], [SC3],...

RE: SQL career advice

If your current job is secure, then I'd suggest staying put for at last a few months. Install SQL Server 2012 Developer Edition, and spend your flex...

There are facts and then there is narrative. Politicians, the media, and activists are more concerned with the narrative, because that's what gets their point across to the audience. However,...

TravisDBA (4/30/2013)

---

Eric M Russell (4/30/2013)

---

TravisDBA (4/30/2013)

---

Eric M Russell (4/30/2013)

---

I have only two words in response...

TravisDBA (4/30/2013)

---

Eric M Russell (4/30/2013)

---

I have only two words in response to this rather audacious...

mosborne (4/30/2013)

---

Yea, the real world aspect, is if they are 'that' good, they will move onto either high priced consulting or higher level job which kind of moves away from...

There are a lot of DBAs who don't have people skills, a university degree, or even socks, but they are amoung the best at what they do.

Well, monitoring and disaster recovery are perhaps the two most important DBA skills. People skills is what would differentiate an exceptional DBA who loves their job, gets invited to lunch,...