Viewing 15 posts - 2,446 through 2,460 (of 6,216 total)
March 4, 2003 at 12:53 pm
I do not - hopefully someone else does. While possibly there is another fix, could you just make it a permanent table instead?
Andy
March 4, 2003 at 12:47 pm
March 4, 2003 at 9:28 am
March 4, 2003 at 9:24 am
March 4, 2003 at 9:22 am
DTS usually suffices, but for raw speed BCP usually the fastest, and definitely handy for situations like the one you have. Other option would be to copy image and pkey...
March 4, 2003 at 8:34 am
Putting the forum up is no problem, not too hard to add a flag to profile either, then just a matter of providing a browse/search capability. Maybe forum not the...
March 4, 2003 at 8:31 am
March 4, 2003 at 6:38 am
Not bad. Or how about a directory of those interested/available for contract work? Or both?
Andy
March 4, 2003 at 6:37 am
I think its preference. I use idents and/or uniqueidentifiers mostly. Nothing wrong with composite keys, just faster for me to type only having one col to join.
Andy
March 3, 2003 at 8:42 pm
Had any luck with this? I'd guess the answer is sorta, you've upgraded the binaries but need to get the repl objects updated. If in doubt, call MS support. Bad...
March 3, 2003 at 8:39 pm
I dont have super huge tables, but I have some with 2mil plus rows. Perf is fine. I think if you normalize and index, SQL works pretty well. Table scans...
March 3, 2003 at 8:36 pm
Not sure I follow - you're saying overall its slower, or you've narrowed it to one line in the proc? For your temp tables do you explicitly create (good) or...
March 3, 2003 at 8:34 pm
Not that I know of. Just my opinion, in most cases the names don't matter at all unless you're using index hints. Can see where it would be nice. Nicer...
March 3, 2003 at 12:16 pm
You could, but should you? If your goal is to have two columns always contain the same value, couldn't you just go with one column?! Humor aside, you could certainly...
March 3, 2003 at 12:08 pm
Viewing 15 posts - 2,446 through 2,460 (of 6,216 total)