Forum Replies Created

Viewing 15 posts - 3,931 through 3,945 (of 5,678 total)

  • RE: How to tune text queries

    AJ-636201 (2/21/2011)


    I have created only one clustered index and that is on FirstName column, and no other index has been created not even any non clustered index.

    So is there...


    - 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: SSIS question - Determining if an inv num exists in a table and doing something with the data afterwards...

    mikedu (2/21/2011)


    What I have is a file that I am importing to a stage table. There are two tables after stage (current & history), the current table is 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: How to tune text queries

    AJ-636201 (2/21/2011)


    Hi,

    I am trying to search the possibilities for tuning the query in which it goes for index scan.

    select * from Contact where FirstName like 'a%'

    As per business requirements many...


    - 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: insert data in SQL Server thorugh SSIS source and destination without effecting transaction log of sql server

    scottichrosaviakosmos (2/21/2011)


    i want to insert data from one sql server table to another table which is in another server in sql server.

    but when i insert data i dont want 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: RAID 5

    Steve Jones - SSC Editor (2/21/2011)


    Haven't seen much written on RAId 50. I suspect it suffers the same write penalty that Raid 5 has.

    I'd agree and it does, but RAID...


    - 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: Very large index in database and less memory on disk left

    Grant Fritchey (2/21/2011)


    You're cross over a few items there. The recovery model of the database and index rebuilds shouldn't be cross-concerns. Space on the drive is because you'll need room...


    - 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: had a problem with process the package

    Koen Verbeeck (2/21/2011)


    Phil Parkin (2/21/2011)


    Koen Verbeeck (2/21/2011)


    To find the real issue here, you'll have the post the error messages, as they are currently missing.

    So you're not happy with the "just...


    - 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: Need you opinions about SQL Azure

    Steve Jones - SSC Editor (2/21/2011)


    In addition to what Craig said, you pay for bandwidth, so factor in the cost of doing a backup, deploying code, testing on Azure, etc.

    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: Need you opinions about SQL Azure

    Rich Yarger (2/21/2011)


    Hello -

    Recently, I was asked about my thoughts on Microsoft's Azure platform option, and whether or not it would be worthwhile to look into. Frankly -...


    - 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?

    For anyone curious, my opinions on the SQLSaturday #47 event in Phoenix.

    http://www.sqlservercentral.com/Forums/Topic1066836-1199-1.aspx

    All in all, a very satisfying day.


    - 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: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/19/2011)


    Craig if I may - just one last question on this subject, because you have mentioned it a couple of times. As I have previously stated, 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: Finding sets of records

    tacy.highland (2/18/2011)


    That doesn't quite work either. I tried that in the earlier post (the "variation"). I've found other Cases which should be included in my resultset but aren'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

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/18/2011)


    Craig, thank you again. I think the only other thing that will go on C:\DRIVE is going to be the backups, and that is it. That...


    - 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: need help regarding move directory option in File System task

    Can you provide the list of errors?


    - 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: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/18/2011)


    Hi Craig -

    Wanted to pick your brain on one other idea for this RAID configuration I have been working on. We previously discussed the idea of...


    - 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 - 3,931 through 3,945 (of 5,678 total)