Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 5,678 total)

  • RE: Odd behaviour from computed columns in a left outer join

    Kevin,

    Can you post the schema and indexes for the tables CommunicationEntry, Customer_Address, and Address please?


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Simpler way to join all unique columns for a join?

    kinderdesign (8/29/2012)


    Most columns are identical and this is what I'm traying to make a report of. Is there a way to grab all current tables in the db with...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: cannot connect to named instance thru SSMS on developers desktop

    Sqlism (8/29/2012)


    Thanks everyone this topic really really helped me a lot.

    I installed management studio on my desktop and my other dba's desktop, we successfully connected to named instance,

    so by this,...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: UPDATE when the values are the same

    Sergiy (8/28/2012)


    Should I say - you turned it that way?

    In my opinion it happened long before my involvement. I tried to bring attention to it while clarifying your confusion...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Shadow IT

    Nadrek, I agree that poor hiring practices for local departments can get unqualified or semi-qualified people into local IT positions (for example, what does a doctor really know about a...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: DBA Stress Management

    Barkingdog (8/28/2012)


    In addition to our Microsoft Sql Server farm, I’m responsible for the Admin of our SharePoint and TFS farms, writing SSIS packages, query tuning, converting old COM+ objects to...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: cannot connect to named instance thru SSMS on developers desktop

    Sqlism (8/28/2012)


    i can see one sql server browser running in configuration manager

    You would need to check if it's running in services. RDP to the box, Rt-Click on "My Computer",...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: UPDATE when the values are the same

    Sergiy (8/28/2012)


    Evil Kraig F (8/28/2012)


    Your constant badgering and attack of the person instead of the issue in question.

    That's exactly what YOU are doing now.

    Quite correct, this conversation took a left...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: UPDATE when the values are the same

    Sergiy (8/28/2012)


    Evil Kraig F (8/28/2012)


    *scratches his head* Out of curiousity, you realize these are other people you're talking to, not your drinking buddies who don't take offense to your constantly...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Hey folks! Need some administrator backup, it's been at least 2 years since I've argued with install issues outside of my personal box.

    http://www.sqlservercentral.com/Forums/Topic1351321-391-1.aspx?Update=1

    Friendly enough feller and I've hit the...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: cannot connect to named instance thru SSMS on developers desktop

    Sqlism (8/28/2012)


    In named Instance:

    Right clicked TCP/IP--> Properties---> Ip adresses .... I can NOT see port number as 1433, it is just left blank

    Yeah, check the last value, it should...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: cannot connect to named instance thru SSMS on developers desktop

    Sqlism (8/28/2012)


    checked remote connections for the instance set on. It is enabled.

    One down... šŸ™‚

    Does each SQL Server listens on different port numbers?

    for example: default on 1433 and named on something...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: cannot connect to named instance thru SSMS on developers desktop

    Verify that remote connections for the instance are set to on, and double check the listener on the server that the instance is listed. I think Gail's wild guess...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: cannot connect to named instance thru SSMS on developers desktop

    Agreed, need the error to help here. There's a few dozen things it could be.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Can't add new users, reached a dead-end

    As a troubleshooting test, can you load a copy of the database itself (not the SQL table side, just the access one) onto a user's system and see if their...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 15 posts - 1,216 through 1,230 (of 5,678 total)