sipas (12/8/2016)

---

Luis Cazares (12/8/2016)

---

I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.

I need to ensure the databases are backed up while...

Interesting question, I had to for sure a little search in MSDN. :unsure: Thanks for this reminder Steve.

Easy one, it is useful to know how to use sp_MSforeachdb. Thanks for this question Partha.

sipas (11/24/2016)

---

"Number 4 works for this year only."

Actually it doesn't even work for this year.

SELECT DATEPART(DAYOFYEAR, SYSDATETIME()); gives 329

SELECT DATEDIFF( DAY, '20160101', SYSDATETIME()); gives 328

Happy Thanksgiving to all in the...

Great question. A very useful feature, thanks Steve.

Thanks for the question, I learned something new. Very useful article about this topic

can be studied here: https://www.simple-talk.com/sql/sql-tools/registered-servers-and-central-management-server-stores/

Thanks Lesole for an interesting topic.

In MSDN https://msdn.microsoft.com/en-us/library/ms187745.aspx is stated that

"Integer constants greater than 2,147,483,647 are converted to the decimal data type, not the bigint data type."

But...

Quite useful question, thanks Steve. But I was groping a while in the article "Looking at views, Close Up",

Dropping Views paragraph until I figured out that here is described the...

I used this article in MSDN: https://msdn.microsoft.com/en-us/library/hh213536.aspx

Interesting question and very good explanation, thanks Steve.

+1 😉

Good question with a perfect explanation, thanks Junior 🙂

Version SQL Server 2014 would be enough. Inline specification of indexes

was introduced in version SQL Server 2014, see my link...

Thanks Steve for this question. I learned something new about the inline indexes. I found a good description in MSDN here:

https://msdn.microsoft.com/en-us/library/bb510411(v=sql.120).aspx

Good question, thanks Steve. To answer, I used this link:

https://books.google.cz/books?id=SbwLJTD-UuYC&pg=PA723&lpg=PA723&dq=DROP+SERVER+AUDIT&source=bl&ots=3sfsk4v65o&sig=OtdEj_y98YnQHkOOJ3UekKMW9aY&hl=cs&sa=X&ved=0ahUKEwjFj7Xy__3PAhWBuRoKHXT2At4Q6AEIPDAE#v=onepage&q=DROP%20SERVER%20AUDIT&f=false

+1

I was interested that the anonymous is default, but I guess it's better created

a new table with the name of the history table explicitly defined.