Thanks a lot for your quick response.

Yes, we have four tempdb data file with 30GB each and our tempdb log file is pre-allocate with 60GB. I'm in the process of...

joeroshan (12/12/2016)

---

Robin35 (12/12/2016)

---

Hello,

Our ReportServerTmpdb log file is full and our reports are receiving this error. i'm trying to understand, what causes this log file to grow and how can we...

Eric M Russell (12/9/2016)

---

Where I work, we use Octopus and Chef for automated deployments. If what you need is an account that can create a database, create objects within that,...

Thom A (12/9/2016)

---

Robin35 (12/9/2016)

---

Thom A (12/9/2016)

---

Correct me if I'm wrong, but are you instead saying that this particular login should always be assigned specific permissions whenever you create any and...

Thom A (12/9/2016)

---

Correct me if I'm wrong, but are you instead saying that this particular login should always be assigned specific permissions whenever you create any and all databases on...

Thom A (12/9/2016)

---

Robin35 (12/9/2016)

---

Hello,

i'm trying to create a login and assign permission to login so that it should be able to assign any kind of permissions on any databases on...

TheSQLGuru (11/23/2016)

---

Robin35 (11/23/2016)

---

Thanks for your valuable inputs.

in old serverSQL 2008 R2 is using all 32 physical cores.

in new server SQL 2014 is using 16 physical cores or 32 logical cores.

Per...

Thanks for your valuable inputs.

in old serverSQL 2008 R2 is using all 32 physical cores.

in new server SQL 2014 is using 16 physical cores or 32 logical cores.

Per our infrastructure...