I would go with 6 - the number of PHYSICAL cores per NUMA node.

As other's said, Cost Threshold for Parallelism is VERY important. 5 is a universally...

You said you didn't have problems now but data is growing...

ramana3327 (8/27/2014)

---

Yes.

The problem is that tables have foreign key constraints. We don't have any proper partition key. So now we created two additional columns on those tables created date &...

ramana3327 (8/25/2014)

---

Hi Kevin,

Thanks for the reply.

For now we don't have any issues but just now data is growing. We are estimating it will grow very large in the future. We...

Please state WHY you want to implement partitioning. What problems will it help you address? Partitioning is a COMPLEX subsystem with lots of caveats, provisos, limitations, gotchas, etc....

I still don't understand why there was pushback from the website devs over the obvious solution of some form of Turing Test (with Captcha or it's derivatives being the most...

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

Daily isn't good enough. You can easily roll your own alerting for lots of things, or have a consultant set some monitoring up for you.

There are a...

Thor Bev (8/14/2014)

---

I have several 2012 availability groups running on a cluster. I have one database that is bulk loaded every 30 minutes. The DB is about 1...

james.williams 57297 (8/13/2014)

---

Hi all -

I'm working on a trigger and I'm having some problems. Basically what I want this trigger to do is: if Users.Primary_ProductID is updated, I...

Evil Kraig F (8/8/2014)

---

TheSQLGuru (8/7/2014)

---

I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which can...

ScottPletcher (8/8/2014)

---

TheSQLGuru (8/8/2014)

---

ScottPletcher (8/8/2014)

---

My first choice would be to use RECOMPILE and just force SQL to rebuild a plan every time.

But, if a HASH join is the "good" plan, forcing...

ScottPletcher (8/8/2014)

---

My first choice would be to use RECOMPILE and just force SQL to rebuild a plan every time.

But, if a HASH join is the "good" plan, forcing a HASH...

Ashif Shaikh (8/7/2014)

---

Hi All,

I ran ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3 that means the SQL server 2012 is using the 2nd and 3rd CPU's respectively..

Now, when I...

GilaMonster (8/8/2014)

---

Wrong question

SQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't,...