Thank you Joe! I will look into it.

This is some old code that just started causing problems, all new procedures are using OUTPUT. thank you for the link!

TheSQLGuru (3/17/2016)

---

A) I actually use physical cores on NUMA for my MAXDOP number.

B) Someone needs to convince your company that their physical resources/configuration (virtualized here?) is unacceptable for optimal performance....

TheSQLGuru (3/17/2016)

---

But generally is it better to have data files on a slower drive and log files on SSD (I assume it depends)? Might be worth mentioning that there is...

EdVassie (3/17/2016)

---

I would want to look at the 2TB drive, to see

a) how much space is used by logs

b) what else is on the drive

Then I would want to...

Sure,

Currently we have a machine where we have windows, sql server, system databases and production database(data file only) on C drive (i know, don't need to comment on that) which...

The main problem is that on our fast drive we are slowly running out of space, we have another, slower, drive that we could use. We are planning to move...

DesNorton (3/15/2016)

---

The cleverer peepels here will probably shoot me down...

TheSQLGuru (3/14/2016)

---

1) IIRC, partitioning is an Enterprise Edition only feature. That could preclude it's use right off the bat.

2) Partitioning CAN make SOME or even MOST queries run very...

I need the historical data for the upcoming project of implementing "cash book", also considered partitioning but i found your article, where you clearly explained that this is not a...

Yes it does

If you are including schema in the selection it has to be in quotes, also make sure at the end of shortcut you have comma.

Make a selection in text editor (ex: highlight a table name and press ctrl+3)

Latest version here:https://goo.gl/ggCkh7

Latest version here:

https://drive.google.com/file/d/0B-5--YXA5WAGTXVHZmh6VHJDWTA/view?usp=sharing