Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 5,685 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...

    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

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

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

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

    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,...

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

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

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

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

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

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

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

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

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

    March 3, 2011 at 11:46 am

    #1294198

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