Viewing 15 posts - 36,631 through 36,645 (of 39,818 total)
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
not sure what you mean? If you are in mixed mode, the "sa" account can log in. What do you mean "startup account". The SQL Service account?
Steve Jones
February 6, 2003 at 10:12 am
What is advanced data guarding? Is this RAID5? 1+0?
Sounds like a vendor term.
Steve Jones
February 6, 2003 at 10:08 am
We almost always use the websites (Google, TechNet, MSDN) first. A fair amount of senior people here, so we solve most problems in house, but we're also cutting edge with...
February 6, 2003 at 10:03 am
Not that I know of. There are some good Oracle sites, but since I don't do Oracle, I don't have any refs for you. Might try a Google search for...
February 5, 2003 at 3:33 pm
Thanks for the comment and tips. Glad you liked the article.
Steve Jones
February 5, 2003 at 3:31 pm
When you run the package in em, it runs as you. On the server it runs as SQLAgent. Log into the server as the SQLAgent account and run the package....
February 5, 2003 at 3:26 pm
Create an account, give it a role in that database, make that adtabase the default, remove guest from all other databases.
Steve Jones
February 5, 2003 at 3:24 pm
Viewing 15 posts - 36,631 through 36,645 (of 39,818 total)