Can you provide table structures and sample data that will illustrate the issue?

This will help people see the issue and better be equipped to help you.

Daisies

Depends on what you wish to monitor.

Solarwinds Ignite is top dog for monitoring waits and associating queries to which waits.

SQL Sentry is very good, but has a bit of a...

Luis Cazares (8/19/2014)

---

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District 11.

Granted, it is...

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District 11.

Granted, it is a non-profit...

smtzac (8/19/2014)

---

Hello Mr. Gila,

Can you please help me to understand this scenario:

Log file size right now 100 GB

Big translation took place, size of 125 GB.

would the Log file size be...

lemonade

N_Muller (8/19/2014)

---

curious_sqldba (8/19/2014)

---

Are there any other reasons except maintenance overhead if I split my partitions to separate file group? Reason I say that is if I have multiple file groups...

GilaMonster (8/19/2014)

---

TheSQLGuru (8/18/2014)

---

As far as I am concerned there is a hard limit for most every server out there and that is the number of physical cores in each NUMA...

GilaMonster (8/19/2014)

---

MyDoggieJessie (8/18/2014)

---

What's a good way...

Yes to the Reporting Services Configuration manager.

Very...

True. Sharepoint should be set to maxdop of 1. AX and other flavors of Dynamix also work better with maxdop 1.

That said, it is best to know your...

I currently run SSRS2012 on Win7 Home. One of things I found I had to do was set the url to use port 8080.

Bill