Viewing 15 posts - 36,871 through 36,885 (of 39,818 total)
Upgraded from 4.2 to 6.5. I think bcp might be the easiest. Or get a couple servers and stage the upgrade from 4.2 to 6.x, then to 2000. Check the...
December 3, 2002 at 3:54 pm
Probably a DMO error. Does the script generate?
Steve Jones
December 3, 2002 at 3:53 pm
Most likely it is, but you will need to work with PSS on this one.
Steve Jones
December 3, 2002 at 3:45 pm
Having been in a similar boat, and stuck with option 1. I'd go with option 2. More flexibility and gives you the ability to easily scale out if one client...
December 3, 2002 at 9:47 am
2nd vote for SQLLitespeed. Working on a review and it is a fantastic product.
The maint plan works on days. If you say 7 days, it keeps 7 files (assuming you...
December 2, 2002 at 4:05 pm
Lot was coverend. Don't think you're under NDA, but I could be wrong.
Thanks for the update, I should have specified that the owners need to be the same SID.
Steve Jones
December 2, 2002 at 1:54 pm
numerics don't have leading 0s. you can use char if you want.
This is by convention. All numbers (in math) have an infinite number of zeros leading.
Steve Jones
December 2, 2002 at 1:50 pm
One of the MS people who works in data warehousing, mentioned that at 400 rows per sec, for inserts, the identity bottlenecks and the server has problems going above.
Not sure...
December 2, 2002 at 10:54 am
Not so clear in the request. Can you explain better what you want? If you want a user to create tables, I'd create a role, give this role the CREATE...
December 2, 2002 at 10:48 am
Nice writeup and accurate. I went to the first PASS in Chicago and this one was much better. Saw some good presentations, some average, but not that many since we...
December 2, 2002 at 10:39 am
Dont' know of any. We are talking of looking at it here when we get time.
Steve Jones
December 2, 2002 at 10:26 am
Don't use sa. Create another user and use that, give it permissions to run the job.
Steve Jones
December 2, 2002 at 10:25 am
And keep in mind that the key management is one of the more difficult pieces of this. Most PKI solutions have problems with this part (As well as key distro).
I'd...
December 2, 2002 at 10:17 am
Use a separate db. Couple reasons.
1. If you need to move this, or alter it, or add a tlog backup of it, you want it in a separate table.
2....
December 2, 2002 at 10:09 am
Some bugs with Parallelism. Bit me on one server and had to turn it off. There are some fixes in SP3 for this one.
Steve Jones
December 2, 2002 at 10:07 am
Viewing 15 posts - 36,871 through 36,885 (of 39,818 total)