Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 5,685 total)

  • RE: Disappointed with List as table Function

    Part of the issue is the explicit conversion after the function to a different datatype, messes with the optimizer.

    Another is the differences between @tmp and #tmp. @tmp has statistical and...

    September 19, 2011 at 3:34 pm

    #1383530

  • RE: Continuous Integration with SQL Server DBMS's

    Rich Yarger (9/19/2011)

    Kraig, thank you for sharing this. I'm sure my guys who are working on this are going to be thrilled!

    😛

    My pleasure... kinda. Every time I the...

    September 19, 2011 at 2:57 pm

    #1383512

  • RE: SQL Partition

    Tom.Thomson (9/19/2011)

    SQL Kiwi (9/19/2011)

    Evil Kraig F (9/19/2011)

    Paul, remember when I mentioned in that other thread that Partitioning seems to be a Level III item? 🙂

    Indeed. Perhaps we need...

    September 19, 2011 at 2:52 pm

    #1383506

  • RE: Continuous Integration with SQL Server DBMS's

    The entire process is a rabbit hole. Imagine having all of your code looking like this in source safe:

    If not exists (table)

    Create table (15 columns)

    If not exists (select...

    September 19, 2011 at 2:43 pm

    #1383502

  • RE: Join across databases in stored proc

    This might have to do with cross database ownership chaining and the SSRS login not having permissions, as SQLRNNR mentioned above. I'd usually expect an error in that case,...

    September 19, 2011 at 2:37 pm

    #1383496

  • RE: Continuous Integration with SQL Server DBMS's

    Welcome to my personal little slice of hell. What's up Rich?

    September 19, 2011 at 2:27 pm

    #1383492

  • RE: SQL Partition

    SQL Kiwi (9/17/2011)

    vk-kirov (9/16/2011)

    Good question, but the answer is totally wrong.

    Exactly. I can only imagine the author did test the code before submitting this question, but made a late...

    September 19, 2011 at 1:00 pm

    #1383450

  • RE: SSIS Package Execution for a non BIDS installed user

    Brandon Carl Goodman (9/19/2011)

    Thanks everybody, but maybe I did not explain this very well. The user in this case will not have BIDS nor SQL Server installed on their...

    September 19, 2011 at 12:26 pm

    #1383436

  • RE: I need to improve this query I have attached here

    Ranask, we need to see the index definitions as well, the schema is only half the battle... and speaking of, I understand the desire to only give us the columns...

    September 19, 2011 at 11:45 am

    #1383420

  • RE: SSIS Data Flow Transformations

    jdpowell777 (9/19/2011)

    Okay, great, thanks for the response

    My pleasure, good luck. 🙂

    September 19, 2011 at 11:04 am

    #1383398

  • RE: Are the posted questions getting worse?

    GilaMonster (9/17/2011)

    Tom.Thomson (9/17/2011)

    GilaMonster (9/17/2011)

    WayneS (9/17/2011)

    Steve Jones - SSC Editor (9/15/2011)

    Please let's not have quotes of every post that counts down from 95, 94, 93.

    I'm going out of town for a...

    September 17, 2011 at 12:38 pm

    #1382965

  • RE: SSIS Data Flow Transformations

    jdpowell777 (9/16/2011)

    Hi, I am new to SSIS. I would like to know, when it comes to simple queries is SSIS, whether there are any advantages to using data flow transformations,...

    September 17, 2011 at 12:31 pm

    #1382962

  • RE: Send multiple emails in SSIS from resultset

    PHXHoward (9/15/2011)

    Thanks for replying. I have the SELECT worked out but I don't know how to write multiple rows to a variable and then create the foreachloop to handle...

    September 15, 2011 at 5:58 pm

    #1382332

  • RE: Are the posted questions getting worse?

    ALZDBA (9/15/2011)

    SQLRNNR (9/15/2011)

    WayneS (9/15/2011)

    SQLRNNR (9/15/2011)

    Just saying that we only need 98 more posts for 30,000

    how many?

    Ummm - 96

    Make up your mind. No guessing 😉

    Bah! This is a SQL Server...

    September 15, 2011 at 1:47 pm

    #1382241

  • RE: Best Practice - What makes the most sense?

    this might be a silly question, but are you running the IIS and SSRS on the same server as the database?

    If so, that's not helping.

    A datawarehouse server is quite common...

    September 14, 2011 at 12:52 pm

    #1381559

Viewing 15 posts - 2,581 through 2,595 (of 5,685 total)