Viewing 15 posts - 3,946 through 3,960 (of 5,685 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...
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...
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...
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...
February 18, 2011 at 2:38 am
Jeff Moden (2/17/2011)
February 18, 2011 at 2:21 am
Gianluca Sartori (2/18/2011)
power chords. 😛
Rockband DBA for the win!
February 18, 2011 at 2:17 am
There is only one proper hyper-caffeinated reply to to this editorial.
*BUUUUUUUUUUUUUuuuuuuuuuuuuuuuuurrrrrrrrrrrrrrrrrrrrppppp....*
February 18, 2011 at 2:16 am
tacy.highland (2/17/2011)
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...
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...
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...
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...
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...
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...
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...
February 17, 2011 at 3:27 pm
Viewing 15 posts - 3,946 through 3,960 (of 5,685 total)