Viewing 15 posts - 36,526 through 36,540 (of 39,720 total)
I think this will cause an issue. Can you not take a full backup and move that over after the new file?
Steve Jones
February 7, 2003 at 9:38 am
If they rarely change, I'd put them in each db and then use an app, script, or possible replication to update them.
If they change often, I'd probably use a master...
February 7, 2003 at 9:31 am
Probably that's it. Covers two drives failing before the spare gets going.
If you get it for no $$, might as well. Buy 5-8 drives for your main array, 2 more...
February 6, 2003 at 5:46 pm
Still won't protect the code from someone getting to it. Anything can be decompiled.
Steve Jones
February 6, 2003 at 5:42 pm
not sure what you mean? are you replying to the article or a post?
Steve Jones
February 6, 2003 at 5:39 pm
And intellisense!!!!!
Send suggestions to sqlwish@microsoft.com
Steve Jones
February 6, 2003 at 2:14 pm
Depends on the performance. I'd simulate the 10M rows and see, but my thought is one table/month. If the db performance is too low, separate DBs or even filegroups can...
February 6, 2003 at 2:03 pm
Like Raid 5 +.
Here's the FAQ:http://h18004.www1.hp.com/products/servers/proliantstorage/arraycontrollers/adg/questionanswer.html
Looks like the space usage for parity is 2 drives and is worth it above 5 drives. Basically appears to be items.
1. Allows 2 drives...
February 6, 2003 at 2:00 pm
Pause does that. Let's everyone finish, no new connections. I think in your job, if it makes one connection, could pause the server, kill connections in the db, run the...
February 6, 2003 at 11:08 am
Possible tape issue. Have you changed tapes? Can you manually run a backup? Perhaps out of space on the tape?
This is the OS reporting and error. I never backup straight...
February 6, 2003 at 11:06 am
Do you have other databases on this server? If not, you can "pause" the server
Steve Jones
February 6, 2003 at 10:59 am
You'd have to use sp_oaCreate to create an ActiveX object. You could use the MS HTTP control and then have it execute the ASP page.
Steve Jones
February 6, 2003 at 10:57 am
Write a stored procedure to delete these.
something liek
delete x
where x.datetimefield < dateadd( y, -1, getdate())
Then schedule this to run every day or week, depending on what you need.
Steve Jones
February 6, 2003 at 10:46 am
Wow. Not sure I've seen a worse one. Granting rights to public is BAAAAADDDDDD!
Steve Jones
February 6, 2003 at 10:15 am
Viewing 15 posts - 36,526 through 36,540 (of 39,720 total)