Viewing 15 posts - 2,806 through 2,820 (of 6,216 total)
I'll grant that sub folders make sense - except that you then have to spend more time coming up with a system of distributing the files. One folder per first...
December 23, 2002 at 7:40 pm
I use blobs some, no issues. We actually use them here on the site to store all the content, then we write the asp with the content out to disk....
December 23, 2002 at 4:44 pm
I dont remember seeing one. You could probably instrument the code and use the procs that let you define your own perf counters. Ok as long as you dont drop/add...
December 23, 2002 at 4:41 pm
Is the population complete? Good? Corrupt file will give bad results, worth checking.
Andy
December 23, 2002 at 4:40 pm
Couple other ways. One is to audit for changes using Profiler (or a server side trace), the other is 3rd party, Lumigent has a schema monitor tool (think we have...
December 23, 2002 at 4:39 pm
Here is another way:
select convert(datetime, convert(varchar(12), getdate(), 101))
Andy
December 23, 2002 at 4:38 pm
What do you mean by resolve? Logins are in master, shouldnt be affected, even if db is readonly you should be able to query/access sysusers.
Andy
December 23, 2002 at 4:37 pm
Obviously permissions. You can turn on verbose logging to get more info about what is going on. The account you're using for the pull has to have access to Distribution...
December 23, 2002 at 4:36 pm
Interesting. One possibility is to 'fix' sysdepends. I don't typically replicate views, instead I'll run a post snapshot script to create other objects needed, change the indexes, etc. Reordering the...
December 23, 2002 at 4:33 pm
In SQL2K you can make them a member of the DDL_Admin role. Not much better, but a little. Truncates are logged, just at the page level - in other words,...
December 23, 2002 at 4:31 pm
December 23, 2002 at 3:58 pm
If you're applying the changes using script, just run the script against the other db's. I have 250 or so with same schema, technique I use is to actually copy...
December 23, 2002 at 6:37 am
There is an OLEDB provider you can use, either in openrowset or in a linked server (or ADO if you're coding outside of TSQL). Have to do it all yourself,...
December 22, 2002 at 4:08 pm
I like the latter solution better (mostly because I've used it before, not really a good reason!).
Andy
December 22, 2002 at 4:05 pm
The amount of on chip cache can make a huge difference too. From what I understand having a smaller cache results in more cpu flushing, decreasing performance.
Andy
December 20, 2002 at 5:56 pm
Viewing 15 posts - 2,806 through 2,820 (of 6,216 total)