To be honest, I'm not really sure if there is a performance difference. The query method tends to be simpler and easier to read for many folks, but I think...

Thanks for the question, Steve!

The next question would be, what is the best way to write this for readability? Should we be using "NOT" or flip the operator to use...

This method is slightly different. It is intended to count occurrences of an item within a list. For example, if I needed to count how many times the element...

Just a heads up, it looks like one of the answer options didn't populate in the textbox correctly.

Here's the exception for the question option, if it's not too late:

This will...

Thanks for the added documentation on this!

https://github.com/MicrosoftDocs/sql-docs/commits/live/docs/t-sql/language-elements/variables-transact-sql.md

It's important to note, this behavior is similar with normal variables as well.

DECLARE @Amount int = 0;

BEGIN TRANSACTION;

SET @Amount...

Thanks for the feedback!

I agree, it...

I probably let this annoy me much more than I should.

Outlook Message Backgrounds. I consistently receive emails from a select few people that have applied default backgrounds which make it...

It's possible to use the PARSENAME function to split these values to octets. If you're only trying to identify these values with three octets, you could possibly use something...

Please take a look at the following article: Parse and Transform JSON Data with OPENJSON (SQL Server)

If you're attempting this in SSMS, please try the following.

DECLARE...

Hi there. Interesting question. Here are some notes:

<li style="list-style-type: none;">

1. At the start of the question it mentions that the database is using the Latin1_General_100_CI_AS_CS collation. Those last...

You could use the undocumented sp_MSforeachdb procedure to iterate over each database. There are some potential bugs and quirks with this, so I would encourage you to read into it...

I've never much enjoyed building out these complex expressions in SSIS.

What have you tried so far?  I imagine if you replace the "th ", "nd " or "st "...

You're welcome.

This was posted in the SQL Server 2014 forum. Extended Events were introduced in SQL Server 2008, but is more difficult to setup as there isn't a GUI in...

So you're iterating over each database to identify the procedures in each database to compare to your findings in sys.dm_exec_procedure_stats? I think setting this up as a job to persist...

I'm glad I could help! I've been down that road before myself.

You're welcome!