Jeff Moden (9/21/2015)

---

Eirikur Eiriksson (9/19/2015)

---

Jeff Moden (9/19/2015)

---

Eirikur Eiriksson (9/17/2015)

---

Using my normal test harness, Kristen's DATETIMEFROMPARTS solution is a clear winner, more than twice faster than the next one. Note that...

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)

Of course, the Ren...

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)

Of course, the Ren Fest...

SQLRNNR (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

WayneS (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

WayneS (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P...

WayneS (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

WayneS (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've...

SQLRNNR (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

WayneS (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few...

smthembu (9/24/2015)

---

Hi All,

I have recently upgraded my DEV environment from SQL 2008 SP4 to SQL 2012 SP2 and all went good. Now the issue at hand is that when i...

SQLRNNR (9/24/2015)

---

GilaMonster (9/24/2015)

---

robinwilson (9/23/2015)

---

Thanks all for the information and detailed responses which is all really useful.

Heaps

I was told this by the software supplier:

I accept that clustered indexes do seem like...

Slum

If it is being build on a budget then Super-micro would probably be the first choice, Dell has still a good bang for the buck in the mid-range and if...

Grant Fritchey (9/23/2015)

---

Went back to the train wreck... uh, I mean Jet discussion.

I just keep hearing "MongoDB is web scale" over and over.

And if anyone searches that up, fair warning,...

bala2 (9/23/2015)

---

Hi All,

Can any one help me to get the script to find the current queries and process that are causing to utilize high CPU on the SQL server 2008/2008...

joeshu26 (9/23/2015)

---

Does anyone have some insights on what the optimal machine would be to run Analysis Services Tabular? Specifically a server/machine/alienware which would be optimal?

Or atleast the...

Quick thought, the single most important tuning tip here is to eliminate the sort operator by supplying a covering index that...

Quick though, can you post your code, there is a type in your initial code,...