Viewing 15 posts - 1 through 15 (of 58 total)
Thanks. I did find this article, and it's pretty good. -
http://www.quest-pipelines.com/newsletter-v5/0204_B.htm
The only thing is I want to see how to find the current fill factor size? This is because the...
January 16, 2007 at 5:13 pm
couldn't agree with you any more. What do you suggest then?
January 12, 2007 at 4:33 am
Thanks guys. I'll try that. I also found a really cool example at http://www.sql-server-performance.com/dp_no_cursors.asp
Cheers
January 12, 2007 at 12:27 am
Thanks guys, its been very informative. Seems like most of us rely on the native SQL server backups more than the SAN based snapshots.
This is very interesting cuz it puts...
December 28, 2006 at 4:05 pm
So, do you reckon if we weren't truncating the transaction I could actually use the traditional method without stuffing up anything in regards to DRP?
December 20, 2006 at 11:36 pm
Yep, by traditional methods I meant the native SQL backup method.
we truncate the log immediately after taking a snapshot, to avoid the transaction log from filling up and in turn...
December 20, 2006 at 6:35 pm
Hey John,
We've currently got SAN installed at our office and to tell you the truth, havn't seen much of a difference.
In regards to your question about RAID - the one...
December 20, 2006 at 5:22 pm
My server is a production server, and I don't think it is a good idea to keep reinstalling client tools on it.
Any ideas for fixing this while the server is...
November 30, 2006 at 9:27 pm
Thanks for the ideas guys,
It is a shame that after putting in such latest technology to do SAN level replication and then can't use it at the moment because of...
November 26, 2006 at 3:07 pm
Thanks Brian. I have been able to sucessfully unsintall SQL default instance and install a retail version of SQL server 2000 Standard Edn.
November 15, 2006 at 4:41 pm
Thanks Guys. This discussion has been great.
I am keeping a list of all passwords in a secure place, but didn't know I could use CIO's/CFO's safe as well
November 12, 2006 at 5:01 pm
And yes, the SQL service was actually set to run under an account in the old domain.
Thanks heaps guys - you've given me a lot of insight to this.
Btw,...
November 9, 2006 at 5:10 pm
I just realised what has actually happened! I had installed the evaluation copy of SQL server on it as we didn't have a licencse for this one.
Any ideas how...
November 9, 2006 at 5:05 pm
The problem is that since this was a test server, there is no other account with the same priviledges as sa account.
The sys admin team let me get on...
November 8, 2006 at 2:37 pm
How can I ensure that I have exclusive access to the database? I know that we will have to kill the active processes, but how to be sure that the...
November 1, 2006 at 5:29 pm
Viewing 15 posts - 1 through 15 (of 58 total)