Forum Replies Created

Viewing 15 posts - 7,291 through 7,305 (of 49,552 total)

  • RE: Restore db without ldf file, special case db was shutdown in mid tranaction

    You do need the log file. That's what the error message is telling you, the log file is not an optional part of the database.

    Restore from your last good 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

    November 15, 2014 at 6:06 am

    #1758793

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    cphite (11/14/2014)

    What purpose does making it mandatory actually serve?

    Simplifies the parser, makes it easier to extend the language. T-SQL's getting to the point where it's hard for the parser to...

    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

    November 15, 2014 at 5:18 am

    #1758788

  • RE: new 2014 implementation

    mfriessnig (11/13/2014)

    We are going to have 2 pyhscial processors that are dual core with 8 gig of memory.

    Does this config sound good?

    I think my cell phone has more than 8GB...

    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

    November 14, 2014 at 10:18 am

    #1758682

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Jason-299789 (11/14/2014)

    MS could help the situation by having its tools like SSMS and SSDT require it at compile time.

    SSMS doesn't have a T-SQL compiler. When you ask for a piece...

    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

    November 14, 2014 at 9:35 am

    #1758662

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Jason-299789 (11/14/2014)

    Gail/Lynn/Ed,

    I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like they do in C#/C++...

    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

    November 14, 2014 at 8:36 am

    #1758632

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Lynn Pettis (11/14/2014)

    Can't remember it off the top of my head, but there is another statement added in SQL Server 2014 that states the same requirement, the preceding statement must...

    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

    November 14, 2014 at 8:27 am

    #1758621

  • RE: Is there a rule of thumb for number of rows in the partition for a very large table

    sql_er (11/14/2014)

    The main goal at the moment is to ensure that when a monthly report goes out we can get the data out fast.

    Then stop wasting your time looking at...

    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

    November 14, 2014 at 8:18 am

    #1758616

  • RE: cte performance issue

    Table definitions, index definitions and execution plan 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

    November 14, 2014 at 7:00 am

    #1758559

  • RE: Adding SQL Server 2014 node to SQL Server 2008 R2 cluster

    GraveD (11/14/2014)

    Does the scenario look real?

    If by 'some time' you mean 'a few minutes', then yes. Otherwise no.

    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

    November 14, 2014 at 6:51 am

    #1758556

  • RE: Proc giving error in one sesison and runs in another

    sqlnaive (11/14/2014)

    And the name #Temp1 is taken here just for the example. Actually following naming convention.

    Ok, so the posted code is not the code that's failing, but an edited version...

    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

    November 14, 2014 at 6:37 am

    #1758549

  • RE: Proc giving error in one sesison and runs in another

    In the other session (where it doesn't run), is there an existing temp table created with matching names? You won't get a create table error if there is, SQL uniquifies...

    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

    November 14, 2014 at 5:09 am

    #1758514

  • RE: SQL 2014 AG Replica to a 2012 Primary

    slim.richard (11/13/2014)

    I am trying to add a 2014 replica to a 2012 primary availability group and am trying to understand if this is a supported setup.

    Only supported as part of...

    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

    November 14, 2014 at 3:59 am

    #1758495

  • RE: Is there a rule of thumb for number of rows in the partition for a very large table

    Ok, so what's the goal of the partitioning? Fast load? Parallel load? Index rebuilds at the partition level? Partition switching for archive/delete of old data?

    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

    November 14, 2014 at 3:57 am

    #1758493

  • RE: Heap or clustered, What to do ...

    Luis Cazares (11/13/2014)

    g.britton (11/13/2014)

    SeanNerd (11/13/2014)

    My question is about indexing strategy for the following scenario:

    I have a table where we cannot use the typical int identity primary key column. The table...

    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

    November 14, 2014 at 3:55 am

    #1758492

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Jason-299789 (11/14/2014)

    The problem is that 90% of developers don't use the ';' on every line of code

    .Well they should start doing so .The trend over the last few versions 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

    November 14, 2014 at 3:54 am

    #1758491

Viewing 15 posts - 7,291 through 7,305 (of 49,552 total)