Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 5,678 total)

  • RE: Group by column A but compare column B

    Luis Cazares (9/27/2012)

    I would like to know more about those methods. Could you tell me where to find information? I couldn't find much.

    This is what I came with. It's doing...

    - 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

    September 27, 2012 at 3:18 pm

    #1543122

  • RE: Doing simple count(*) how long is too long to get results

    Mark F-428640 (9/27/2012)

    I am trying to get an idea of how much records I will be processing from a transactional table during a rollup process.

    I have been running about...

    - 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

    September 27, 2012 at 2:46 pm

    #1543108

  • RE: Remove Duplicate data in my Database

    sanjay684 (9/27/2012)

    First off all candidate id in the first table had primay key and after all the table have foregion key..When i have try to delete any row of tblcandidate...

    - 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

    September 27, 2012 at 2:28 pm

    #1543103

  • RE: Group by column A but compare column B

    Luis Cazares (9/27/2012)

    I found a way to do this. Might not be optimal but it's a way.

    However, I want to know what is this for, as Craig asked.

    There's a few...

    - 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

    September 27, 2012 at 2:07 pm

    #1543093

  • RE: Remove Duplicate data in my Database

    Sanjay,

    If you're looking for a solution to remove duplication from a set of those tables, provide the schema, some sample data, and your rules for removing duplicated data for those...

    - 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

    September 27, 2012 at 1:54 pm

    #1543085

  • RE: Table Relationships

    SQL_Loser (9/27/2012)

    1.What is the purpose of self referential foreign keys ? or why do we create it?

    As Luis mentioned above, Hierarchial Tables (think Org Charts) are the typical reason...

    - 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

    September 27, 2012 at 1:50 pm

    #1543081

  • RE: Group by column A but compare column B

    Couple of questions:

    Is this oversimplified or is it a homework question? If homework, what's the chapter's subject so we can help you find the right place with this?

    If...

    - 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

    September 27, 2012 at 1:28 pm

    #1543075

  • RE: ssis package not working with sql server agent but run fine manually

    vandana_j79 (9/26/2012)

    I have setup job which run ssis package. In this job i pick data from oracle server with link server. When i run job manually it complete in 20...

    - 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

    September 27, 2012 at 1:10 pm

    #1543065

  • RE: Stored Procedure Insert Locking Until End of Processing

    +1 to what Matt provided. INSERT INTO opens an implicit transaction, and then anything ran under that ends up in the transaction. What's the default isolation level on...

    - 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

    September 27, 2012 at 12:49 pm

    #1543058

  • RE: Memory allocation for SSIS variable

    Is that the only error in the log? There should be a bunch more information alongside it and additional errors neighboring it... otherwise I'd call microsoft because you don't...

    - 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

    September 27, 2012 at 12:46 pm

    #1543057

  • RE: What's wrong in this .. simple calculations

    cphite (9/27/2012)

    Speaking for myself, I always use DECIMAL to store dollar amounts to avoid exactly this sort of issue. I've never seen the point of money or smallmoney.

    Backwards compatibility.

    - 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

    September 27, 2012 at 12:21 pm

    #1543050

  • RE: Why is there an implicit conversion between two varchars

    mark 4643 (9/26/2012)

    I don't understand why it's doing an implicit conversion between 2 varchars. Is it just because they are different lengths?

    Yep.

    Is there an easy way to figure out which...

    - 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

    September 26, 2012 at 2:58 pm

    #1542623

  • RE: Memory allocation for SSIS variable

    rburko (9/26/2012)

    I'm taking the recordset, saving it to a variable, and using it in a subsequent loop.

    I'm sure I can cajigger the subsequent step to read from a temp table...

    - 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

    September 26, 2012 at 11:10 am

    #1542550

  • RE: Query result in SQL Server 2000 return correct and SQL Server 2008 R2 SP2 return wrong

    antonio.estima 4150 (9/26/2012)

    In SQL Server 2K or 2K5 the WHERE clause where SUBSTRING(nomeint,1,1) = 'P' is run first in the subquery and then it does the join. However, in SQL...

    - 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

    September 26, 2012 at 11:05 am

    #1542549

  • RE: Tables most and least used in SQL Server

    Do not trust sysdepends, it lies like a rug.

    There is no easy method to be sure of how often a table is used, particularly for select statements. You'd start...

    - 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

    September 26, 2012 at 1:03 am

    #1542227

Viewing 15 posts - 1,111 through 1,125 (of 5,678 total)