Sean, shame on...

GilaMonster (5/21/2015)

---

My usual recommendation to clients is:

Split TempDB into 4 files, make sure they're all the same size, all the same growth increment. If I'm seeing obvious allocation contention...

Kevin,

I knew there was something regarding spindles involved. Thank you for the refresher. We'll check and see what they gave us before we make this decision.

Lowell (9/8/2010)

---

As a solution to my own question, one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not...

I have a question on tempdb over here if anyone would care to drop by and share their thoughts.

I'm kinda wishy-washy on this one. So some perspective would be helpful.

Eirikur Eiriksson (5/20/2015)

---

Ed Wagner (5/20/2015)

---

Eirikur Eiriksson (5/20/2015)

---

Grant Fritchey (5/20/2015)

---

Eirikur Eiriksson (5/20/2015)

---

GilaMonster (5/20/2015)

---

If it's...

Jeff Moden (5/20/2015)

---

audiocool (5/17/2015)

---

Hi Shawn,

- OS and SQL Server 2012 are 64 bits

- The server equipped with SQL Server 2012 and McAfee Virus Scan Enterprise v8.8

- I...

Grant Fritchey (5/20/2015)

---

Jason A. Long (5/20/2015)

---

Brandie Tarvin (5/20/2015)

---

Grant Fritchey (5/20/2015)

---

Again...

AAARRARARRGGGGHHHH!!!

Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored....

Grant Fritchey (5/20/2015)

---

Again...

AAARRARARRGGGGHHHH!!!

Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things are...

Dare we ask?

SQLRNNR (5/19/2015)

---

Eric M Russell (5/19/2015)

---

But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all it involves is...

David Webb-CDS (5/15/2015)

---

Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. You gather...

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading commas or...

GilaMonster (5/15/2015)

---

Luis Cazares (5/14/2015)

---

You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning....

Jeff Moden (5/14/2015)

---

Alvin Ramard (5/14/2015)

---

Here's an interview question:

Name 10 of the parameters for DBCC TimeWarp. 😛

I'd seriously consider asking a DBCC TimeWarp question at an interview, just to see...