Forum Replies Created

Viewing 15 posts - 10,486 through 10,500 (of 11,678 total)

  • RE: Performance tuning a self Join

    dkschill (1/12/2011)

    You could use the EXISTS statement:

    DELETE FROM TableA WHERE EXISTS (SELECT 1 FROM TableB WHERE TableA.Key = TableB.Key)

    This is just plain wrong. If TableA and TableB are the same...

    January 13, 2011 at 6:39 am

    #1272988

  • RE: Error creating Excel file.

    Are you running the package from BIDS?

    Make sure the Run64BitRuntime property is set to False.

    (right-click on project, select properties, look in the debugging pane)

    January 13, 2011 at 6:32 am

    #1272982

  • RE: cpu bottleneck

    Dave Ballantyne (1/13/2011)

    Koen (da-zero) (1/13/2011)

    If it is such a crappy product, it is quite a shame that Microsoft pushes the use of the DTA through the certification exam. In those...

    January 13, 2011 at 6:27 am

    #1272979

  • RE: cpu bottleneck

    Grant Fritchey (1/13/2011)

    Koen (da-zero) (1/12/2011)

    TheSQLGuru (1/12/2011)

    I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that like the plague!!

    Just out...

    January 13, 2011 at 6:10 am

    #1272972

  • RE: Event Handlers Not working

    me_always (1/13/2011)

    There are no errors in the data flow.

    DisableEventHandlers property of DFT is set to false.

    How do i find errors related to event handler? Rather I think, this is where...

    January 13, 2011 at 5:23 am

    #1272956

  • RE: CONVERT function

    Toreador (1/13/2011)

    I use the one that is invoked by pressing F1 in SSMS

    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm#seeAlsoSection

    No links that I can see. Maybe I'll switch to using the interweb version.

    In the Help window you...

    January 13, 2011 at 5:12 am

    #1272951

  • RE: Difference between db_datareader and db_denydatawriter

    GilaMonster (1/13/2011)

    Koen (da-zero) (1/13/2011)

    Or do you deny access first to everyone and then give specific access to some resources?

    That won't work. Deny takes precedence over grant.

    Hmmm, you are absolutely right.

    I...

    January 13, 2011 at 4:07 am

    #1272933

  • RE: Event Handlers Not working

    Are there errors in the data flow so that the event handler should be executed?

    Are there any errors related to the event handler?

    Is the DisableEventHandlers property of the DFT set...

    January 13, 2011 at 3:58 am

    #1272926

  • RE: SSIS Package for Scrambling SSN Data

    Please read the link in my signature about needing a question...

    January 13, 2011 at 3:54 am

    #1272922

  • RE: Loading data from Excel file into SQL table

    Junglee_George (1/13/2011)

    Hi

    Try this useful link

    http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx

    :ermm:

    Did you read the original question? The link you provided just explains how to import data from excel using the OPENROWSET command. The OP has already...

    January 13, 2011 at 3:50 am

    #1272917

  • RE: Installing SQL Server 2005 on Windows 2008 R2

    Adiga (1/13/2011)

    IIS is a prerequisite for SSRS. If you do not want SSRS to be installed, you can safely ignore this warning. This does not affect installation the other services/components.

    To...

    January 13, 2011 at 3:43 am

    #1272912

  • RE: Difference between db_datareader and db_denydatawriter

    At first sight they do indeed exactly the same.

    I think it has something to do with how you implement your security model.

    Are you giving everyone access first and then deny...

    January 13, 2011 at 3:41 am

    #1272911

  • RE: Adding secondary file path

    What are you trying to do? What are the errors that you get?

    What is your actual question, because I don't see any.

    By the way, there is a space between @...

    January 13, 2011 at 3:33 am

    #1272906

  • RE: Shrinking the tempdb DB

    Suri, if you were able to restart the SQL Server in single-user mode, your problem should already been gone away, as SQL Server drops and re-creates the tempdb when a...

    January 13, 2011 at 3:29 am

    #1272903

  • RE: generating or populating time dimensions

    gupta.sreekanth (1/13/2011)

    can u tell me in detail .......how to do that one in ssis......

    Sorry if this sounds harsh, but shouldn't you at least try it yourself?

    All the people on this...

    January 13, 2011 at 3:17 am

    #1272895

Viewing 15 posts - 10,486 through 10,500 (of 11,678 total)