Viewing 15 posts - 1,681 through 1,695 (of 3,348 total)
sharath.chalamgari (6/24/2013)
what could be the better approach in this kind of situation , is there any better option than this
Rethink your design.
Seriously. SQL is not designed for tables that can...
June 24, 2013 at 1:57 am
Good question, and mostly correct explanation. Except for the last sentence.
Such an error breaks the integrity of the code and makes further evaluation impossible. Parsing stops immediately at this point...
June 24, 2013 at 1:50 am
David Conn (6/22/2013)
One of the Posts suggested that SQL Server 2008 R2 was the Default is interesting as I haven't seen this mentioned before.
I think I know where this come...
June 23, 2013 at 9:32 am
Toreador (6/21/2013)
Hugo Kornelis (6/21/2013)The only reason that this ends up returning the next day is because of how datetime is internally implemented.
I thought that the main reason it returns the...
June 21, 2013 at 4:11 am
Though adding an integer to a datetime works (and is even documented HERE and HERE), I would strongly recommend against using it.
First, let's look at the internals. Operators work with...
June 21, 2013 at 3:02 am
Lokesh Vij (6/20/2013)
Rich Weissler (6/20/2013)
June 20, 2013 at 3:48 am
martin.whitton (6/20/2013)
Curiously, I can't find any explicit reference that states this threshold for SQL Server 2012.
If you follow the link in the explanation, you'll see (right at the top) the...
June 20, 2013 at 2:31 am
L' Eomot Inversé (6/19/2013)
June 19, 2013 at 2:53 pm
I have to disagree with most of the comments posted so far. I do NOT think that this is a good question at all.
First, the date format. I totally disagree...
June 19, 2013 at 5:26 am
sqlnaive (6/19/2013)
In a normal scenario it should be considered as the default behaviour for the question which is CI (and not CS).
I disagree, and I'll tell you why.
In questions where...
June 19, 2013 at 2:01 am
sknox (6/18/2013)
sknox (6/18/2013)
Hugo Kornelis (6/18/2013)
June 18, 2013 at 12:15 pm
Toreador (6/18/2013)
So "<> ALL" is equivalent to "NOT IN" ?
I checked the ANSI standard. It defines x NOT IN (y) as equivalent to NOT (x IN (y)), and x IN...
June 18, 2013 at 3:20 am
Toreador (6/18/2013)
I got this wrong, but having read the explanation I'm still none the wiser...
To understand the mechanics, start with the subquery:
SELECT Departmentid
FROM Emptable AS Emptable_1
WHERE (Empid < 5)
This...
June 18, 2013 at 2:34 am
Steve Jones - SSC Editor (6/14/2013)
Luis Cazares (6/14/2013)
The question is interesting but I do wonder why would someone would disable a clustered index?
ETL loads is one reason. It can be...
June 14, 2013 at 1:01 pm
crussell-931424 (6/13/2013)
Hugo Kornelis (6/13/2013)
crussell-931424 (6/13/2013)
June 13, 2013 at 7:56 am
Viewing 15 posts - 1,681 through 1,695 (of 3,348 total)