Viewing 15 posts - 3,946 through 3,960 (of 5,678 total)
GilaMonster (2/18/2011)
Craig Farrell (2/18/2011)
Stefan proved to me he's a much better abuser of fools than I am. May I request recruiting his assistance? 🙂
No! Leave Lennie alone. We don't...
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
February 18, 2011 at 2:52 am
Two drives are RAID 0 or 1, Three minimum for RAID 5. Why:
Raid 1 is a mirror. 1 drive worth of data with two drives involved.
Raid 5 is...
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
February 18, 2011 at 2:43 am
Koen Verbeeck (2/18/2011)
Gianluca Sartori (2/18/2011)
Do you remember Lennie, the guy with sock-puppets friends?He's back again. Nothing worth worrying about, at the moment.
http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx
I just read the thread you linked to in...
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
February 18, 2011 at 2:40 am
Jeff Moden (2/17/2011)
Craig Farrell (2/16/2011)
and we haven't gotten to 8/2/2011 yet (I read it as 2010 for some reason) so yes, it's after an hour ago... LOL
DD/MM/YYYY 😉 It'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
February 18, 2011 at 2:38 am
Jeff Moden (2/17/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
February 18, 2011 at 2:21 am
Gianluca Sartori (2/18/2011)
power chords. 😛
Rockband DBA for the win!
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
February 18, 2011 at 2:17 am
There is only one proper hyper-caffeinated reply to to this editorial.
*BUUUUUUUUUUUUUuuuuuuuuuuuuuuuuurrrrrrrrrrrrrrrrrrrrppppp....*
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
February 18, 2011 at 2:16 am
tacy.highland (2/17/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
February 17, 2011 at 7:56 pm
We'd need to see the execution plans for the queries to really help you here. If you need some help doing that the link in my sig for index/tuning...
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
February 17, 2011 at 4:34 pm
tacy.highland (2/17/2011)
Oh Craig, this is so close. I may not necessarily understand it right off the bat, but it looks so close.
Let's fix that before we continue, or 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
February 17, 2011 at 4:30 pm
Then your code should work. In the MyTable DDL, is [date] a field type of DATETIME, or is it VARCHAR() or something else?
There's no other reasons that code should...
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
February 17, 2011 at 4:14 pm
Can you run this in a separate query window and tell me if you get one, or two, records back?
IF OBJECT_ID('tempdb..#MyData') IS NOT NULL
DROP TABLE #MyData
CREATE TABLE #MyData
([Date] DATETIME)
INSERT INTO...
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
February 17, 2011 at 3:40 pm
ehlinger (2/17/2011)
Craig, in your opinion could I use the Lookup or Merge Join transforms to compare between the source and the target? If so, which...
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
February 17, 2011 at 3:35 pm
Jole84 (2/17/2011)
Craig Farrell (2/17/2011)
If you're using my sample data/build, there's no records in the last 14 days then there was in the last hour, so that's correct.
If you're using your...
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
February 17, 2011 at 3:28 pm
Are all the tables in the script on the foreign server? Does the linked server user have the necessary security to see the statistics on the tables to create...
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
February 17, 2011 at 3:27 pm
Viewing 15 posts - 3,946 through 3,960 (of 5,678 total)