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,...

I tend to take several mini-vacations a year, like a four day weekends to section hike the Apppalachian trail or immerse myself in a home improvement project.

Krishna1 (4/28/2013)

---

Dear All

I was doing bcpin with 20 million records. I stoped it in between. Then tries to delete the table form the DB. It took long time hence stoped...

Run a sample procedure call in a SSMS Query window with the 'Include Actual Execution Plan' option enabled. This will reveal the relative cost of each query within the stored...