Forum Replies Created

Viewing 15 posts - 886 through 900 (of 49,552 total)

  • RE: Function giving subquery returned more than 1 value, this is not permitted.....error

    Newbi - Friday, August 18, 2017 1:44 AM

     But will It actually store in PayConfirmTbl? For example if I want to use...

    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

    August 18, 2017 at 1:51 am

    #1955768

  • RE: Arrays In SQL Server

    vincentshanecurtis - Friday, August 18, 2017 1:18 AM

     Each one of these 3 character keys is for a separate record in a junction...

    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

    August 18, 2017 at 1:35 am

    #1955765

  • RE: Arrays In SQL Server

    Look at table-valued parameters.

    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

    August 18, 2017 at 1:17 am

    #1955762

  • RE: Problem with NEWID (point of evaluation)

    What are you trying to do?
    NewID returns unique guids, different one every time it's called.

    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

    August 18, 2017 at 1:16 am

    #1955761

  • RE: Function giving subquery returned more than 1 value, this is not permitted.....error

    Formatted so that it's actually readable.

    ALTER FUNCTION fn_PayrollConfirm (@EmpID INT)
    RETURNS @PayrollConfirm TABLE (
      PayslipID INT IDENTITY(1, 1),
      EmpID INT,
      ...

    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

    August 18, 2017 at 1:15 am

    #1955760

  • RE: Trying to determine what might be causing skipped values in an IDENTITY column

    Rod at work - Thursday, August 17, 2017 12:08 PM

    Now this is very interesting. That would explain that huge gape easily. Would...

    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

    August 17, 2017 at 12:10 pm

    #1955710

  • RE: Trying to determine what might be causing skipped values in an IDENTITY column

    Rod at work - Thursday, August 17, 2017 11:56 AM

    Phil Parkin - Thursday, August 17, 2017 11:35...

    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

    August 17, 2017 at 12:01 pm

    #1955703

  • RE: Trying to determine what might be causing skipped values in an IDENTITY column

    Phil Parkin - Thursday, August 17, 2017 11:35 AM

    Could it be this?

    Very likely.
    Essentially, SQL has a cache of identity values,...

    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

    August 17, 2017 at 11:52 am

    #1955700

  • RE: Enormous Page Life Expectancy (PLE)?

    mmcardle - Thursday, August 17, 2017 11:10 AM

    Does this mean the infrastructure team will be saying I should drop the amount...

    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

    August 17, 2017 at 11:45 am

    #1955697

  • RE: SQL Database corruption issue

    Yes. Data was lost.

    Repairing, especially with allow_data_loss, is a last resort for when there's no other way of fixing things. Best method is to restore from a clean...

    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

    August 17, 2017 at 10:08 am

    #1955684

  • RE: Enormous Page Life Expectancy (PLE)?

    Why is that a problem?

    And no, 'a comfortable value is apparently 24 / 4 * 300 = 1800 seconds or 30 minutes', is not a comfortable level,...

    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

    August 17, 2017 at 10:05 am

    #1955682

  • RE: SET NOCOUNT ON at instance level - not working.

    SQLearner@vgrover - Wednesday, August 16, 2017 11:45 PM

    1. Whenever, we code execute commands in SSMS. It doesn't matter what user option is...

    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

    August 17, 2017 at 1:00 am

    #1955616

  • RE: Can I restore a single file .mdf to multiple files spread across disks

    Arsh - Wednesday, August 16, 2017 1:56 PM

    See how much free space you have in the database. If it's huge and 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

    August 16, 2017 at 11:09 pm

    #1955607

  • RE: Stored completion recompile and number of rows in underlying table

    http://www.sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/

    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

    August 16, 2017 at 1:27 pm

    #1955561

  • RE: The Multi-Part Identifier 'UDF-Name' Cannot Be Bound.

    Sue_H - Wednesday, August 16, 2017 11:45 AM

    I didn't go through all of it - just the first use of 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

    August 16, 2017 at 12:04 pm

    #1955551

Viewing 15 posts - 886 through 900 (of 49,552 total)