DonlSimpson (12/31/2014)

---

MMartin1 (12/31/2014)

---

How would this be different? Would you have fields in the table to denote first Tuesday of...

One of the tweaks I do is alter the max rows per batch and or commit size when transferring millions or rows with SSIS's, dataflow's ole db destination. This optimises...

I have to wonder why you need to use a batch file. Do you need to schedule the package with Windows Task Scheduler? I myself prefer the SQL Server Agent...

Do you have access to SSIS? You could query the data with the use of a data source component, of the dataflow task. It is much faster than a linked...

ikrami2000 (12/30/2014)

---

Steve, please don't give me your advice, if you need to help you will do, if you don't , just don't reply, because sometimes anyone can search...

How would this be different? Would you have fields in the table to denote first Tuesday of the month,...

Did you try building a dataset to calculate each default date that you want ? You could then use those data sets, one for the from date and the other...

Out of curiosity, any performance considerations with logon triggers that you are aware of?

KoldCoffee (12/28/2014)

---

pietlinden, in the end, the approach I took was to create the portion of the filename that holds the date using functions and concatenate it to the part of...

gissah (12/27/2014)

---

I am trending the current value on a chart. For example

=IIF(Month(Parameters!EndDate.Value) > MAX(Fields!OrderMonth.Value),

give me the current value by:

Let say Goal = 1000

Order month = month order was purchased

12=...

Create a table valued function that returns the delimited string as a column in a table. Join whatever table you are working on to this table (valued function) on the...

declare tmpcursor cursor for

select 'kill ' + convert(varchar, spid) as spid

from master..sysprocesses

where db_name(dbid) = @dbname

and spid <> @@spid

and dbid <> 0

Markus out of curiosity,...

In more detail, what exactly is the code 'supposed' to do ?

I think this is related to why I get faster results in SSMS when I export to text rather than to grid. The rendering engine plays a part in the...

Thanks for the feedback, glad this worked out for you.