Viewing 15 posts - 151 through 165 (of 221 total)
Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up to SQL 2012....
January 7, 2016 at 1:05 am
webrunner (11/10/2015)
Iwas Bornready (11/10/2015)
I had to check the table structure of sysjobschedules. I would never have guessed that a date column was put into a purposely constructed int.
I knew that...
November 10, 2015 at 8:23 am
Thanks for this one! Got it wrong and learned something quite useful.
April 23, 2015 at 12:15 am
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
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
Viewing 15 posts - 151 through 165 (of 221 total)