Viewing 15 posts - 3,451 through 3,465 (of 5,678 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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 8, 2011 at 12:06 pm
WayneS (4/8/2011)
Craig Farrell (4/8/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 7, 2011 at 5:39 pm
Tom.Thomson (4/7/2011)
Craig Farrell (4/7/2011)
Jeff Moden (4/7/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 7, 2011 at 3:51 pm
CGSJohnson (4/7/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 7, 2011 at 2:32 pm
Chrissy321 (4/7/2011)
typically prefer to avoid them.
How would I avoid them? Could I...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 7, 2011 at 12:07 pm
Viewing 15 posts - 3,451 through 3,465 (of 5,678 total)