What do you pass to the @TrainerID argument when you have multiple selection?

Idea:

As you describe, you already know which file is causing the fail.

You can create a separate package just for that file and add a data tap for that package (see...

By running the job it starts a session. What you need is find the spid and execute

KILL spid

USE msdb

GO

EXEC dbo.sp_help_jobactivity

GO

you can find the job and see some details of it.

Regards,

IgorMi

IT researcher (1/22/2014)

---

I have already asked some questions about Autogrowth and shrink. But I have some doubts related to it.

1)I have a database which grows about 300 MB every...

I don't know where is that property, but D-Durability cannot be guarantied for tempdb.

Regards,

IgorMi

Nadrek (1/21/2014)

---

Jeff Moden (1/20/2014)

---

My question would be, why don't...

Than, why do you need a code to iterate the tables? It does not make a difference iterating the tables constructing dynamic insert-statements and execute them compared to writing...

Is the number of tables for inserting into the Fact table fixed or flexible?

sql_ques (1/20/2014)

---

Hi,

I need to get monthly count of number of tickets closed. Is it possible to use COUNT() with DATETYPE field?

SELECT

ID,

Environment

,count((RT.[type])) As 'Type'

,convert(varchar(5),SD.StartDate,110) AS [Month]

FROM TABLENAME

GROUP BY Date,...

Hi,

I can suggest to you considering the Multicast component in SSIS. It makes multiple logical copies of data and can deliver it to multiple destinations.

Regards,

IgorMi

Hi,

The plan's EstimatedTotalSubtreeCost is equal to the EstimatedTotalSubtreeCost for the NodeId with zero value.

Regards,

IgorMi

No. It takes effect immediately.

Regards,

IgorMi

Nice question.

There are more than 20 features that are not supported.

I like SQL Azure.

Thanks,

IgorMi

Grant Fritchey (1/6/2014)

---

No, it's not a good idea to change it at the server level. Most of the time you get parallelism on queries that are not complex enough to...

Lokesh Vij (1/8/2014)

---

IgorMi (1/8/2014)

---

IgorMi (1/8/2014)

---

Lokesh Vij (1/7/2014)

---

Nice question Igor, but I am little confused about "Microsoft Naive Bayes Algorithm", as per the below link, this algorithm supports drillthrough as well.

Link:...