Forum Replies Created

Viewing 15 posts - 22,366 through 22,380 (of 49,552 total)

  • RE: execute stored procedure with order by

    Dev @ +91 973 913 6683 (11/10/2011)

    daveriya (11/9/2011)

    thanks a lot DEV,that's what i was looking ,u solve my problem.

    I would love to accept Thanks but as Sean & Paul...

    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 10, 2011 at 2:56 am

    #1405581

  • RE: Index Fragmentation

    derekr 43208 (11/9/2011)

    How do we get forwarding pointers?

    Never with an index. Only possible with a heap.

    Can this happen with a table with just non-clustered indexes on it.

    The definition of 'heap'...

    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 10, 2011 at 2:55 am

    #1405579

  • RE: Restore Never Finishes

    Can you just post the last few messages in the log?

    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 9, 2011 at 2:14 pm

    #1405461

  • RE: Restore Never Finishes

    Anything in the SQL error log relating to this DB?

    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 9, 2011 at 1:49 pm

    #1405454

  • RE: Are the posted questions getting worse?

    SQL Kiwi (11/9/2011)

    GilaMonster (11/9/2011)

    SQL Kiwi (11/9/2011)

    GilaMonster (11/9/2011)

    Never worked with Tony Davis have you?

    I found Tony to be very easy to work with, and a very 'light' editor. No dramas.

    Depends...

    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 9, 2011 at 1:30 pm

    #1405450

  • RE: Are the posted questions getting worse?

    SQL Kiwi (11/9/2011)

    GilaMonster (11/9/2011)

    Never worked with Tony Davis have you?

    I found Tony to be very easy to work with, and a very 'light' editor. No dramas.

    Depends on whether he...

    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 9, 2011 at 1:23 pm

    #1405448

  • RE: Database Restore Never Finishes

    Please start a new thread for your question.

    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 9, 2011 at 1:21 pm

    #1405447

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/9/2011)

    GilaMonster (11/9/2011)

    Roy Ernest (11/9/2011)

    Steve will rip my article into pieces for sure. I am not a writer. Therefore I expect to have problems with the Steve Editor as well....

    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 9, 2011 at 1:20 pm

    #1405446

  • RE: Are the posted questions getting worse?

    Roy Ernest (11/9/2011)

    Steve will rip my article into pieces for sure. I am not a writer. Therefore I expect to have problems with the Steve Editor as well. His...

    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 9, 2011 at 12:54 pm

    #1405433

  • RE: join on 1=1

    sqlfriends (11/9/2011)

    Ninja's_RGR'us (11/9/2011)

    Well you could do it like this if you wanted to =>

    FROM SchoolProgram srp

    INNER JOIN @Programs pr ON srp.ProgramID = 7

    Thanks, so above statement, for inner join it...

    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 9, 2011 at 11:21 am

    #1405402

  • RE: join on 1=1

    sqlfriends (11/9/2011)

    so if I change the join to cross join and take off 1=1, it will be the same, correct?

    Yes

    But I read somewhere if a cross join have a where...

    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 9, 2011 at 11:14 am

    #1405397

  • RE: INSERT into sys.objects on 2008

    Minnesota - Viking (11/9/2011)

    When I compare the old and new objects in both sys.objects and sys.columns, its so convincing that what all the sysobject table[view] needs is a reference...

    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 9, 2011 at 11:03 am

    #1405391

  • RE: Versioning Control for SQL Server

    http://www.red-gate.com/products/sql-development/sql-source-control/ + subversion as the actual source control system.

    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 9, 2011 at 10:16 am

    #1405366

  • RE: Memory usage

    It's also quite likely to see SQL taking enough memory to starve the OS and cause stability problems if you don't set max server memory.

    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 9, 2011 at 10:14 am

    #1405363

  • RE: INSERT into sys.objects on 2008

    Gazareth (11/9/2011)

    Theoretically (I'm not advocating doing it whatsoever), would it be possible to create an object, check if it has object_id = 780685979 then delete it?

    It might, might, might, assuming...

    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 9, 2011 at 10:11 am

    #1405361

Viewing 15 posts - 22,366 through 22,380 (of 49,552 total)