Viewing 15 posts - 3,451 through 3,465 (of 5,685 total)
How do you decide the logic in the Arrival/Departure column?
Nevermind, I see what you did there. Just started reviewing this, busy day.
April 8, 2011 at 1:44 pm
Chrissy321 (4/7/2011)
The max sessionID could be used for for revisions/corrections, that is get the most recent value for the specified goodthrudate assuming the last data inserted is the correct data.
Work's...
April 8, 2011 at 1:40 pm
Ninja's_RGR'us (4/8/2011)
VLDB, very long query, out of my league :http://www.sqlservercentral.com/Forums/Topic1090539-391-1.aspx
Joined in. Part of the problem is you're going to need a lot more information then this gentleman has...
April 8, 2011 at 12:06 pm
WayneS (4/8/2011)
Craig Farrell (4/8/2011)
April 8, 2011 at 12:02 pm
Sean,
There's a couple of things going on here and we're going to need some more information, unfortunately.
1) I know you mentioned this is psuedocode. We're probably going...
April 8, 2011 at 12:00 pm
I'm with the others, partitioning. Primarily because I'd like to be able to test my partitions in dev/qa BEFORE it wanders up to production, and a lot of shops...
April 8, 2011 at 1:59 am
Just to confirm, you have the pre-check option (don't have it in front of me) turned to false, correct?
April 8, 2011 at 12:14 am
CirquedeSQLeil (4/7/2011)
You mean a subscribed topics list other than what is in your user control panel on the site?
Heh, let me clarify. Use my subscribed topics list to show...
April 7, 2011 at 11:01 pm
C.K.Shaiju (4/4/2011)
Do you think that this question is only to make the candidate uncomfortable? Or is there any answer to clear this SPECIAL 🙂 situation?
Neither. It's to show the...
April 7, 2011 at 10:03 pm
Kunal,
If you take a look at the link in my first signature, it'll show you how to present the sample data/DDL in a way we can actually use it to...
April 7, 2011 at 5:39 pm
Tom.Thomson (4/7/2011)
Craig Farrell (4/7/2011)
Jeff Moden (4/7/2011)
April 7, 2011 at 5:36 pm
Yes, the Primary Key might as well be used as the clustered index in that case. The only thing it does is give you versatility for later, in case...
April 7, 2011 at 3:51 pm
CGSJohnson (4/7/2011)
April 7, 2011 at 2:32 pm
Chrissy321 (4/7/2011)
typically prefer to avoid them.
How would I avoid them? Could I...
April 7, 2011 at 12:26 pm
Hm, odd. Order of operations is division then bitwise check? Thought bitwise took precedence. Ah well, wrap it in parens then. 😉
At least you checked to confirm....
April 7, 2011 at 12:07 pm
Viewing 15 posts - 3,451 through 3,465 (of 5,685 total)