Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 18,926 total)

  • RE: That case filter

    Epic conclusion & human behavior analysis

    Here are the standings as of this morning after 941 attempts :

    "It depends" (7%) is the classic answer in sql server but it just...

    July 21, 2011 at 6:06 am

    #1356279

  • RE: Login Properties

    paul s-306273 (7/21/2011)

    I'm surprised that the answer isn't null.

    Can somebody prove or disprove that.

    (I don't have the facility to do this myself - sorry!)

    I'll add to this. I know...

    July 21, 2011 at 5:53 am

    #1356274

  • RE: That case filter

    malleswarareddy_m (7/20/2011)

    feel upset by seeing the answer.There is only insert ..select is there.So i choosed 5 answer so that 5 rows got affected.even i tried in ssms also its also...

    July 21, 2011 at 5:33 am

    #1356268

  • RE: That case filter

    sharath.chalamgari (7/20/2011)

    nothing intrest in this Question. if you strictly follow the Question then the answer shoud be 0 as there is no select statements to return the records. but if...

    July 21, 2011 at 5:33 am

    #1356267

  • RE: That case filter

    devprasaddas 81425 (7/20/2011)

    At the end it will show in the execute box "5 rows inserted successfully".It will never show 0 in any place.

    So i donot think the answer give by...

    July 21, 2011 at 5:32 am

    #1356266

  • RE: Need Help - Proportion of reads & writes per day

    I've done this in a different way.

    Start a trace and log the audit logout event (nothing else). So this is a very lightweight trace.

    That way you can trace reads,...

    July 21, 2011 at 5:18 am

    #1356262

  • RE: Can we take a Backup of particular Table in a Database

    anil_kumar32 (7/20/2011)

    [font="Times New Roman"]

    Its true that when we create cluster index in some other filegroup then table data would be in that file group also. but during backup table and...

    July 21, 2011 at 5:13 am

    #1356261

  • RE: Error while using "sp_spaceused" in "sp_MSforeachdb"

    C.K.Shaiju (7/21/2011)

    I did it suresh, It is working for me as per your 1st reply. My problem already solved by your solution.

    But when I see Ninja's reply I just...

    July 21, 2011 at 5:10 am

    #1356260

  • RE: A Little Interviewing Advice

    Jeff Moden (7/20/2011)

    Ninja's_RGR'us (7/20/2011)

    There's only 1 question left. Would you still hire me to work under you?.. that's all I really care about atm :hehe:.

    Only if you wouldn't...

    July 21, 2011 at 5:07 am

    #1356258

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/21/2011)

    hor_netuk (7/21/2011)

    I know times are hard, but a job alert email subscription delivered me the attached vacancy today. For the record, I won't be applying. 😛

    That salary...

    July 21, 2011 at 5:04 am

    #1356257

  • RE: SSRS - Export report into CSV File

    visual.prabu (7/21/2011)

    I have no numeric columns in my report, it contains only string and date.

    I guess i can't do what you suggested.

    Any other idea...?

    Note: There is no raw data, all...

    July 21, 2011 at 5:01 am

    #1356256

  • RE: That case filter

    Tom.Thomson (7/20/2011)

    This was a nice question.

    I don't think I've ever worked so long or hard for a QoTD point before. And although I've said many times that a question...

    July 20, 2011 at 6:46 pm

    #1356112

  • RE: Removing or Replacing Data

    Thanks for the assist Paul.

    Does that handle single < or > in the text part of the tags? (out of office so I can't run a test).

    Is there a...

    July 20, 2011 at 6:43 pm

    #1356111

  • RE: Insert random data in an extra column while transfering data (INSERT INTO ..FROM SELECT..)

    newid() = random data

    checksum turns that into an integer

    abs makes it positive.

    % (modulo) sets the top range (0 to 99999)

    / turns it into a number between 0 and 1.

    /...

    July 20, 2011 at 3:45 pm

    #1356076

  • RE: Database can't be recovered? Any help would be appreciated!!!

    Steve Jones - SSC Editor (7/20/2011)

    If checkdb ran, I'd make a backup first. See if that works.

    Beyond that, I'll let Gail help out. She's more experienced in this area.

    The problem...

    July 20, 2011 at 3:38 pm

    #1356070

Viewing 15 posts - 4,621 through 4,635 (of 18,926 total)