Viewing 15 posts - 5,071 through 5,085 (of 9,707 total)
Ninja's_RGR'us (11/17/2011)
Dev (11/17/2011)
I did my best to explain why it should not be used and was met with the same response. I got on the phone about 10...
November 17, 2011 at 4:42 am
Remember the guy with the missing CPUs?
I figured out what his problem is: Tech Support Response[/url]
November 16, 2011 at 12:47 pm
Dev (11/16/2011)
Now I'm curious. Since when is the use of NOLOCK a best practice?
This is cross-question. This is what I suggested to Ashu. 😀
But what I am saying...
November 16, 2011 at 9:44 am
Ninja's_RGR'us (11/16/2011)
CIA is intechangable with many agencies! 😉
Dangnabbit! You caught me. Yes, I do work for the Celestial Intervention Agency...
Darned humans. You're too clever by half.
November 16, 2011 at 9:39 am
SQLRNNR (11/16/2011)
Brandie Tarvin (11/16/2011)
L' Eomot Inversé (11/16/2011)
Ninja's_RGR'us (11/16/2011)
http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx
GilaMonster (11/16/2011)
ashuthinks (11/16/2011)
please let me know my usage is at...
November 16, 2011 at 9:36 am
Do you have the authority and control to completely rewrite this process?
If so, I urge you to to move the updates, inserts and deletes to a completely different ETL process...
November 16, 2011 at 9:33 am
Dev (11/16/2011)
ashuthinks (11/16/2011)
@gila yes sir...i knew that if i don't use NOLOCK i will definitely get a deadlock so for successful
execution i need to use NOLOCK
You are...
November 16, 2011 at 9:30 am
L' Eomot Inversé (11/16/2011)
Ninja's_RGR'us (11/16/2011)
http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx
GilaMonster (11/16/2011)
ashuthinks (11/16/2011)
i.m just using this stored procedure for reporting purpose..please let me know my usage is at right or not?
Since...
November 16, 2011 at 9:28 am
You're welcome. Did you figure out what the issue was yet? I'd love to hear the details if you have them.
November 16, 2011 at 5:01 am
But this is The Thread. Nothing on The Thread is supposed to make sense!
@=)
November 16, 2011 at 4:59 am
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/15/2011)
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...
Same here.
No offense if I forgot anything else. I didn't reread the whole 2 weeks either...
November 16, 2011 at 4:52 am
Jim Murphy (11/15/2011)
Stefan Krzywicki (11/15/2011)
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
Awesome! Congratulations. (Sorry, I'm catching up on the thread, but this...
November 15, 2011 at 12:14 pm
Try turning the Unit Separators into filler columns.
I knew it was going to lose the column data. I thought I'd mentioned it, but I apologize if I didn't.
November 15, 2011 at 12:02 pm
Sorry, I don't know Hex, so I can't translate {1F} into a character I would understand.
I will suggest changing your connection manager from a Delimited to a Ragged Right (you'll...
November 15, 2011 at 8:47 am
Ninja's_RGR'us (11/15/2011)
and if you can't laugh at yourself... well we can :-P.
Hee.
November 15, 2011 at 8:00 am
Viewing 15 posts - 5,071 through 5,085 (of 9,707 total)