Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Forecasting with SQL

    Hi Mark,

    Nice article on forecasting using T-SQL! I know it's been a while since you wrote this article but wanted to know if you think this technique would...

  • RE: Update Statistics

    Sorry, I should have been more specific. The index structure is not being updated, but the statistics about the index would be updated. My point really was that...

  • RE: Update Statistics

    Okay, just be clear I work with SQL Server 2005 right now so I went to 2005 BOL by default. My thoughts were not meant to be shallow, but...

  • RE: Update Statistics

    Got this wrong but... found in BOL 2005 the following remarks.

    Updates information about the distribution of key values for one or more statistics groups (collections) in the specified...

  • RE: Passing SSIS Package Variable To Stored Procedure As Parameter

    This worked for me.


    ResultSet - None

    ConnectionType - ADO.NET

    SQLSourceType - Direct input

    SQL Statement - exec dbo.proc_Name '2011-04-30','2011-04-30','2011-04-30'

    IsQueryStoredProcedure - False

    Parameter Mapping:

    Variable Name Direction ...

  • RE: Not for Replication seems to be ignored

    Hi Jay, I say your post about what can cause a cyclic loop between a table trigger and a replication trigger.  We seem to be having this problem because we...

Viewing 7 posts - 1 through 7 (of 7 total)