Viewing 15 posts - 36,766 through 36,780 (of 39,720 total)
Never seen this one. What version of server, how much RAM? How big is the db?
Steve Jones
December 5, 2002 at 9:26 am
I've often had semi stable code with new products being released and the collisions between the production server and demo server weren't worth it.
Having a decent demo server has always...
December 5, 2002 at 9:22 am
Nice article and good points.
In most businesses, IT does support the business. Exceptions occur, like my company, JD Edwards, where we build software. In this case, part of IT is...
December 3, 2002 at 4:01 pm
LogExplorer could grab this if you know when the db was created and have the tlog from that date.
Or go back to a backup from that date
Steve Jones
December 3, 2002 at 3:57 pm
You could load it up.
Alternatively, enclose all table and field names in [], which will allow you to use reserved words.
Steve Jones
December 3, 2002 at 3:57 pm
do you mean without headers? You can use DTS to grab data out.
Steve Jones
December 3, 2002 at 3:56 pm
Check rights as well. Might be an NT rights issue.
Steve Jones
December 3, 2002 at 3:55 pm
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
Viewing 15 posts - 36,766 through 36,780 (of 39,720 total)