I was expecting to see recursion listed among the answer options, but realized that recursion was simply a scenario that guarantees a spool operator.

• This reply was modified 4 years, 4 months ago by  t.ovod-everett.

Physical tapes only protect you if the tapes eject from a tape library and can't be accessed without human intervention - otherwise an attacker can just have your tape library...

I do agree with you. Code Fix should be considered the first solution instead of REBUILD/REORGANIZE. Somehow, there is lack of knowledge I guess that can be filled with...

I beg to differ on the "As compared to the rebuild index operation, reorganize index is less resource-consuming operation" assertion.  That is not a clear-cut assertion either way.  From a...

• This reply was modified 4 years, 11 months ago by  t.ovod-everett. Reason: Clarify sequential vs. random

I noticed this as well, but since there was no option for "Invalid object name 'dbo.StagingSongs'.", I assumed the intention...

However, the data type isn't strictly speaking an INT it is a DECIMAL(1,0):

The query

sp_describe_first_result_set @tsql = N'SELECT 1.test;' 

shows it is a system_type_id 108 (numeric) and...

This is a really important point.  If you...

One approach to avoid dividing by 0 is the NULLIF trick:

SELECT Numerator/NULLIF(Divisor, 0)

Technically you mean "odd positive numbers" 😀 (since the set of odd numbers less than 100 is infinite).

I made a cool discovery recently related to this.  A user cannot both be the owner of a database and be a db_owner within the database - SQL Server won't let...

As documented in a number of places, the explanation "When all rows are removed from the table, the SEED is used for the identity value." is not entirely accurate.  DELETE FROM...

Note that the explanation is incorrect (at least for SQL 2016 and earlier, and most likely for SQL 2017 - the docs insist that the behavior changed after 2008 R2,...

One of the seminal papers on this is Ken Thompson's "Reflections on Trusting Trust".  https://www.archive.ece.cmu.edu/~ganger/712.fall02/papers/p761-thompson.pdf
It sends a shiver up my spine every time I read it, but there...