Jeff Moden (8/6/2011)

---

I guess my first three recommendations would be...

1. Stop using a table variable for this. The data is way too big.

2. Partition the target tables...

bitbucket-25253 (8/5/2011)

---

Another approach is to "clean up" the duplicates by using a CTE. ....

Have not tested the above code on a record set as large as those you are...

Thanks for the input Ben. If I am going to re-index the table, would that help also?

Thanks opc.three. Somehow I got some inputs from you. Again, thanks for helping.

My concerns are:

1.) I want to know if each of the property specified in this connection string sample below is well suited for a clustered environment. e.g. The Connection Lifetime,...

Thanks for the response opc.three but I have read this similar article from here also:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring%28v=vs.71%29.aspx

However, if possible I...

I tried debugging it and saw the correct file output.

Thank you so much for the help guys.

Okay, I already got it. My only problem is how...

Sorting is not very trivial in VB.NET. You can use the following code to get the latest file:

Public Sub Main()

...

CozyRoc (2/24/2011)

---

James Tech (2/24/2011)

---

Hi everyone.

How do I create an SSIS package that will process the following items?

- Scan all the excel files from a given folder (*.xls).

- Get the latest...

frfernan (9/28/2010)

---

Hello James,

well, not all solutions work all times :crying:. That means that SQL Server solved the CROSS JOIN as a INNER JOIN, then changing the view source code has...

frfernan (9/27/2010)

---

Hello all,

I would suggest two changes to the original view, maybe these changes help.

First: really there is no need for a CROSS JOIN, the query could be rewritten using...

Hi Everyone,

Please see attachment for the Actual Execution Plan including the index details and etc.. This is both for the Sql query that is using the view and the underlying...

ALZDBA (9/26/2010)

---

the cross join is one thing

the function on the datetime column is another one. This causes no datetime index to be used !!

This conversion is also member of the...

raistlinx (9/26/2010)

---

Hi James,

Yes it does seem like your query (and ultimately the underlying view) is filling up the log file and the CROSS JOIN is the problem. Is it really...