Forum Replies Created

Viewing 15 posts - 1 through 15 (of 67 total)

  • RE: Deactivating Irrelevant Data in a Warehouse

    Well there is DimStudent and DimSubject which is handled as proper Dimension tables. However a link between those two is captured in BridgeStudentSubject. Applying SCD rules to the bridge table...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    April 25, 2017 at 7:16 am

    #1939745

  • RE: SSRS 2016 : MS Edge and IE 11

    Thanks Joie

    I tried the "Fix the SSRS Compatibility Issue at the Server Level" option, but it seems SSRS 2016 dont have that metatag.

    This fix seem to...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    February 13, 2017 at 12:14 am

    #1928040

  • RE: Main Report not picking up Sub Report

    I found a sloppy work around. By ensuring the reports are in the same folder ... it works. I then just hide the sub report.

    Unless I am missing something I...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    June 24, 2016 at 5:27 am

    #1886701

  • RE: Replication with a Twist

    Wait ... so how do I that?

    PS: I realised my previous response was epicly idiotic.

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 26, 2012 at 1:17 pm

    #1439010

  • RE: Transactional Replication with a Twist

    I was thinking towards something in the line:

    Temporarily Disable Logging to Transaction Log

    Executing the DELETE statements but ensuring that it doesn't get written to the log.

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 26, 2012 at 4:29 am

    #1438679

  • RE: SSIS 2K5 - Merging Data Between Databases

    I don't think my company will pay that amount of many for a additional tool. 🙁

    Thanks for the suggestion though.

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 10, 2012 at 4:34 am

    #1430993

  • RE: SSIS 2K5 - Merging Data Between Databases

    I was actually thinking the same thing. Where data is transferred (bulk insert) to an empty temp table. And then using Stored Procedures one could perform complex T-SQL update/insert processes.

    Thnx

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 9, 2012 at 10:03 am

    #1430641

  • RE: SSIS 2K5 - Merging Data Between Databases

    kramaswamy (1/9/2012)

    Using SSIS, first put an Execute SQL Task, and do a query similar to "UPDATE sSET m.Fields = s.Fields FROM SubDB m JOIN MainDB s ON m.ID = s.ID"....

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 9, 2012 at 9:27 am

    #1430596

  • RE: SSIS 2K5 - Merging Data Between Databases

    Sounds like a plan.

    But please note that the databases are on different servers.

    This is why I think SSIS is needed, instead just stored procedures.

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 9, 2012 at 8:58 am

    #1430552

  • RE: SSIS 2K5 - Merging Data Between Databases

    One would think with all the intelligence at Microsoft they would be able to provide us with a very simple item that enables the data two tables to be merged...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    January 9, 2012 at 1:01 am

    #1430296

  • RE: SQL Server 2K5 Service Broker

    Ok so here are a few solutions I found all on my own.

    Make sure that:

    1. the BrokerID for the databases on the instance are different

    2. the Broker is enabled.

    3. the...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    May 9, 2011 at 3:11 am

    #1321592

  • RE: SQL Server 2K5 Service Broker

    All the examples I saw so far creates a new database. I have not seen ONE example where they show you how to setup up the service broker on an...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    May 6, 2011 at 1:30 am

    #1320819

  • RE: Global Variables for SQL SERVER 2005

    @ hallidayd - sending message between the two system is possible but for the unique way the two system operate it wouldn't really work.

    Seems like the best solution would...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    October 14, 2010 at 7:31 am

    #1236838

  • RE: Cached Query Plan ...

    Just another question guys ... does rebuilding indexes have any effect on the cache query plan of a procedure.

    I was just wondering cuase we had a few incidents where...

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    October 7, 2010 at 6:50 am

    #1233487

  • RE: Cached Query Plan ...

    Thanks for the help guys.

    Will be having celebration cup of coffee soon! :w00t:

    [font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
    😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
    -----------------------------------------------------------------------------------------------------------------------[/font]

    October 7, 2010 at 3:25 am

    #1233345

Viewing 15 posts - 1 through 15 (of 67 total)