Forum Replies Created
Viewing 15 posts - 7,771 through 7,785 (of 8,416 total)
-
RE: Are the posted questions getting worse?
Hey Barry,
I'll sign up to that.
BTW, I see that Aaron has his answer. I'm not sure that he fully comprehends all the subtleties - but at least he seems...
-
RE: Bitwise operations for Check or Foreign Key Constraint
adammenkes (6/15/2009)
This looks like a pretty good solution. I will play with it.I posted that just to prove it could be done with FOREIGN KEYs - it's not a recommended...
-
RE: Locking Perf Problem: Help Update/Insert WITH table_hints
Carl,
The script I posted earlier uses a similar approach. Try it out if you get a moment.
BTW there is a dependency in your script on MASTER.dbo.Tally which I assume...
-
RE: Are the posted questions getting worse?
Idon'thavetoexplainmyselftoyou (6/15/2009)
Waaah! Waaah! Waaah! Waaah! Waaah! Waaah! Waaah!zzzzzz....
-
RE: Are the posted questions getting worse?
Jeff Moden (6/15/2009)
212,021
-
RE: Locking Perf Problem: Help Update/Insert WITH table_hints
Barry,
The script I posted takes the row-lock approach and sacrifices some measure of efficiency for concurrency. I may have missed the point with it, but we'll see what Aaron...
-
RE: Are the posted questions getting worse?
Sad
Sorry for my ... blah blah blahI assumed ... blah ... My apologies ...
Seems about fair.
Now sod off.
😀
-
RE: Locking Perf Problem: Help Update/Insert WITH table_hints
Example script attached. I hope it is fairly self-explanatory - I have run out of time again tonight.
The real world really gets in the way sometimes 🙂
Each 200-row insert...
-
RE: Are the posted questions getting worse?
Alvin Ramard (6/14/2009)
In this thread it's multiple topics and sometimes it's hard to guess the topic.
-
RE: Are the posted questions getting worse?
RBarryYoung (6/14/2009)
...or to generally disrupt normal on-topic discussion."[/i]We have normal on-topic discussions? :w00t:
Link?
😀
-
RE: Are the posted questions getting worse?
Bruce W Cassidy
[font="Verdana"]Blocked by our proxy.[/font]Bruce Cassidy = "Line Dancing Troll"
Jeff Moden = "Anal Retentive Trolly"
-
RE: Are the posted questions getting worse?
Alvin Ramard (6/14/2009)
Paul White (6/14/2009)
RBarryYoung (6/14/2009)
What shall we name it? 😛I sure won't use that tool for a troll name!!
😎
For those too busy to try it...
-
RE: Rebuilding Indexes
rob.patterson (6/14/2009)
Thanks for your help, good information! Hopefully I can return the favor sometime.Glad to help. See you around the site. 🙂
-
RE: Locking Perf Problem: Help Update/Insert WITH table_hints
Well that's a shame. I spent some time last night creating a solution for this which worked well. The final stage just involved two questions:
1. Is the...
-
RE: Are the posted questions getting worse?
RBarryYoung (6/14/2009)
What shall we name it? 😛
Viewing 15 posts - 7,771 through 7,785 (of 8,416 total)