Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: SQL server stops responding

    Glen (10/6/2008)


    Default is 1024. I don't really know why did you change it to begin with...

    That is a good question, I do not recall changing it manually and did...

  • RE: SQL server stops responding

    Thank you guys for hints - I'll continue digging.

    One question:Clients of our sql server perform a lot of very small queries. Every time they connect and disconnect, basically Login/Logout number...

  • RE: SQL server stops responding

    Jason Shadonix (10/6/2008)


    Do you have any 3rd party backup/audit/etc. tools running on that box (Idera, RedGate, Apex, TSM, etc)?

    The only thing we have running is Symantec Backup Exec. But according...

  • RE: SQL server stops responding

    Thx for suggestions.

    However, I'm a bit concerned about lowering a memory. OS itself is very responsive during a problem. All counters within normal range. Page/Sec is 0.

    Why do you think...

  • RE: SQL server stops responding

    Glen (10/6/2008)


    Do you have AWE enabled?

    Can you verify the size and location of a paging file?

    What is the version of Windows server? (standard, Ent.)

    Yes, AWE is enabled

    Paging file is...

  • RE: SQL server stops responding

    Thanks for quick response, Glen!!!

    Glen (10/6/2008)


    Do you have /3GB switch in boot.ini?

    /3GB is not in boot.ini - MS help desk says this is not required on 64bit platforms.

    Glen...

  • RE: What is it waiting for

    I'd start from analyzing Wait Statistics and Locks.

  • RE: Searching Names with '

    I might simply double it like

    O''leary

  • RE: Using BCP and formatting Data

    I guess the easiest way would be to create a view or SQL statement which trims all those spaces and formats date like you want.

    After that specify it like a...

  • RE: List of tables and size

    You can use SQLExecMS.

    Use Tools|Space Usage in main menu.

  • RE: Assigning Column default value as another Column

    Since DEFAULT for column is defined as constant_expression then the only way to do it will be insteadof trigger.

  • RE: Why, I don't want it.

    Ok then,

    could you tell me what is better to have

    exculsive KEY lock or exlusive RID lock?

  • RE: Why, I don't want it.

    Here is the plan for nonclustered:

    |--Table Update(OBJECT:([od_Test].[dbo].[A]), SET:([A].[TWO]=[Expr1004]))

    |--Top(1)

    |--Compute Scalar(DEFINE:([Expr1004]=Convert([@1])))

    ...

  • RE: How do I copy a SQL database?

    If there is ability to shut DB down then:

    1.detach from orginal server

    2.copy file(s) to new server

    3.attach_db on new server

    4.attach_db on original server

Viewing 14 posts - 1 through 14 (of 14 total)