Viewing 7 posts - 1 through 7 (of 7 total)
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...
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
February 1, 2012 at 3:11 pm
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...
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
July 7, 2011 at 8:02 am
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...
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
July 6, 2011 at 5:06 pm
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
July 6, 2011 at 9:14 am
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...
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
July 6, 2011 at 8:25 am
This worked for me.
General:
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 ...
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
June 27, 2011 at 3:57 pm
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...
Chad E. Downey, CDMP - Certified Data Management Professional
Consultant - SQL Server, SSIS, SSRS, SSAS
July 11, 2007 at 10:55 am
Viewing 7 posts - 1 through 7 (of 7 total)