Forum Replies Created

Viewing 15 posts - 16 through 30 (of 56 total)

  • RE: Precision required

    I have never used this 'T' format :w00t:

    I need a review on SQL Server format.

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 14, 2013 at 6:40 am

    #1596958

  • RE: INNER JOIN

    archie flockhart (3/13/2013)

    I was confused by people saying how rare it was to find matching values. When I tested the original code, I found that it was not infrequent at...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 13, 2013 at 8:34 am

    #1596545

  • RE: Temp Table Data Types

    Stewart "Arturius" Campbell (3/13/2013)

    Interesting question, thanks Dave

    Another way to check the detail of the temp table would be to execute tempdb..sp_help #TempQoD

    I often use sp_help to get db object info,...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 13, 2013 at 5:50 am

    #1596450

  • RE: INNER JOIN

    Evgeny Garaev (3/12/2013)

    Right answer is wrong in this case. Beacause some rows could be returned. This query will prove my words:

    end

    +2 😎

    I agree. So what I learned from this question...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 12, 2013 at 1:27 am

    #1595834

  • RE: DATETIME - 3

    This was a tough one for me. I didn't know the default cut off year. thanks.

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 9, 2013 at 11:04 pm

    #1595280

  • RE: SubQuery

    L' Eomot Inversé (3/8/2013)

    Primo Dang (3/8/2013)

    buddy__a (3/8/2013)

    I'm still waiting for someone to fix this. The answer saying "ORDER By is required when using a TOP clause" is clearly wrong.

    It...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 9, 2013 at 6:29 am

    #1595218

  • RE: SubQuery

    SQLRNNR (3/7/2013)

    Looks like we may have a fun day with this question.

    You're right. Look like a lot of people have fun figure out this one. The question did more good...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 8, 2013 at 10:04 am

    #1595052

  • RE: SubQuery

    demonfox (3/7/2013)

    The first three items are required for subqueries. There are only 32 nesting levels allowed and if a TOP clause is used, an ORDER BY must be included.

    actually, It's...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 7, 2013 at 9:32 pm

    #1594790

  • RE: CREATE statement

    demonfox (3/6/2013)

    did I miss something ???

    or there are more than 2 failures ...

    select db_id('dbdb')

    -- and the second one

    select object_id('dbdb')

    I don't think it will return the same value for a database.

    I...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 7, 2013 at 4:53 am

    #1594384

  • RE: Differential backup question

    Abu Dina (2/14/2013)

    I do FULL backups every two weeks and daily differentials on a number of SQL instances.

    The backup command I use for the differential backups in my sproc is...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 6, 2013 at 4:00 am

    #1593852

  • RE: Differential backup question

    anthony.green (2/14/2013)

    You dont have an INIT and FORMAT so it is appending the diff backup to the media set not overwriting it, so it contains all 13 days diff backups.

    Highly...

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 6, 2013 at 3:53 am

    #1593850

  • RE: ISNUMERIC

    haha. this not really about IsNumeric(). these type of questions are fun to solve. 😀

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 6, 2013 at 3:18 am

    #1593839

  • RE: Clustered Index

    I had to do some research for this one. good question.

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 5, 2013 at 6:50 am

    #1593451

  • RE: SETTINGS - 1

    thanks for the question.

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 3, 2013 at 6:22 am

    #1592743

  • RE: Can This Work?

    This is a fun question. Of course, the code will fail the syntax validation if executed all at once. Two proc call each other, eventually SQL Server will freak out....

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

    March 1, 2013 at 6:56 am

    #1592357

Viewing 15 posts - 16 through 30 (of 56 total)