You might want to carefully select the database and the tables to tune in the General Tab, start with few and add more, even in a different session.

😎

Quick question, are you trying to analyze everything on a large server in one go?

😎

ramezani583 21209 (9/27/2015)

---

Hi all,

What to do when Consuming Workload Fails in Database Engine Tuning Advisor?

The minimum storage space required for the existing physical design structure (PDS ( you have...

Quick question, what else is running on the server beside the Sql Server?

😎

robinwilson (9/26/2015)

---

Hello

I have to update the instance name in all stored procedures and functions but cannot seem to find a way to obtain the up to date full contents of...

Ed Wagner (9/25/2015)

---

SQLRNNR (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/25/2015)

---

Just mount it to...

Kristen-173977 (9/26/2015)

---

GilaMonster (9/24/2015)

---

Kristen-173977 (9/23/2015)

---

GilaMonster (9/23/2015)

---

Functions in the select execute once per row, and they have an overhead. Data-accessing scalar functions in the select are essentially a hidden cursor inside a...

MotivateMan1394 (9/25/2015)

---

hi

I create a report base on categories and sales of goods.

Now I have Daily Info abaout all Products.

But I Need to present this report base on weekly periods....

Quick question, can you post the DDL (create table) and preferably some sample data as an insert statement?

😎

...and break your back...

Not that I'm getting old:Whistling: but the likes of CZ-P09...

Ed Wagner (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/25/2015)

---

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

SQLRNNR (9/25/2015)

---

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

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