SQL Server Performance

Search Results

Search Again
Page 1 of 2
  1. tboonleong

    SQL clustering + replication

    Thread by: tboonleong, Aug 28, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS
    I need to setup the transaction replication on the Active-Pasive clustering environment . How I am going to setup the distributor and publisher at...
  2. tboonleong

    SSIS OLEDB connect to AS 400 and keep promting for entering the password again and again.

    Thread by: tboonleong, Jul 11, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS
    The SSIS package using the connection of "Native OLE DB\IBM DB2 for i5/OS IBMDA400 OLE DB Provider" tp connect to the source (AS400 server) to...
  3. tboonleong

    powerful update sql statement?

    Thread by: tboonleong, Jun 24, 2008, 4 replies, in forum: SQL Server 2005 General Developer Questions
    STAGING TABLEA SeqNO, PolNo, pcode, scode, Amt1, Amt2 1, polABC, p1,s1,100, 200 3, polABC, p2, NULL ,NULL , 300 8, polABC, p3, NULL , NULL,...
  4. tboonleong

    oderby and oderbyattribute

    Thread by: tboonleong, Jul 20, 2007, 2 replies, in forum: SQL Server 2005 Analysis Services
    Anyone know what is the differnt between oderby and oderbyattribute property for a dimesion? How to apply oderbyattribute and what situation can use...
  5. tboonleong

    Script component

    Thread by: tboonleong, Jun 5, 2007, 13 replies, in forum: SQL Server 2005 Integration Services
    I faced the rror msg when creating script component with scripting as below: The related error msg: 'Output0Buffer' is not a member of...
  6. tboonleong

    Simple Cursor for SP

    Thread by: tboonleong, Jun 4, 2007, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Hi, I am new to tart writing Store prod with cursor. I encounter the following simple issue. Hope able to get help from you all. Thanks. Code for...
  7. tboonleong

    all member property

    Thread by: tboonleong, May 22, 2007, 0 replies, in forum: Analysis Services/Data Warehousing
    Month Dimension: All Month --Jan --Feb . . . --Dec All memeber property for month dimesion configure as mdx below :...
  8. tboonleong

    All Member Formula property

    Thread by: tboonleong, May 18, 2007, 6 replies, in forum: SQL Server 2005 Analysis Services
    In Anlaysis services 2k version, a dimesion have a 'All Member Formula' property for configuration suing mdx express. But I ssas 2005, I can not see...
  9. tboonleong

    Sqlbrowser host name

    Thread by: tboonleong, May 14, 2007, 12 replies, in forum: SQL Server 2005 Analysis Services
    When I want to browse the cube data using MS SSAS, the error show as below: Error in the OLE DB provider.Could not connect to the redirector.Ensures...
  10. tboonleong

    How to check which user is connecting to server?

    Thread by: tboonleong, May 13, 2007, 5 replies, in forum: General DBA Questions
    The production server will restart . Before restart the production server, may I know how to check which user is conncecting to the server. Where can...
  11. tboonleong

    ssis and dts? how ?

    Thread by: tboonleong, May 9, 2007, 2 replies, in forum: SQL Server 2005 Analysis Services
    how about the SSIS (version 2005)and DTS(version 2000)?Can install at the same server at the same time?
  12. tboonleong

    SSAS and Anlysis service at same server?Can?

    Thread by: tboonleong, May 9, 2007, 2 replies, in forum: SQL Server 2005 Analysis Services
    Can the ms analysis services (version 2k) and MS SSAS (version 2005) installed in the same server together at the same time. thanks.
  13. tboonleong

    how to open SSIS from sql db

    Thread by: tboonleong, May 9, 2007, 4 replies, in forum: SQL Server 2005 Analysis Services
    I had create the SSIS project and deploy it into sql database. May I know How to open the project from the sql database that i deployed. I not sure...
  14. tboonleong

    datetime and smalldatetime format

    Thread by: tboonleong, May 8, 2007, 13 replies, in forum: SQL Server 2005 General DBA Questions
    The SQL have default format for the datetime and smalldatetime data type. 1)May I know where to check the default date format? 2)How to change the...
  15. tboonleong

    MDX for calculation measure

    Thread by: tboonleong, Apr 16, 2007, 1 replies, in forum: Analysis Services/Data Warehousing
    A cube with a Time dimension (RMK&gt;Year&gt<img src='/community/emoticons/emotion-5.gif' alt=';)' /><br />Eg: Time dimension <br /> RMK1 &gt;...
  16. tboonleong

    Package variable data type

    Thread by: tboonleong, Apr 10, 2007, 1 replies, in forum: SQL Server 2005 Integration Services
    I used the Execute SQl task editor with the statement as shown below and assigned the result to the variable NA_ID_DECIMAL which well declared. I...
  17. tboonleong

    data flow component

    Thread by: tboonleong, Apr 10, 2007, 1 replies, in forum: SQL Server 2005 Integration Services
    SELECT (CASE WHEN mUnit.OwnershipType = '001' THEN ISNULL (mUnit.LeasedStartDate,'1/1/1900') WHEN mUnit.OwnershipType = '002' THEN...
  18. tboonleong

    Install SQL 2005

    Thread by: tboonleong, Apr 5, 2007, 7 replies, in forum: SQL Server 2005 General DBA Questions
    I had install the sql 2005 and all were well done .Then I uninstall it again. But for the seconad time installation, the menu for SQL server...
  19. tboonleong

    MDX statement for creating a calculated members

    Thread by: tboonleong, Mar 22, 2007, 2 replies, in forum: Analysis Services/Data Warehousing
    Fact table:<br /><br />RoomIDAgencyIDNo of unit emptyNo of unit rented<br /><br />100101 1 0<br />100201 1 0<br...
  20. tboonleong

    Special case for data flow control

    Thread by: tboonleong, Mar 22, 2007, 1 replies, in forum: SQL Server 2005 Integration Services
    souces table: InvNo QTY SALES DISC 1001 3 300 20 Target table: InvNo Type Measures 1001 QTY 3 1001 SALES 300...
Showing results 1 to 20 of 38 Next >
Search Again
Page 1 of 2