spaghettidba (4/17/2015)

---

More readable format for those who want to answer:

+-------------------------------------------------+---------------------+--------------+------------------+---------------------+

| wait_type...

Grant Fritchey (4/17/2015)

---

One setting I'd change immediately is the Cost Threshold for Parallelism. You have it at the default of 5. Change that to a reasonable number. You can look...

MMullane-222251 (4/2/2015)

---

I have a replicated database on 2008 R2 being moved to a new instance with 2014. Application regression testing is complete and all tests are good.

The...

Thank you very much for your post. We had similar problem in production server that was not been able to find the root cause for quite a while. We...

+1. Good question.

Replication is the solution for your scenario.

No. If its a user database. But if you are moving system databases such as master,model...

Still MySQL does the same way scripting objects and its data in the native backup (Mysqldump).

Any one who had applied sp 2 with multiple cluster node?

I knew its a free service. Can some one please shed some light or direction with SP 2 upgrade....

Good Question.

+1. Good question.

+++++++. Well 126 people got it incorrect so far. Hmm that's interesting.

Bug in the leader board. Missed 2 points.

azdeji (8/29/2013)

---

Hi,

I have set the identity columns to -1,1 but I want remove the number zero from the identity sequence example below.

Currently --

Identity column

-1

0

1

2

3

4

And so on.

What I want is...

Thank you for the easy 7 points.