Forum Replies Created

Viewing 15 posts - 46 through 60 (of 63 total)

  • RE: T-SQL

    leslaw (2/10/2009)

    All tables should have primary key, so it should also be created.

    Leslaw

    A useful general rule, but not always possible to implement:

    * When one of the columns in the candidate...

    February 10, 2009 at 3:08 pm

    #941693

  • RE: SET Functions

    webrunner (2/6/2009)

    Good question (though I got it wrong :(). The only quibble I have with the formatting is the use of the term "function(s)" in the question.

    The "(s)" doesn't make...

    February 8, 2009 at 9:37 pm

    #940259

  • RE: For Each Enumerator

    It sounds like the package can't access the password because it's encrypted.

    You may need to look at the Security -> ProtectionLevel on the Package.

    Since you're running under a different user,...

    February 8, 2009 at 5:56 pm

    #940236

  • RE: How to Drop Unused Empty Redundant columns

    This could be a very risky script for people to use for two reasons:

    * Column Names are typed SYSNAME, which is NVARCAHR(128) , not VARCAHR(30)

    * You use...

    February 5, 2009 at 6:40 pm

    #939282

  • RE: Two scripts to spell out numbers in words

    Unfortunately, your return string is not quite big enough:

    SELECT dbo.fnSpellInteger ( 1999999999 )

    Gives me:

    One Billion Nine Hundred Ninety-Nine Million Nine Hundred Ninety-Nine Thousand Nine Hundred Ninety-

    The function would be better...

    February 4, 2009 at 7:02 pm

    #938558

  • RE: records with distinct IDs

    Jeff Moden (1/29/2009)

    Tim Wilson-Brown (1/29/2009)

    Lowell (1/28/2009)

    in that case, it is impossible, unless you modify your table to include an identity column.

    Which is not reliable either - what if the identity...

    February 1, 2009 at 2:39 pm

    #936206

  • RE: records with distinct IDs

    Lowell (1/28/2009)

    in that case, it is impossible, unless you modify your table to include an identity column.

    Which is not reliable either - what if the identity values wrap?

    There should be...

    January 29, 2009 at 8:08 pm

    #935237

  • RE: Keeping user database in memory

    Going a long way back to one of LCAD's initial posts:

    LCAD (1/22/2009)

    2 Gb is indeed tiny, but this only the operational data (history now is 3 GB and will continue...

    January 29, 2009 at 3:18 pm

    #935134

  • RE: How to Encript Password in SQL 2000

    Could you please post SQL Server 2000 questions in the SQL Server 2000 forums next time?

    January 28, 2009 at 3:31 pm

    #934273

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    YSLGuru (1/27/2009)

    Even though there are 2 distinct sides on this matter of this being a Bug in the Replace() function or something By Design, I do believe we are all...

    January 27, 2009 at 6:48 pm

    #933584

  • RE: Keeping user database in memory

    serge.kovacs (1/26/2009)

    Maybe I wasn't clear on the inner workings of the application on start-up. It will load all data from all tables so there should be no need to use...

    January 26, 2009 at 10:25 pm

    #932991

  • RE: Dynamic Excel destination

    Alvin Ramard (1/26/2009)

    Set up your connection manager with static path. Then, before the actual export, use a script task to change the connection string of the connection manager.

    You could...

    January 26, 2009 at 9:59 pm

    #932987

  • RE: Keeping user database in memory

    serge.kovacs (1/22/2009)

    Indexing shouldn't be a problem. Every table has a primary key and is only accessed via this key (except of course for the initial load...)

    It sounds like you've just...

    January 26, 2009 at 5:04 pm

    #932910

  • RE: Getting yesterday's data using SSIS

    You need to use the second expression I gave you, and substitute your expression for yesterday where I put [Yesterday].

    Then you need to check that you actually get the results...

    January 21, 2009 at 10:37 pm

    #930888

  • RE: Getting yesterday's data using SSIS

    The suggested VB solution could be very slow because it involves generating each of the times separately.

    Here are some other options:

    Filter On Yesterday's Date/15 minutes by using a SQL Query...

    January 21, 2009 at 9:52 pm

    #930880

Viewing 15 posts - 46 through 60 (of 63 total)