That's what I meant to say:)

If you're taking about changing the SSRS timeout, open your Microsoft Reporting Services Configuration Manager and click on the "Report Manager URL". Click on the URL and then click on...

Over 35 should actually be subset(nfl2018.qb, Age>35). 

Actually according to Microsoft it's not required at all. Their own example doesn't use it.

Both locale desc and movie work in this query - after correcting the movie name that is.

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/choose-an-encryption-algorithm

SQL Server allows administrators and developers to choose from among several algorithms, including DES, Triple DES, TRIPLE_DES_3KEY, RC2, RC4, 128-bit RC4, DESX, 128-bit AES, 192-bit AES, and...

Whoops, I selected both file types so I was a surprised that I was - supposedly - wrong.

Jacob is correct. Contains doesn't work the same as Like. Like will find the character match based upon where the wild card characters - finding "TheJo' when the search phrase...

They never learn - DBA - Don't Bother Asking:hehe::w00t:

Somebody needs more coffee and it's not me this time:):hehe:

but the question was how many ids were returned - I answered the same way you did.

Read it wrong - id 3 is returned, but only 1 value:( Would have had it right otherwise...

Any hotfixes or patches installed recently? Try

sp_dropserver 'servername'

sp_addserver 'servername', local

and restarting.

I know I haven't had my coffee yet but there's a problem with the scripts as shown 😉