Forum Replies Created

Viewing 15 posts - 15,361 through 15,375 (of 39,970 total)

  • RE: how rollback works in sql server?

    Note if you set this behavior then you have to make sure all your code includes commits. Otherwise you will have severe locking/blocking issues.

    Most SQL Server code does not expect...

  • RE: Shrink File

    No.

    Short answer is that you don't want to shrink data files (MDF/NDF) unless some unusual event caused them to grow and the data space isn't needed.

    You've listed two things that...

  • RE: Estimation of mdf and ldf files in SQL Server 2005

    James and Paul have noted the correct response. You cannot estimate log file size, any rule of thumb is a wild guess based on experience, but could be completely inappropriate....

  • RE: if NULL ? ??

    if (select myval from Mytable) is null

    insert into ...

    else

    insert into

    ...

    will work, but you have two tag_names in the different code. What do you mean...

  • RE: Are the posted questions getting worse?

    As we were getting the kids ready this am, a family of deer (buck, doe, 2 kids) walked through the front yard. The girls were fawning over them at the...

  • RE: Are the posted questions getting worse?

    mtillman-921105 (9/1/2011)


    jcrawf02 (9/1/2011)


    I heard there's some crazy SQL guy who will let you stay in one of his stables if you're willing to shovel...

    That's funny because horses and I do...

  • RE: Issue with Join ...

    mattech06 (9/1/2011)


    Thanks again, I've traced the duplication back to where more than one patient does have only one phone number ..makes sense when the extra patients could be the children.

    Is...

  • RE: 2011 SSC Code for PASS Summit

    We've negotiated to rent a room from PASS and will have a casino party/Exceptional DBA awards.

    We are subsidizing some of it, and we'll sell $20 tickets in advance. Announcement will...

  • RE: Fantasy football

    It's on!

    Starting a new thread in this forum for Fantasy Football 2011.

  • RE: user must change password at next login greyed out

    If you could check the option, you're forcing a password change, however that's a security risk. Imagine the password is compromised. You check the box, the hacker logs in first,...

  • RE: Are the posted questions getting worse?

    I have seen a concert at Red Rocks (John Mayer/Maroon 5) and also been there a few times with family to walk, but haven't fun the steps. Not sure my...

  • RE: Are the posted questions getting worse?

    mtillman-921105 (9/1/2011)


    I'm moving to Colorado! :smooooth:

    'Can't wait. Memphis just isn't were I want to be anymore. I have some family and friends here, but most have moved on....

  • RE: user must change password at next login greyed out

    It looks that way on mine, but if I change the password, I can then check the box. You can't force a password change without changing the password.

  • RE: Issue with Join ...

    Without seeing the DDL for the tables and knowing the keys, it's hard to give you the exact.

    In terms of conditions, use them in a WHERE, something like

    WHERE dbstatusID !=...

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/1/2011)


    Wow, this is a great idea. Someone should do this for SQL

    http://www.foxepractice.com/healthcare-hashtags/%5B/url%5D

    Interesting. I think we're not consistent, but I do see a lot of

    - #sql

    - #sqlserver

    - #sqlhelp

    - #sqlsat

    - #sqlpass

    -...

Viewing 15 posts - 15,361 through 15,375 (of 39,970 total)