Viewing 15 posts - 36,526 through 36,540 (of 39,771 total)
I agree that 2mil isn't a huge number, especially when you're probably querying for a single row most of the time for products. If not, then you should have some...
March 5, 2003 at 10:48 am
I think the optimizations rebuilds all indexes and marks them as "changed". Therefore they will be included in a differential backup.
Steve Jones
March 5, 2003 at 10:44 am
Create the stored procedure on the remote server and call it from your local server.
Steve Jones
March 5, 2003 at 10:42 am
I agree with Antares. You need another 4 licenses. Is this a web server backend? If so, why do you need another instance?
Steve Jones
March 5, 2003 at 10:37 am
Thanks. Never had a db with no owner, though that procedure makes sense.
Steve Jones
March 5, 2003 at 10:19 am
March 3, 2003 at 5:12 pm
Why can you not use an identity?
Also, does the number need to be generated in the select?
Steve Jones
March 3, 2003 at 5:11 pm
Kind of confusing. Can you provide an example of what you mean?
Steve Jones
February 26, 2003 at 10:24 am
xp_cmdshell 'dir c:' will get you this, but you have to parse.
Steve Jones
February 26, 2003 at 10:09 am
SP3 will upgrade MDAC to 2.71
No issues really. The application of the SP3 should not affect the SQL 7 instance.
Steve Jones
February 26, 2003 at 10:00 am
Shouldn't affect anything, but will be easier to read. (and type)
Steve Jones
February 25, 2003 at 1:22 pm
Part 2 will look at separate tables.
Interesting thought about the sequence table.
Steve Jones
February 25, 2003 at 1:19 pm
Not sure if the end users will get hit. Appears to be more for ISVs who resell code.
The articles haven't really run detsails.
A 2nd article at http://news.com.com/2100-1001-985359.html
Steve Jones
February 25, 2003 at 1:12 pm
Correct, no SP2 required.
Read the README and test.
Steve Jones
February 24, 2003 at 11:19 am
Viewing 15 posts - 36,526 through 36,540 (of 39,771 total)