Forum Replies Created

Viewing 15 posts - 3,916 through 3,930 (of 8,753 total)

  • RE: RECREATE AN ID OF A ROW AFTER BEING DELETED

    GilaMonster (1/20/2016)


    My question would be 'why'?

    +1

    😎

    Didn't want to open that Pandora's box

  • RE: Find Latest Date from Multiple Columns

    Eric M Russell (1/20/2016)


    Here you go. It's entirely possibly for multiple rows, or multiple columns within the same row, to tie for having highest date, so it will potentially return...

  • RE: Clustered Index Scan

    GilaMonster (1/20/2016)


    Table definition, index definitions and execution plan please.

    But first, is the query really a problem?

    Sorry Gail, didn't see your post, makes mine look kind of daft:-P

    😎

  • RE: Clustered Index Scan

    bebe022476 (1/20/2016)


    How to optimise the following query, it's doing a Clustered Index Scan (Clustered).

    select document.DocumentID as 'document.document.id',

    document.DocFolderID as 'document.document.folderID',

    document.FileName as 'document.document.description',

    document.FileSize as 'document.document.fileSize',

    document.ModifiedDate as 'document.document.modifiedDate',

    document.TableName as 'document.document.tableName',

    document.EntityCode as 'document.document.entityCode'

    from...

  • RE: Find Latest Date from Multiple Columns

    below86 (1/20/2016)


    You could use something like this to just find the max date of those columns, it won't get you the column name though. I found this on another...

  • RE: RECREATE AN ID OF A ROW AFTER BEING DELETED

    abdellahmoh2016 (1/20/2016)


    HI ALL

    I'm new in T-SQL so i need your help

    My problem is : After deleting a row , is there a way to retrieve the ID of that row...

  • RE: Find Latest Date from Multiple Columns

    Jacob Wilkins (1/20/2016)


    If all we care about is the max date for each ID, it should be close between those and the CASE, if the CASE version is also modified...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/20/2016)


    Brandie Tarvin (1/20/2016)


    Eirikur Eiriksson (1/20/2016)


    Alvin Ramard (1/20/2016)


    Ed Wagner (1/20/2016)


    Steve Jones - SSC Editor (1/20/2016)


    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything...

  • RE: Are the posted questions getting worse?

    Phil Parkin (1/20/2016)


    Eirikur Eiriksson (1/20/2016)


    Grant Fritchey (1/20/2016)


    Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently...

  • RE: Are the posted questions getting worse?

    GilaMonster (1/20/2016)


    Eirikur Eiriksson (1/20/2016)


    Alvin Ramard (1/20/2016)


    Ed Wagner (1/20/2016)


    Steve Jones - SSC Editor (1/20/2016)


    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

  • RE: Are the posted questions getting worse?

    Alan.B (1/20/2016)


    Eirikur Eiriksson (1/20/2016)


    Alvin Ramard (1/20/2016)


    Ed Wagner (1/20/2016)


    Steve Jones - SSC Editor (1/20/2016)


    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/20/2016)


    Ed Wagner (1/20/2016)


    Steve Jones - SSC Editor (1/20/2016)


    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length....

  • RE: Time and Space: How to Monitor Drive Space in SQL Server

    Ed Wagner (1/19/2016)


    Eirikur Eiriksson (1/19/2016)


    Nice write-up Ed, good job!

    😎

    Just to mention, xp_fixeddrives is very handy for doing a quick check.

    Thanks, Eirikur. Yes, there are many approaches to getting the...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/20/2016)


    Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

  • RE: Lock Owner Blocks

    Ed Wagner (1/20/2016)


    I love the internals stuff. I'm currently reading SQL Server 2012 Internals by Kalen Delaney. If anyone's looking for good stuff on the internals, it's one...

Viewing 15 posts - 3,916 through 3,930 (of 8,753 total)