Viewing 15 posts - 2,206 through 2,220 (of 6,216 total)
Look at the properties of SQL Agent. Has a place where you set the limit for jobhistory, clear existing history.
Andy
April 24, 2003 at 12:58 pm
April 24, 2003 at 12:56 pm
April 24, 2003 at 11:10 am
It's only as secure as the link. You could run over a VPN, use SSL, or both. If you only need it once a day, you could build the snapshot,...
April 24, 2003 at 11:08 am
You either have to put them in the right db role in each db, or put them in a higher level server role that would give them the permissions in...
April 24, 2003 at 9:21 am
I agree with almost all of that. In practice (in my environment anyway) I expect 90-95% of our code will be set based. Nothing wrong with using a cursor when...
April 24, 2003 at 9:20 am
If the other app has sysadmin rights, no. Otherwise only users with a valid login AND permissions can access your data. If it is just a 'plain' user and not...
April 23, 2003 at 6:45 am
Pretty much you have to test to be sure. So many factors go into determining performance.
Andy
April 23, 2003 at 6:43 am
I'd agree with that. Decent generalization is to say that inserts will be faster.
Andy
April 23, 2003 at 5:59 am
That will work as long as the process doesn't run concurrently. Because global temp tables are visible to everyone, if ran the proc twice one would fail because the object...
April 23, 2003 at 5:58 am
You can run it afterward. To enable AWE, you have to add /PAE to the boot.ini, and then run sp_configure to turn it on within SQL.
http://www.sqlservercentral.com/columnists/jsack/
Andy
April 23, 2003 at 5:51 am
Depending on the frequency of your log backups, you may want to include an explicit log backup after every x records/iterations. You may also want to 'pace' the delete so...
April 22, 2003 at 2:53 pm
If you update the stats manually when you see the slowdown does the problem go away?
Andy
April 22, 2003 at 11:15 am
My guidance to our developers is to use stored procs for all data access - unless it's dynamic sql. For those we take a look at the situation, first to...
April 22, 2003 at 8:34 am
I havent had much problem either, though spidering isn't out of the question. It's on our list of items to look at when we do the next site revision, our...
April 22, 2003 at 5:22 am
Viewing 15 posts - 2,206 through 2,220 (of 6,216 total)