Forum Replies Created

Viewing 15 posts - 61 through 75 (of 216 total)

  • RE: SSMS 2008 using last entered username as default login

    Steve,

    thanks for the feedback. Yes I should have probably stated it was all SQL auth.

    Will probably raise it on Connect, just wanted to sanity check it here...

  • RE: transaction test!

    Hugo Kornelis (7/7/2009)


    (I lost my point - I was so focused on the details of the nested transactions that I failed to see that the code used a table variable...

  • RE: LINQ - SQL Server 2008

    Chris Harshman (6/21/2009)


    LINQ to me is also a solution looking for a problem.

    Chris,

    I think that's the best description of LINQ to SQL I have ever heard! 😛

    As a SQL...

  • RE: My Approach to Writing for SQLServerCentral

    David,

    I always find your articles very interesting, easy to read and entertaining!

    You should get them printed and bound!

    Kev

  • RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

    Come on guys (and gals) - this is obviously a multi-part series, and this part was subtitled 'Part 1: An introduction'.

    And at the end, the author states 'coming up in,part...

  • RE: The T-SQL Paradigm

    dphillips (4/3/2009)


    I concur with the previous post, and would also add that the IDE's for T-SQL or SQL in general could do with a lot more features.

    dphillips, like what?

    Kev

  • RE: The T-SQL Paradigm

    I agree with Michael, it's not that SQL is difficult, in fact I think T-SQL is quite easy, it's making it perform that can be seen as difficult, and that...

  • RE: TSQL

    serinor.e090266 (3/27/2009)


    I dont know if there is a problem, but i have tested the sentence in a SQL Server 2005

    More information:

    1)

    Output for SELECT @@VERSION

    Microsoft SQL Server 2000 - 8.00.2039...

  • RE: TSQL

    Ben Leighton (3/26/2009)


    In 2005 if I'm comparing those instances where it works and those where it doesn't... I'd be interested to see how/whether the execution plans differ.

    I'd bet they don't...

  • RE: TSQL

    I took so long to submit that post that dmw beat me to it!

    Kev

  • RE: TSQL

    gserdijn (3/26/2009)


    When the SELECT statement is compiled for the INSERT, the first value is implicitly taken as an INT. In the UNIONs, as each SELECT is added, they must match...

  • RE: Bracket matching in SMSS 2008

    Another update.....

    I have had a response on Connect

    Thank you for reporting the problem. With SSMS 2008, brace matching feature is available. If you could navigate the cursor over the script...

  • RE: Bracket matching in SMSS 2008

    An update....but still no clearer!

    Tried on my second PC - a new install of SSMS 2008 but still 1600.22

    Against a 2008 instance

    () - highlighted with...

  • RE: Bracket matching in SMSS 2008

    Tried against a 2008 instance - still no joy!

    Will try running on another SSMS 2008.....

    Kev

  • RE: Bracket matching in SMSS 2008

    Steve - out of interest, what version of SQL is this connected to?

    Just wondering if SMSS2008 features only work against a 2008 instance.

    Trying to install a 2008 instance on my...

Viewing 15 posts - 61 through 75 (of 216 total)