Viewing 7 posts - 1 through 7 (of 7 total)
Iggy-SQL (6/15/2011)
June 15, 2011 at 12:05 pm
Go to the event handlers tab, select the package root, create "OnPreValidate".
Add a Script Task, language C#, and paste the following main function:
public void Main()
...
June 14, 2011 at 5:34 pm
alexms_2001 (6/14/2011)
> Integers are the default data type SQL Server
... and we know it how?
This is what the question was all about, but googling for something like "sql server...
June 14, 2011 at 4:17 pm
Jeff Moden (4/28/2009)
Percent of what? Percent of BATCH??? That absolutely cannot be trusted. Only actual cpu usage, duration, reads, and writes should be used to measure performance.
[p]Actually,...
April 28, 2009 at 5:27 pm
rob.lobbe (4/28/2009)
declare
@date datetime,
@today datetime,
@tonight datetime
select
@date = getdate(),
@today = convert(datetime,convert(int,@date)),--use smallint for smalldatetime
...
April 28, 2009 at 5:09 pm
Paul White (4/28/2009)
It sounds as if you are quoting percentage batch costs from the execution plan.
The results were from batch queries, 100 each with random dates for each iteration, I...
April 28, 2009 at 4:40 am
guess we could always just run both methods over a largish table and get stats out of the query analyser (like cpu usage, etc)
I did exactly that, using the small...
April 28, 2009 at 3:01 am
Viewing 7 posts - 1 through 7 (of 7 total)