Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 19,560 total)

  • RE: Today's Random Word!

    vitrious

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2013 at 10:14 am

    #1635059

  • RE: Today's Random Word!

    petrified

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 17, 2013 at 12:58 am

    #1633092

  • RE: Massive slowdown in SELECT statement in Cursor from SQL 2000 to 2008 -- need help!

    Attach the table definitions and actual execution plan (not estimated).

    The key lookup means you do not have a covering index for the query. You need to create a covering...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 5:39 pm

    #1628459

  • RE: How does SQL pronounce SQL?

    thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 5:27 pm

    #1628458

  • RE: Date add with Different DataType

    thanks for the question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 5:23 pm

    #1628457

  • RE: Temp Tables revisited

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 5:22 pm

    #1628456

  • RE: Temp Table

    Good back to basics question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 5:21 pm

    #1628454

  • RE: Database Backup Restore

    Hugo Kornelis (6/26/2013)

    PRR.DB (6/25/2013)

    I have taken "TestPartition" Database backup (In that db , 5 table are partitioned with 10 file-groups(.ndf files)) then I executed below command

    RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'

    It is...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 5:19 pm

    #1628453

  • RE: Today's Random Word!

    kitchen

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 28, 2013 at 1:43 pm

    #1628415

  • RE: Today's Random Word!

    ubiquitous

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 24, 2013 at 10:16 am

    #1626846

  • RE: Lock Escalation Limit

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 20, 2013 at 4:14 pm

    #1626149

  • RE: Today's Random Word!

    Angelina

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 20, 2013 at 2:26 pm

    #1626114

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/20/2013)

    I need some advice, please.

    One of my thread questions has a poster on it who spent all day yesterday on Twitter telling me my problem is impossible (literally,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 20, 2013 at 11:25 am

    #1626054

  • RE: Partitioning in SQL Server 2008

    Brandie Tarvin (6/20/2013)

    SQLRNNR (6/20/2013)

    You also now know the procedures that are executing - you can look to tune those procedures.

    As for the code coming from Access or across the linked...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 20, 2013 at 11:23 am

    #1626052

  • RE: Get the Foreign Key Hierarchy

    This reminds me, I think I have an update for that script.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    June 20, 2013 at 11:22 am

    #1626051

Viewing 15 posts - 4,456 through 4,470 (of 19,560 total)