This is practical when you add files to databases. Instead of calculating the number in KBs you just add MB or GB and task is done.

Thanks

Like partitioning, the compression of a database too, could not bring any improvements in terms...

RVarn (3/2/2016)

---

You are correct, take no action (defaults) in services for all three is correct and there is no need to change them (defaults) - remembering the sql server services...

The Recovery tab is opened when you see the Properties of the sql server service in the Services, not in the sql server configuration manager.

Anyone's experience on this?

CUs are usually released on every two months

https://support.microsoft.com/en-us/kb/2936603

Orlando Colamatteo (2/25/2016)

---

Igor Micev (2/25/2016)

---

Orlando Colamatteo (2/24/2016)

---

Igor Micev (2/24/2016)

---

Orlando Colamatteo (2/21/2016)

---

etl2016 (2/21/2016)

---

Hi,

I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such...

Orlando Colamatteo (2/24/2016)

---

Igor Micev (2/24/2016)

---

Orlando Colamatteo (2/21/2016)

---

etl2016 (2/21/2016)

---

Hi,

I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.

Could you please...

Orlando Colamatteo (2/21/2016)

---

etl2016 (2/21/2016)

---

Hi,

I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.

Could you please suggest if 8GB RAM...

RIP Dwain,

Your contribution is great.

Great QotD like a mini article.

I only knew that the unique index won't be updated, so a bit lucky.

Thanks.

Hi,

It depends on more factors, but in general you are expected to have a gain of it. As your system seems to be more OLAP-like (or DWH-like) because you're populating...

What does DBCC CHECKDB say?

Check this post from Paul - http://www.sqlskills.com/blogs/paul/how-can-a-log-backup-fail-but-a-full-backup-succeed/

ScottPletcher (2/22/2016)

---

I think you should get check all NULLable columns for a given table in a single pass. It could hurt severely hurt performance to have to scan the...

Good notice, and I saw that I haven't put all what I wanted with this script as an explanation.

I have found many columns in many tables of many databases that...

Hi,

Remove the ALTER , AS and BEGIN in the beginning of the SP and the END in the End.

Then just declare the variables (DECLARE) and you have a T-SQL code...