Koen Verbeeck (5/12/2014)

---

Jack Corbett (5/12/2014)

---

What do you mean by "the Wizard"? The import/export data wizard in SSMS?

I think what you will need to do is to code...

Jonathan Kehayias has a query on this blog post[/url] that identifies parallel plans in the cache which can help you start tuning the SQL that might be causing the CXPACKET...

It makes sense to me that adding indexes would greatly slow down replication. Think about it, for each index SQL Server has to make a copy of the data...

Pretty sure you are stuck. I'm not sure how SSRS would tell Excel the size that column needs to be for each row.

have you tried referencing the textbox that contains your totals using the ReportItems collection?

What do you mean by "the Wizard"? The import/export data wizard in SSMS?

I think what you will need to do is to code the package in BIDS/SSDT-BI and when...

bsr.anwar (5/8/2014)

---

I created the trigger successfully but when I tried to update the table the query doesn't execute it prints out

error stating that

Msg 15281, Level...

Carlton,

I'm sure you could have the Script Task (Component) do it. You would need to to be a destination and not a transformation and then make sure you handle...

I think this is what you need:

=Round(

(

IIF(Fields!STypeName.Value <> "SS" AND Fields!STypeName.Value <> "UA",

Fields!SDuration.Value/2,

SUM(Fields!VDuration.Value + Fields!SDuration.Value))

/60

)

,2)

This does:

IF Fields!STypeName.Value is not equal to "SS" or "UA" THEN

...

Good editorial today. I want 3 things from a manager:

1. Direction - I don't always want to be picking my tasks, I want to know what needs to...

David Burrows (5/7/2014)

---

Not that I would normally disagree with a master 🙂 but my second...

Accidentally hit quote on my own post and can't delete it.

So you would need to setup the application for trusted authentication and have Kerberos set up so that the connecting user is being passed through to the database in order...

The example makes what you need much clearer. Neither my nor David's code does exactly what you are looking for. I believe that this is what you want...

Unique values in sys.partitions are defined by object_id, index_id, partition_number. There is at least one row in sys.partitions for each table and index on the table.