Viewing 15 posts - 1,516 through 1,530 (of 8,416 total)
I can't believe I spent as much time as I did on this question. Let me share...
I opened the SQL_VARIANT BOL page that describes sorting an families (http://msdn.microsoft.com/en-us/library/ms181071.aspx), because...
November 10, 2011 at 12:44 pm
Ninja's_RGR'us (11/10/2011)
We don't have the ressources to retest the whole ERP. It's the 3rd time I have a situation lile this. And certainly not the last!
OK (though the...
November 10, 2011 at 10:59 am
It is a bug, and one I have seen before. In the bad plan, the top branch index scan is unordered (it has the Ordered:False attribute). The required...
November 10, 2011 at 10:34 am
GilaMonster (11/10/2011)
SQL does not have incremental backups.
Closest to it would be a log backup.
November 10, 2011 at 9:41 am
Ninja's_RGR'us (11/10/2011)
Actually I caught the very moment it happened!
You need a hobby.
November 10, 2011 at 5:16 am
Perhaps the reason for posting the answer Dev did was that 'daveriya' really wasn't getting the message, even after all our best efforts. The aliased UNION and ORDER BY...
November 10, 2011 at 5:15 am
sqlfriends (11/9/2011)
Thanks, so above statement, for inner join it doesn't need to join on a matched column?
That's right, the SQL language doesn't force people to write joins that make sense.
I...
November 10, 2011 at 12:23 am
GilaMonster (11/9/2011)
SQL Kiwi (11/9/2011)
GilaMonster (11/9/2011)
Never worked with Tony Davis have you?I found Tony to be very easy to work with, and a very 'light' editor. No dramas.
Depends on whether...
November 9, 2011 at 1:25 pm
GilaMonster (11/9/2011)
Never worked with Tony Davis have you?
I found Tony to be very easy to work with, and a very 'light' editor. No dramas.
November 9, 2011 at 1:10 pm
Sean Lange (11/9/2011)
November 9, 2011 at 12:36 pm
GSquared (11/9/2011)
I've asked 'em in an interview. The interviewee passed, because he just exclaimed "I don't know that!" and made the right "screaming noise". Worked for me!
I tried...
November 9, 2011 at 9:22 am
Roy Ernest (11/9/2011)
November 9, 2011 at 9:19 am
Hugo Kornelis (11/9/2011)
I must say that the low rate of correct answers surprises me.
The question is reasonably difficult, Hugo. Multi-choice questions also tend to lower the success rate, historically...
November 9, 2011 at 5:16 am
Quick example. The following produce the same ordered results, and the output column is named 'Three':
SELECT 3 AS Three
UNION ALL
SELECT 8 AS Eight
UNION ALL
SELECT 1 AS One
UNION ALL
SELECT 5...
November 9, 2011 at 2:52 am
Not that I know of. Some error conditions produce multiple error messages; the TRY..CATCH related error functions just capture the first one.
November 9, 2011 at 2:50 am
Viewing 15 posts - 1,516 through 1,530 (of 8,416 total)