Forum Replies Created

Viewing 15 posts - 42,241 through 42,255 (of 49,552 total)

  • RE: copy a table from one databaseon one server to another database on another server

    Please don't repost a question that people are working on. It just leads to redundant replies and means people will waste their time answering questions that have already been answered.

    Please...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 8:16 am

    #915332

  • RE: copy a database from one server to another server

    Your original question asked how to copy a database.

    Do you need to copy an entire database or a single table within a database?

    If the latter, is there a linked...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 7:59 am

    #915309

  • RE: Multi line Table-value function much slower then executing body SQL (2008)

    Peso (12/19/2008)

    Not even with SQL Profiler?

    You can get every statement within the function there.

    True, though that's a hellishly painful way to get execution plans.

    I need to check and see if...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 7:35 am

    #915286

  • RE: Multi line Table-value function much slower then executing body SQL (2008)

    ddorfman (12/19/2008)

    Thanks

    How to i get the actual execution plan of running just a TVF

    You don't. 🙁

    Take the contents of the function, put in management studio, declare variables in place...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 7:14 am

    #915258

  • RE: Min/Max Server Memory

    Perry Whittle (12/19/2008)

    assuming it is released quick enough

    Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim, unless...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 7:05 am

    #915242

  • RE: copy a database from one server to another server

    Backup the database

    Copy the backup file to the other server

    Restore the backup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 7:01 am

    #915234

  • RE: Investigating Deadlocks - Need help!

    Russell.Taylor (12/19/2008)

    One of the other DBA's set the traceflag to log all dealocks to the error log as the Deadlock Graphs generated via the alert we have setup are not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 7:00 am

    #915233

  • RE: Multi line Table-value function much slower then executing body SQL (2008)

    Chris Morris (12/19/2008)

    It's a longshot, but have you tried putting this little lot into a sproc and running the results into a prepared table?

    CREATE TABLE...

    INSERT INTO ... EXEC ...

    That's very...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 6:59 am

    #915232

  • RE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK)

    Swirl80 (12/19/2008)

    out of curiosity, from a performance point of view, which is better:

    As I said above, they are identical in meaning and in effect.

    Neither is desired for performance reasons. If...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 6:52 am

    #915217

  • RE: Min/Max Server Memory

    Perry Whittle (12/19/2008)

    just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt.

    Lock pages just means that the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 6:52 am

    #915215

  • RE: Replacement of xp_cmdshell

    When you create the job step, set the type to OS command. They type in the OS commands that you need.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 3:23 am

    #915075

  • RE: Min/Max Server Memory

    Mani (12/18/2008)

    Now, we would like to set the Min and Max Memory settings. Could you please advice me what will be the best values considering 16GB RAM and also...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 3:12 am

    #915073

  • RE: Transactions deadlock

    nKognito (12/19/2008)

    Understood. But what 2nd one will do at the end of 1nd? Will update the next record that matches to the condition or will not do anything?

    It will update...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 3:11 am

    #915072

  • RE: I want a solution of this

    I'm not sure I understand. Please can you post table structure (as create), sample data (as inserts) and your desired output. Read this to see the best way to post...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 12:53 am

    #915020

  • RE: Information needed on locks

    Why would (3) lead to a deadlock?

    Have you read through the sections in Books Online on locking?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 19, 2008 at 12:52 am

    #915019

Viewing 15 posts - 42,241 through 42,255 (of 49,552 total)