Viewing 15 posts - 1,396 through 1,410 (of 3,348 total)
Bob Cullen-434885 (1/23/2015)
January 23, 2015 at 4:45 am
DTML (1/22/2015)
(1) The default for the option ANSI_NULL_DEFAULT is off so, is this option typically changed...
January 23, 2015 at 2:22 am
DTML (1/22/2015)
January 22, 2015 at 1:05 pm
g.britton (1/22/2015)
Hugo Kornelis (1/22/2015)
g.britton (1/22/2015)
you may be right but the effect is exactly same so the fact that behind the scenes the process is different is probably irrelevant
The shorter explanation...
January 22, 2015 at 1:05 pm
jclementz (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
January 22, 2015 at 9:44 am
g.britton (1/22/2015)
you may be right but the effect is exactly same so the fact that behind the scenes the process is different is probably irrelevant
The shorter explanation is that your...
January 22, 2015 at 7:23 am
Carlo Romagnano (1/22/2015)
Hugo Kornelis (1/22/2015)
January 22, 2015 at 7:20 am
After reading the discussion, I guess it's a good thing I didn't have time to answer when the question was first released.
Got it right, thanks to other people complaining and...
January 22, 2015 at 2:38 am
Shame - I am sure I selelcted the correct answers, but the site tells me I am wrong and that the correct answer is what I selected. (Or think I...
January 22, 2015 at 2:36 am
g.britton (1/21/2015)
Just though I'd dispel the notion that only count(*) counts nulls:
select count('null') as count_null from (select null n union all select null) countnull
returns:
count_null
2
This code is not counting NULLs. The...
January 22, 2015 at 2:31 am
Too bad the explanation claims that NULL values are considered with * is used. Using * makes COUNT use rows, not values, and rows cannot be NULL.
Other then that, the...
January 22, 2015 at 2:27 am
I never liked implicit transaction, and I never will.
I am also glad that Carlo used PRINT, not SELECT. I thought that using SELECT would have started the implicit transaction, but...
January 12, 2015 at 10:33 am
Jeff Moden (1/11/2015)
Which of the following Recovery Models will allow for minimally logged index rebuilds?
A. Bulk Logged
B. Bulk-Logged
C. Bulk_Logged
D....
January 12, 2015 at 10:28 am
Good question.
What I missed in the explanation is that the filestream filegroup does have a physical path, but this is to a directory, not a file. And directories normally don't...
January 9, 2015 at 7:07 am
jbwa (1/8/2015)
The question asked if count would ignore values not ignore counting the row. I think the stated answer is wrong.
Max, in effect, handles Nulls as a lower possible...
January 9, 2015 at 7:03 am
Viewing 15 posts - 1,396 through 1,410 (of 3,348 total)