Viewing 15 posts - 1 through 15 (of 163 total)
I also think that the (main) issue is that the order of the columns in the proposed index,is based on the order of the columns in the table. Find a...
February 26, 2021 at 12:31 pm
Based on the following sentence on the page used as reference for the explanation, I would expect that the backup fails.
Note that if any file in a filegroup is offline...
August 13, 2020 at 9:19 am
The order by is not allowed for an EXCEPT, and neither allowed for a UNION.
June 4, 2020 at 2:04 pm
I think the answer or in fact, the explanation is incorrect and/or incomplete.
My assumption is that the the numbers between the brackets are first "calculated", and then the following...
October 10, 2018 at 6:35 am
Same for me for selection the "wrong" right option.
But probably none of the answers is right, or it should have been a combination of options. The thing is...
July 30, 2018 at 4:27 am
To enable backup checksums in a BACKUP statement, specify the...
June 25, 2018 at 7:23 am
April 25, 2018 at 5:44 am
March 14, 2018 at 2:15 am
I think the assertion that "standard indexes" will improve JSON performance is misleading. That is...
March 1, 2018 at 4:00 am
More of a trick question than a basic count question.
February 2, 2018 at 5:54 am
Maybe something worth noting: starting from SQL Server 2017, there is not limit anymore on the number of indexes that can be created.
December 1, 2017 at 8:12 am
November 15, 2017 at 11:27 am
November 15, 2017 at 3:07 am
Something that might not be clear is that only the date format is not changed until the end of the batch. What the DATENAME returns is directly affected.
[code...
November 14, 2017 at 3:16 am
November 7, 2017 at 6:05 am
Viewing 15 posts - 1 through 15 (of 163 total)