Forum Replies Created

Viewing 15 posts - 406 through 420 (of 2,894 total)

  • RE: Interview Questions i am not able to answer

    GilaMonster (5/20/2013)

    Eugene Elutin (5/17/2013)

    5. does sql starts if model database is corrupted. if so how to bring it to normal operation.

    I don't think so. It's model database for all...

    May 20, 2013 at 4:32 am

    #1616567

  • RE: Interview Questions i am not able to answer

    Why? Don't you like Lynn answers?

    May 20, 2013 at 3:46 am

    #1616556

  • RE: sqlCursor

    vinu512 (5/20/2013)

    dwain.c (5/19/2013)

    The anti-RBAR alliance will forever bless you if you do.

    Amen!!!! :-D:-D

    RBAR Akbar!

    :hehe:

    May 20, 2013 at 3:30 am

    #1616552

  • RE: Proper way to write a sproc

    ...

    i look at some other procs that people have done (and sorry i dont hvae any examples) and there are all sorts of other commands that come in first.

    ...

    What other...

    May 20, 2013 at 3:27 am

    #1616551

  • RE: Interview Questions i am not able to answer

    5. does sql starts if model database is corrupted. if so how to bring it to normal operation.

    I don't think so. It's model database for all databases on the...

    May 17, 2013 at 11:04 am

    #1616266

  • RE: query joining multiple tables getting duplicates- how to stop

    Denise McMillan (5/17/2013)

    I'm joining several tables and when I add the last one I get duplicate results. How can I get just one for each? Thanks for any ideas.

    select...

    May 17, 2013 at 10:27 am

    #1616254

  • RE: orders over more than one partition question.

    ben.brugman (5/17/2013)

    Can the optimizer handle this kind of code efficiently?

    May be.

    It depends on exact code and other details - all details - table design, structure, indexes etc.

    May 17, 2013 at 9:32 am

    #1616233

  • RE: CROSS JOIN vs INNER JOIN performance issue.

    T.Ashish (5/17/2013)

    So should I say that it is the old way of INNER JOINing tables, that will not be supported in future versions !!

    No, that's incorrect. The older (non ANSI)...

    May 17, 2013 at 9:27 am

    #1616232

  • RE: Block reporting from a database

    Michael Valentine Jones (5/17/2013)

    I suggest changing the security model of the application so that end users do not have direct access to the database.

    +100

    or, leave access to database but deny...

    May 17, 2013 at 7:48 am

    #1616185

  • RE: Hour not showing correctly

    philip.davy (5/17/2013)

    --Question 4b

    select

    History_Type_,

    TimeClicked,

    left(right(TimeClicked,11),2) as HourTimeClicked,

    count(left(right(TimeClicked,11),2)) as CountOfHourTimeClicked

    from clicktracking_ --with (nolock)

    inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_

    group by

    History_Type_,

    timeClicked,

    left(right(TimeClicked,11),2)

    OPN2011-09-24 18:38:000169

    OPN1802013-04-02 12:41:00011

    OPN902013-04-11 18:18:00011

    OPN1802011-09-26 13:08:000113

    OPN902011-07-05 11:01:000117

    the hour is always incorrectly 01 which...

    May 17, 2013 at 5:41 am

    #1616128

  • RE: space issue

    ramyours2003 (5/17/2013)

    We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

    Delete something! 😉

    http://msdn.microsoft.com/en-us/library/ms189493.aspx

    May 17, 2013 at 4:05 am

    #1616105

  • RE: What Do You Call This Relationship ?

    It's a tree or hierarchy, whatever you prefer.

    I guess, you will need to use some sort of recursive CTE. Hard to say anything more based on provided limited details.

    May 17, 2013 at 3:20 am

    #1616092

  • RE: nolock

    mt_dren (5/16/2013)

    See link. http://technet.microsoft.com/en-us/library/ms187373(v=sql.110).aspx

    Note

    For UPDATE or DELETE statements: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

    May 17, 2013 at 3:17 am

    #1616090

  • RE: Need Help

    I could be wrong, but it does appear that you have enclosed your RES value in double quotes " inside of your @MY_STRING sql string. If so, you should...

    May 16, 2013 at 11:04 am

    #1615919

  • RE: using multiple UNION in query

    John Mitchell-245523 (5/16/2013)

    Sean Lange (5/16/2013)

    John Mitchell-245523 (5/16/2013)

    Phil Parkin (5/16/2013)

    lnardozi 61862 (5/16/2013)

    Just for completeness sake, you never use more than one UNION, which is the last one. All the rest should...

    May 16, 2013 at 8:57 am

    #1615846

Viewing 15 posts - 406 through 420 (of 2,894 total)