Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 5,678 total)

  • RE: Attaching MDF with "old" log file

    In database options what compatibility level do you have the database in? I would recommend setting it to version 2008 (100), then retry the CheckDB, if I'm reading your...

    - 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

    March 4, 2011 at 2:33 pm

    #1294891

  • RE: How to show the updates that were made

    You're looking for the output clause. Check out these links:

    Overview: http://msdn.microsoft.com/en-us/library/ms177564.aspx

    Usage in Update: http://msdn.microsoft.com/en-us/library/ms177523.aspx

    - 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

    March 4, 2011 at 2:28 pm

    #1294889

  • RE: sql code works fine - front end application is slow?

    sqldba_icon (3/4/2011)

    Thanks. I have BIG concern using recompile option because procedure takes little more than a minute to compile the proc and since then 12 secs. If i use recompile...

    - 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

    March 4, 2011 at 1:44 pm

    #1294876

  • RE: RAID 10

    Kiara (3/4/2011)

    Steve Jones - SSC Editor (3/4/2011)

    I would have sworn that the RAID 1+0 was 4 in Wikipedia, and I have submitted a correction.

    The really funny part about it? It...

    - 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

    March 4, 2011 at 10:24 am

    #1294794

  • RE: Dynamically set Data Source values

    tshad (3/2/2011)

    Right - but how would you do that for SSRS?

    I am trying to set up my reports to get the Connection string and the Cube to be handled dynamically...

    - 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

    March 3, 2011 at 8:06 pm

    #1294420

  • RE: why the avatar picture you use

    mazzz (3/3/2011)

    I think I've found a future avatar for Lowell

    I keep looking at that image with the following vocalization running through my mind...

    "Frisbee! I gets it!"

    "Over the wall, Frisbee!"

    "Yay,...

    - 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

    March 3, 2011 at 4:10 pm

    #1294394

  • RE: Odd Questions

    Michael Valentine Jones (3/3/2011)

    What was the code you used to identify people that you would never want to hire?

    "Person A was more qualified than my pet rock, but less qualified...

    - 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

    March 3, 2011 at 2:42 pm

    #1294355

  • RE: Can I copy tasks from one package and paste into another?

    jcrawf02 (3/3/2011)

    um, 'cause I didn't think of that? 😛

    Still wonder why I can't just copy/paste, but that works easier.

    Thanks Gus!

    You can, it just gets a little grumpy about connection names...

    - 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

    March 3, 2011 at 2:21 pm

    #1294335

  • RE: Help with a tricky query

    GSquared (3/3/2011)

    lee rite (3/3/2011)

    ColdCoffee (3/3/2011)

    lee rite (3/3/2011)

    Thanks again! I think I'm done! I really appreciate all the help!

    Will i be getting a Samsung Focus for this help , mate ??...

    - 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

    March 3, 2011 at 1:55 pm

    #1294319

  • RE: Help with a tricky query

    lee rite (3/3/2011)

    Thanks for your help, guys! There are actually 25 columns, not 3.

    Let me explain exactly what I'm working with, so you will see why I need such...

    - 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

    March 3, 2011 at 12:31 pm

    #1294247

  • RE: Help with a tricky query

    A nasty but successful solution:

    WHERE

    COALESCE( 2008, 2009, 2010) = COALESCE( 2009, 2008, 2010)

    AND COALESCE( 2008, 2009, 2010) = COALESCE( 2010, 2009, 2008)

    ....

    That Null is...

    - 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

    March 3, 2011 at 12:12 pm

    #1294229

  • RE: Tables empty, but DB Size out of control

    Ninja's_RGR'us (3/3/2011)

    Mike Hinds (3/3/2011)

    Craig - many thanks!

    I'll be saving and studying the info you provided.

    FWIW, the 3rd party software vendor now tells me they are familiar with this behavior....

    - 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

    March 3, 2011 at 12:07 pm

    #1294222

  • RE: Tables empty, but DB Size out of control

    Mike Hinds (3/3/2011)

    Craig - many thanks!

    I'll be saving and studying the info you provided.

    FWIW, the 3rd party software vendor now tells me they are familiar with this behavior.

    He...

    - 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

    March 3, 2011 at 12:04 pm

    #1294218

  • RE: Help With Query

    Just an FYI, always do a run on your code first before posting it, if able. You didn't have an Identity column in the temp table, so SET failed....

    - 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

    March 3, 2011 at 12:01 pm

    #1294213

  • RE: Tables empty, but DB Size out of control

    Ninja's_RGR'us (3/2/2011)

    Craig Farrell (3/2/2011)

    Mike Hinds (3/2/2011)

    (No column name)(No column name)usedtotal

    queue_messages_846626059339836631990103199419sysdercv6796973484825484888

    sysdesend67969734883648856

    sysconvgroup67969733140131408

    sysobjvalues2596186

    What are they, and what can I safely do with them?

    :blink: Do you have Service Broker active on this database? ...

    - 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

    March 3, 2011 at 11:46 am

    #1294198

Viewing 15 posts - 3,826 through 3,840 (of 5,678 total)