Viewing 15 posts - 35,971 through 35,985 (of 39,771 total)
SQL will leave memory for the OS, but the deallocation and reallocation can be (relatively) slow sometimes. If you have concerns or issues, you should set it.
Hard to determine exactly...
September 9, 2003 at 10:34 am
I think that you want to setup the transform as anm ActiveX task and then use the CHR() function in the VB Script.
Steve Jones
September 9, 2003 at 10:08 am
I'd use roles, transfer the permission to the role and grant to both users.
Steve Jones
September 9, 2003 at 10:04 am
This is always a little kludge and I haven't seen any great ways to do it. Embarkadero's ER/Studio would do some as would one of FMS Software's products. Not sure...
September 9, 2003 at 10:03 am
The alter statement will not update a date, but it will update the base_schema_ver. You'd have to know the previous versions, but this goes up by 16 with each ALTER.
Steve...
September 9, 2003 at 9:57 am
Frank is correct. There is no benefit to the order of the tables in the statement. This is different from Oracle I believe.
The optimizer considers the request and may reorder...
September 9, 2003 at 9:55 am
Nice. You might want to add this to the scripts section.
Steve Jones
September 9, 2003 at 9:53 am
It's a bad idea in general because SQL is competing with other applications for resources. You tend to separate your database from the applications.
That being said, it's not horrible in...
September 9, 2003 at 9:52 am
It seems to flake sometimes, but not consistently. Is this a consistent or intermittent problem? Is it on all pages?
Steve Jones
September 9, 2003 at 9:47 am
Never been a farmer, suburban boy, but now live on 2 1/2 acres and my wife wants a horse, so I guess I'm about to learn a few things.
Steve Jones
September 8, 2003 at 11:57 am
I guess it depends on the setup of their server, but it's possible this might cause them issues.
However, I'd dispute this and then ask that they upgrade their server...
September 8, 2003 at 11:55 am
Have you scrolled down and to the side? These forums sometimes flip out.
Steve Jones
September 8, 2003 at 11:54 am
Used Embarkadero at a previous job. Liked the ER/Studio, didn't like the Rapid SQL or DBArtison, but this was like 4 years ago.
Visio occassionally, but at this point, I tend...
September 8, 2003 at 10:10 am
Prior to a fulltime DBA, managed IT for a small (< 50 people) company. Prior to that,
software developer
network admin (Novell/DOS/Windows)
Bartender
Waiter
Knucklehead in college
Steve Jones
September 8, 2003 at 10:07 am
I agree that you'd want to check with a Sybase person, but I'd be skeptical of these claims. If there is no access other than inserts, any RDBMS should be...
September 8, 2003 at 10:05 am
Viewing 15 posts - 35,971 through 35,985 (of 39,771 total)