Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 2,436 total)

  • RE: Windows 2003 server + SQL 2005 Memory Configuration ! Not using 7GB

    Thanks for the update in my education on SQL 2005 Chris !

    There is just so much to try and absorb. The caveats from others I consider gems !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: making a non-unique clustered index unique

    Check out this thread from another great site:

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16874

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SQLCMD vs OSQL: Missing Script errors

    ahh yes ... good old DOS command line stuff that was 'cloned' from *nix ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Management Studio Closes Down When Connecting to Server

    35 minutes for a client installation does seem a bit on the high side. I have an old IBM E-Series 330 Server (pizza box), single CPU P-III at 1.2 Gh...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: OSQL and ERRORLEVEL

    I do not think that it will. It is more of an informational message from Transact-SQL. This is one of the 'undocumented features' that has existed in SQL Server since it...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: database backup problem

    You should also check that the account that SQL Server uses also has rights. My guess is that you are testing via QA. Once things work you can then schedule...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Buying or Improving on Storage/SAN what to look out for ??

    In most instances upgrading from 10k rpm to 15k rpm disks will buy you a performance increase without doing anything else but changing those disks. Based on your application and...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Database files

    ... no problemo ... let me know what your results are and which path you took ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Buying or Improving on Storage/SAN what to look out for ??

    WOW !!! So much to ask ... This first set of questions should be asked right off:

    • How many Tb of storage do you have now ?
    • How many Tb of storage...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Database files

    If your one computer (the one you wish to move the databases from) is 'corrupt', depending on the corruption you have a few options. First I'd try to perform a Windows...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Windows 2003 server + SQL 2005 Memory Configuration ! Not using 7GB

    You may also want to add the following additional configuration parameters:

    sp_configure 'min server memory', 6144

    sp_configure 'set working set', 1       --> needs an OS reboot

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: CLUSTER Error: Could not find any IP address that this SQL Server instance depends upon???

    Have you tried a cold boot of the cluster nodes ? Have you tried evicting and readding a node ? Have you tried cluster failovers manually and by reboot ignoring...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Mind Your Manners

    Well mannered, well informed, well written, well done !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Peoplesoft International Support Upgrade

    Here's a few points off of the top of my head based on your questions:

    So, what do I need to know? Do you have room on your...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: WinServer 2003 help sites?

    Sorry ... that was my best shot ... it has usually done the trick whe I have a specific problem.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 1,066 through 1,080 (of 2,436 total)