Eugene Elutin (5/15/2012)

---

Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources. Because table...

ByronOne (5/15/2012)

---

Sorry for being stupid but do you mean like the following:

=Switch(sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-2.5, "Green", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <=-5.0, "Yellow", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-5, "Red")

I've tried this but it seems to confuse...

Jeff Moden (5/14/2012)

---

Here's an example that serves me very well for some of the larger ETL projects I work on. Do note that you have to change "yourseverinstancenamehere" appropriately.

...

I am going to just say we are going to have to agree to disagree. I am not going to say that the Primary Key should most of the...

chandan_jha18 (5/15/2012)

---

Hi,

I had a procedure where there was a condition in where clause:

where ISNULL(d.[RejectReason], 0) IN (240,241,300,301)

The column RejectReason is int,null.

After going through several posts in this forum, I started...

Eugene Elutin (5/15/2012)

---

...

Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.

The clustered index should be on a better choice,...

Sean Lange (5/15/2012)

---

If you want some real help please read the following article. How to Post Performance Problems[/url]

Without some details there is <0% chance that anybody will be offer any...

You might want to try posting this on an Oracle site. Most of us here are using Microsoft tools to support MS SQL Server.

Been a while sinceI worked with Informatica, but one of things I remember is the lack of a looping construct. If needed, it required some interesting coding to implement.

I...

erics44 (5/15/2012)

---

Hi

Is there a way of viewing the tables in management studio by schema?

Id like to be able to expand and collapse schemas to limit the number of tables i...

Simon-413722 (5/14/2012)

---

errr.. the explaination says you cant update system tables on sql 2005 onwards. is this description really true?

I'm not saying its a good practice and Microsoft definitely doesnt support...

Jeff Moden (5/14/2012)

---

dan-572483 (5/14/2012)

---

I stand corrected. Now why would a developer use anything other than a datetime to store a timestamp? It seems to lead to more complexity...

Tim Walker. (5/13/2012)

---

I'm really sorry that my first post on this thread, which related to the lack of information from the OP, resulted in the thread going totally off topic!

The...

Well, we are still waiting for the DDL for the tables (including the index definitions), the code you are running, and the actual execution plans.

The downside to more indexes is increased time for inserts/updates/deletes as indexes have to be maintained. Hard to say if the impact will be noticable not since we can't...