Viewing 15 posts - 166 through 180 (of 233 total)
I was very torn between "3" and "Not supported". Based on the following in the cited documentation, I kind of felt both were correct:
The FIRSTROW attribute is not intended to...
April 7, 2015 at 1:32 am
ISQL/W... Pftt! New-fangled stuff.
I remember when I did most of the work in SAF on SQL Server 1.1. Those were the days...
March 27, 2015 at 4:11 am
Let's assume that there's no output file already there in the location.
If the file is already available in the location, will it write anything to the file?
Which is it? Is...
March 26, 2015 at 2:00 am
Can't really say anything positive about a question which relies on regional settings for correct answer, and which doesn't really promulgate any useful knowledge. Why would I want to do...
March 23, 2015 at 2:03 am
In Sweden, the legal minimum is 25 days of fully paid vacation, but many have 30 or more paid days off. All countries in the European Union have at least...
March 3, 2015 at 1:29 am
More tsk, tsk.
There, now I've got the two points.:hehe:
January 20, 2015 at 6:51 am
Tsk, tsk.
January 20, 2015 at 6:50 am
Mighty (1/7/2015)
I think 1 + 2 + 3 + NULL is the same as 1 + 2 + 3 + 0.
In relation to this, I don't fully agree. For me...
January 7, 2015 at 9:06 am
Not fond of this question.
COUNT(*) counts NULL:s, but COUNT(<expression>) doesn't.
select count(*), count(a)
from (values (1), (NULL)) x(a)
And GROUPING most certainly considers NULL:s.
January 7, 2015 at 1:02 am
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Since the...
November 14, 2014 at 12:57 am
Well, if you don't like any of the available clients API:s, or if you're implementing SQL Server support on a new platform, you're going to have to know this very...
October 22, 2014 at 2:49 am
Quite frankly: If you think you have to know this, you're very likely doing something wrong. Still, I've earned yet another very arcane bragging point.:hehe:
October 22, 2014 at 2:30 am
I'm currently hiring. I'd like to know which 9% selected the CHTM option:hehe:
September 24, 2014 at 2:08 am
I think the only thing I take away from this question is confirmation that dynamic SQL must be avoided, but if you need it you should at least name your...
September 10, 2014 at 5:31 am
Interesting question. Too bad none of the answers are correct. BI edition does not support buffer pool extension.
Oh, and your reference link doesn't work.
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
May 8, 2014 at 12:06 am
Viewing 15 posts - 166 through 180 (of 233 total)