Viewing 15 posts - 1,456 through 1,470 (of 1,790 total)
Wow, quite a configuration. I don't know that there is a definitive answer to your question until you talk to your vendors in all cases. However, I can say that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 8, 2003 at 7:02 am
The permissions you gave look fine and that is probably what I would have done. If I could though I would try to get more specific to see what he...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 8, 2003 at 6:51 am
Thanks to all for the great comments on this. SQLBill brings a great point with the clustering issue and my configuration falls into that realm. Still not sure whether I...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 8, 2003 at 6:45 am
This looks like a pretty good hit from the MS site however, it is not a perfect match. It appears that this workaround may help though.
http://support.microsoft.com/default.aspx?scid=kb;en-us;815008
I will be interested...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 7, 2003 at 7:52 am
That is the only way that I know to change the settings for the server. Not entirely positive but I believe any database created prior to the rebuild of the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 7, 2003 at 7:31 am
Did you add the 3G switch in the boot.ini? Once you set that and reboot you should see the memory that SQL Server allocates increase.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 7, 2003 at 7:22 am
Is there an index forcing a sort on the data? That is the only thing that I can think of.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 30, 2003 at 2:35 pm
I am assuming that you want to change collations in your migration. If so, then yes it is possible if you are running SQL Server 2000. Not sure off the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 30, 2003 at 10:18 am
I should have stated in my first post that I am openly opposed to rebooting my SQL Servers. I am just looking for more weight to my arguments. Thanks.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 11, 2003 at 7:12 am
Did you try opening it up from another computer (i.e. another Client Tools installation)? If so, how are your msdb backups? I can't think of anything other than a restore...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 5, 2003 at 11:40 am
My GUESS is that the login that owns the object is no longer the owner of the database. Being that it is no longer the owner of the DB, the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 5, 2003 at 5:36 am
Decent Q&A is given at the following link (may be information here as well)
http://www.sql-server-performance.com/q&a38.asp
You may also want to have the Server Engineer check the stripe size and make sure that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 5, 2003 at 5:30 am
Definitely do the backups, save a copy of all the DTS packages, script out the jobs and the logins with passwords (Steve Jones has an article on the site for...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 5, 2003 at 5:19 am
Frank,
I can only speak for myself and I would say I could be looking for both. There are some times when it would not be fair to bring along an...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 4, 2003 at 10:01 am
I would also agree on the relocation and the travel to the site for the interview. If a phone interview went well and they felt there was a strong potential...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 3, 2003 at 11:30 pm
Viewing 15 posts - 1,456 through 1,470 (of 1,790 total)