+1

and still it is necessary to read in the MSDN https://msdn.microsoft.com/en-us/library/ms191007.aspx

slowly and carefully the...

Yes, +1

And thanks Steve for this question and the useful reference on Windows PowerShell Tutorial.

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