Thanks Steve for the first question of this year. It's an interesting topic, because in MS SQL Server 2016 Entreprise Edition it's quite different, see e.g.

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2011/12/22/alwayson-why-there-are-two-options-to-enable-a-secondary-replica-for-read-workload/

Thanks to Steve and all those who are preparing for us QotD, I wish you good health and good luck in the new year! 🙂

Yes in the MSDN HASHBYTES (Transact-SQL) there is no...

If you were looking for information on this MSDN article https://msdn.microsoft.com/en-us/library/hh710053.aspx ,

the answer would not be easy. I would probably give 1..100. There is no explanation of the value of...

Simple, but interesting question, thanks Steve. But I shot on Google today too hastily and missed. It was necessary

to start shooting from the MSDN https://msdn.microsoft.com/en-us/library/cc645993.aspx ... :crying:

+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...