Viewing 15 posts - 1 through 15 (of 54 total)
I was expecting to see recursion listed among the answer options, but realized that recursion was simply a scenario that guarantees a spool operator.
June 27, 2020 at 2:24 am
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...
May 27, 2020 at 8:38 pm
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...
January 6, 2020 at 6:25 pm
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...
December 9, 2019 at 6:03 pm
In your example you mismatched the synonym StagingSongs with SongStaging
I noticed this as well, but since there was no option for "Invalid object name 'dbo.StagingSongs'.", I assumed the intention...
September 6, 2019 at 5:09 pm
However, the data type isn't strictly speaking an INT it is a DECIMAL(1,0):
sp_describe_first_result_set @tsql = N'SELECT 1.test;'
shows it is a system_type_id 108 (numeric) and...
August 27, 2019 at 8:47 pm
Alternatively, put a WHERE clause on the statement so it won't have unnecessary IO of updating rows that don't need to change.
This is a really important point. If you...
August 7, 2019 at 10:02 pm
One approach to avoid dividing by 0 is the NULLIF trick:
SELECT Numerator/NULLIF(Divisor, 0)
June 13, 2019 at 12:39 am
March 22, 2019 at 11:29 am
Technically you mean "odd positive numbers" 😀 (since the set of odd numbers less than 100 is infinite).
March 6, 2019 at 10:44 am
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...
March 5, 2019 at 11:20 am
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...
February 28, 2019 at 1:04 pm
Solomon Rutzky - Thursday, January 31, 2019 12:36 PMGood to know about "sys.identity_columns.last_value". 🙂
I originally found it via this Stack Overflow thread:...
January 31, 2019 at 2:05 pm
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,...
January 31, 2019 at 11:04 am
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.pdfIt sends a shiver up my spine every time I read it, but there...
December 18, 2018 at 11:10 am