Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Temp Tables

    Hugo Kornelis (6/25/2012)

    When I answered the question, I *knew* I was taking a gamble on the intended interpretation.

    ...... so I was looking for an answer option "true for temp tables;...

    June 25, 2012 at 1:38 am

    #1504907

  • RE: Database size in SQL Server 2012

    tommyh (6/19/2012)

    If one wants be really picky "Depends on File System" is actually the right answer.

    You can install 2012 on FAT32 and that have a limit to 4GB/file. The...

    June 21, 2012 at 3:35 am

    #1503833

  • RE: Create Database

    ipounder (6/21/2012)

    Seems to me that both answers can be correct.

    Ian

    I agree 🙂

    June 21, 2012 at 3:27 am

    #1503831

  • RE: ISNULL

    gary.mazzone (11/23/2011)

    If you comment out Select ISNULL(@Money,'') you get the error on Select ISNULL(@Decimal,'')

    Error converting data type varchar to numeric.

    So shouldn't the answer be more then 1?

    Absolutely agree !!

    November 23, 2011 at 8:52 am

    #1412271

  • RE: system stored procecures

    Christian Buettner-167247 (8/23/2011)

    elbedata (8/23/2011)

    It returns "that" when I test on SQL Server 2008, but I thought it should return "this"...

    Has this changed in later SQL versions? I am pretty sure...

    August 23, 2011 at 1:59 am

    #1371801

  • RE: Deprecated features

    Spot on Simone - there should have been two answers!

    Doing this post to get my point back 😛

    August 15, 2011 at 8:29 am

    #1368640

  • RE: SQL DBAdmin toolbox - Part 2: Verify all databases in the enterprise

    Try doing a DBA job within the financially constrained defence sector.

    Oh for the luxury :hehe: of being able to have "a dedicated SQL server with highest SQL version in...

    July 14, 2011 at 7:28 am

    #1352818

  • RE: char(13) is not putting in a CR

    Back in the halcyon days of DOS :hehe: etc., CHAR(13) was the carriage return control character - and did just that, i.e. returned the carriage to the start of the...

    July 5, 2011 at 3:59 am

    #1348152

  • RE: The Backup Passwords

    Thanks Ben.

    Just to confirm the finer detail:

    Tickets are pulled from the book at random, numbered 1-999, but in addition to the big number there is a 6 character alphanumeric book...

    June 2, 2011 at 6:30 am

    #1333050

  • RE: The Backup Passwords

    As I see it, there are three main objectives to be met:

    - Each backup should have its own unique password.

    - The method of password generation must not be...

    June 1, 2011 at 8:48 am

    #1332534

  • RE: Data conversion

    I guessed (wrongly?) that the INSERT INTO would fail.

    However, testing your code on a UK system showed that I was indeed correct and the statement fails due to implicit conversion...

    March 18, 2011 at 3:04 am

    #1300351

Viewing 11 posts - 1 through 11 (of 11 total)