Viewing 15 posts - 1,621 through 1,635 (of 6,216 total)
Lockwood has a product in beta. Lumignent is expensive, right up until you need it. Then it's worth every penny. Note that it doesn't just read, but allows you to...
September 11, 2003 at 12:09 pm
Not that I've seen. I typically run a different instance of QA for different connections.
Andy
September 11, 2003 at 12:06 pm
Im looking forward to seeing what they have done. We're using the product here on the site already and I know Steve uses it at work as well.
Andy
September 11, 2003 at 12:05 pm
Maybe put a computed column on the primary table and join to that?
Andy
September 11, 2003 at 12:03 pm
Our thanks as well - 500 posts adds up to a significant amount of time donated to the community!
Andy
September 11, 2003 at 12:02 pm
I'd guess that they use an internal variable and concatenate the results - since nulls propagate, you wind up with null.
Andy
September 10, 2003 at 2:30 pm
Have you rebuilt the indexes? Got an extremely high number of transactions? Thats a lot longer that what I normally see. Maybe you have subscriptions expiring that have lots of...
September 10, 2003 at 2:28 pm
Drop Brian a note (bknight@sqlservercentral.com), he can check into it for you.
Andy
September 10, 2003 at 1:41 pm
I think it depends on the environment. There are quite a few cases where I work where 1-2 developers have the ability to make changes. Eases the bottleneck, but you...
September 10, 2003 at 1:38 pm
Not exactly high end fileshares. There are several other posts about SAN's, might want to look at them. SAN's are typically highly available, high performance, and extendable. You still want...
September 10, 2003 at 1:35 pm
We've used that driver a few times for projects, often easier than CDO - depending on what you need to do of course!
Andy
September 10, 2003 at 5:06 am
Interesting. You're gaining some speed because you're reading from one and writing to the other of course. As long as they are truly separate disks that will work, not if...
September 10, 2003 at 5:03 am
Any chance the date is wrong on the machine? You've an end date set for the schedule, once it passes that the job gets disabled.
Andy
September 9, 2003 at 2:31 pm
Tons of code variations out there, but I haven't see a pure TSQL one. Even then I think you'd need sp_oacreate. I've got some ugly beta code I put together...
September 9, 2003 at 9:37 am
I'd be interested to hear other points of view on this as well.
Some thoughts:
- Im not opposed to using an indexed view or computed column, it's often a good way...
September 9, 2003 at 9:34 am
Viewing 15 posts - 1,621 through 1,635 (of 6,216 total)