DEK46656 (12/20/2016)

---

Nice article, thanks for sharing. We have a number of systems that have some high “peakedness” for CPU. It hasn’t become an issue yet, but I’ll look...

skeleton567 (12/20/2016)

---

Igor Micev (12/20/2016)

---

skeleton567 (12/19/2016)

---

Two things are going to cause CPU spikes by scheduled jobs:

1. Poor design that causes a requirement that a job be run too frequently.

2. ...

skeleton567 (12/19/2016)

---

Two things are going to cause CPU spikes by scheduled jobs:

1. Poor design that causes a requirement that a job be run too frequently.

2. Delusions that the...

Ok, I also wanted to appoint considering the renaming. You can find many posts about it.

Hi,

Check the Upgrade-List table in this link https://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx

I'd also skip in-place upgrade and do it with a new installation of SQL Server 2104.

Do you still need the same instance name?

Nowhere in the question is stated that the SSMS is 2016 version. "Compare Showplan" is not available in the lower versions.

So the answer is not always correct.

"Open the properties...

Licenses for what: Standard or Enterprise? Because it's very different in price.

My advice is to start with Standard....

kevaburg (12/13/2016)

---

Igor Micev (12/13/2016)

---

If you install SQL Server 2016 then you'd be much better. The Standard is very close to Enterprise. Find them here https://msdn.microsoft.com/en-us/library/cc645993.aspx

For SQL Server 2014 find this...

If you install SQL Server 2016 then you'd be much better. The Standard is very close to Enterprise. Find them here https://msdn.microsoft.com/en-us/library/cc645993.aspx

For SQL Server 2014 find this reference https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

SQL Learner - VKG (12/12/2016)

---

Thanks for update. That's fine for 10 GB as you are saying. But the thing is, I am running out of space. Is there any other...

vinnnu88 (12/9/2016)

---

Thank you for your quick response..

You are right we have one full backup for a week and diff backup daily..

Now assume that we are taking log backup for every...

No, you don't need a Full backup every day.

Example:

Full backup once per week

Diff backup: once per day (or more times, it's up to you)

Log backup: every hour (or every half...

There is no cost of running it. If you want to forget about it, then keep it running. Here...

Keep it running.

Rechana Rajan (12/7/2016)

---

When i script out tables from my local some have ANSI_PADDING ON and some dont have that mentioned before the create table state. Can anyone help me understand...