I once read about a term in economics that was coined for this kind of decision making: satisficing.

Satisficing is a decision-making process in which an individual makes a choice that...

Hi Ed,

Thanks. The even types are:

mydb1: event types 4 and 2

mydb2: event type 3

According to the MS documentation, those mean:

2 = Bad checksum.

3 = Torn page.

4 = Restored (page was...

Thanks Ed, that is an excellent reminder. I too often focus on doing what is asked of me. Sometimes the answer has to be "That is not possible," or "That...

Thanks, Scott. This is what I came up with. I decided not to use SET IDENTITY_INSERT dbo.sysjobhistory ON since they are just interested in having access to old history, not...

• This reply was modified 2 years, 4 months ago by  webrunner.

Thanks so much, Scott. That is extremely helpful information. Much appreciated.

-- webrunner

@edwardwill "The correct answer should be "Create Certificate". There is no LOAD CERTIFICATE Command."

That's what I thought!

-- webrunner

Thanks for this question, Steve. Especially because it explains another one of the generic errors that get returned from SQL Server, such as string or binary truncation etc.

-- webrunner

Thanks for this helpful review of the AVG() T-SQL function!

I'd just like to call attention to the few minor typos in the article - just helpful feedback. For example

"all female...

Gotcha, Jeff, thanks for the disclaimer. At the very least I can use the info you provided to rule in or rule out the issue. Much appreciated.

-- webrunner

Thanks so much, Jeff, I will review those articles.

Thanks again!

-- webrunner

Wow, as usual, thanks Jeff for the comprehensive breakdown!

-- webrunner

4 for me. I have barely traveled in my life! Wow.

-- webrunner

Thanks ratbak,

The report is not hidden, but I never knew about that setting, so thanks for teaching me about it!

I'll keep digging. I may have to do a screen share...

• This reply was modified 2 years, 7 months ago by  webrunner.

Lol!

Dang, Steve got me, too. I clicked into the comments only to remember it's April 1. Very convincing writing, Steve! Lol.

-- webrunner