Forum Replies Created

Viewing 15 posts - 196 through 210 (of 1,079 total)

  • RE: Can anyone recommend a working sample ETL package created with SSIS?

    not sure if you wanted anyone to send you a dtsx file...but here are links to articles that will get you going.
    http://www.sqlservercentral.com/search/?q=SSIS&t=a&sort=relevance

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 12:49 pm

    #1928700

  • RE: Corruption when restoring/renaming databases

    Interesting. 

    What results do you get when running

    select name, database_id from sys.databases
    and when focused on 'object'
    select db_name(), db_id()

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 9:47 am

    #1928667

  • RE: SQL Server Log file and Data file available free space in percentage

    vinod.mallolu - Wednesday, February 15, 2017 9:20 AM

    Excellent.
    this is the one which i've been using, but the requirement is to display for...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 9:30 am

    #1928661

  • RE: SQL Server Log file and Data file available free space in percentage

    vinod.mallolu - Wednesday, February 15, 2017 9:09 AM

    Yes, this is what my requirement, but unable to keep that in the posted Query....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 9:13 am

    #1928649

  • RE: SSR Syntax correction, Can you help ( How do we use the IIF statement )

    mw112009 - Wednesday, February 15, 2017 9:09 AM

    Incorrect # of parenthesis  count the number of "(" and ")"

    try =IIF(IsDate(Fields!HIST_SRVC_DT.Value)=True, Fields!HIST_SRVC_DT.Value, 0)
    had one extra...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 9:11 am

    #1928648

  • RE: SSR Syntax correction, Can you help ( How do we use the IIF statement )

    you need to evaluate, if true, if false. 

    =IIF(IsDate(Fields!HIST_SRVC_DT.Value)=True), Fields!HIST_SRVC_DT.Value, 0)

    replace my 0 with what happens if your evaluation returns a false value.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 9:01 am

    #1928642

  • RE: Connect Oracle Source

    Kannan Vignesh - Wednesday, February 15, 2017 6:31 AM

    Dear Folks,

    I am trying to connect Oracle source using .Net Providers\Odbc Data Provider.

    it shows...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 7:30 am

    #1928618

  • RE: SQL Server vs SQL Server v.Next

    SQLKnowItAll - Wednesday, February 15, 2017 6:30 AM

    I don't think it's fair to say that extra CPU makes up for lacking disk...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 6:56 am

    #1928610

  • RE: Vertical Blocks of Code

    Alt alone not doing that trick, Shift+Alt works.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 15, 2017 at 5:57 am

    #1928590

  • RE: Possible to share a very large database between servers?

    Jim Youmans-439383 - Tuesday, February 7, 2017 2:54 PM

    OK, I know this sounds a bit wonky, but I have a client that...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 8, 2017 at 9:47 am

    #1927368

  • RE: The differential PoSh backup

    Confession - used msdn

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    February 7, 2017 at 7:13 am

    #1927081

  • RE: Getting morning, afternoon and evening matches from a set of dates by day of week

    kangarolf - Tuesday, January 31, 2017 12:22 PM

    Hi all;

    I can get the info an individual day like this;

    INSERT INTO #TEMP
    SELECT...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 31, 2017 at 12:46 pm

    #1925942

  • RE: sp_clean_db_free_space

    Lynn Pettis - Friday, January 20, 2017 9:28 AM

    Not really helpful.

    If you delete data from a table would sp_clean_db_free_space satisfy a requirement that...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 20, 2017 at 10:32 am

    #1924108

  • RE: Database Mail : Execute Permission problem

    kyssling - Friday, January 20, 2017 10:01 AM

    Hello,

    I have a problem with Database Mail. Thank you for help ...

    SQL Server 2016 running on...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 20, 2017 at 10:21 am

    #1924101

  • RE: Cost Threshold for Parallelism Clarification

    butcherking13 - Friday, January 20, 2017 9:53 AM

    I understand that Cost Threshold for Parallelism is the "cost" that the optimizer will use to...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

    January 20, 2017 at 10:12 am

    #1924093

Viewing 15 posts - 196 through 210 (of 1,079 total)