New Born DBA (5/8/2015)

---

J Livingston SQL (5/8/2015)

---

New Born DBA (5/6/2015)

---

I have this query which runs every night pulls 800,000+ records. I just wanted to know if there is a way...

Lynn Pettis (5/8/2015)

---

MMartin1 (5/8/2015)

---

New Born DBA (5/7/2015)

---

Lynn Pettis (5/7/2015)

---

New Born DBA (5/7/2015)

---

Well I hope you are OK. 😀

It isn't...

Eric M Russell (5/8/2015)

---

marcia.j.wilson (5/7/2015)

---

Eric M Russell (2/10/2012)

---

Another scenario is where the developer includes un-needed table joins and returns additional columns that are never referenced by the application or reporting...

New Born DBA (5/7/2015)

---

Lynn Pettis (5/7/2015)

---

New Born DBA (5/7/2015)

---

Well I hope you are OK. 😀

It isn't a system field,...

For the rest of us who would like more...

mohanraj.jsp (5/6/2015)

---

Dear Friend,

If you open the vs 2008 and add existing item also...

marcia.j.wilson (5/7/2015)

---

Eric M Russell (2/10/2012)

---

Another scenario is where the developer includes un-needed table joins and returns additional columns that are never referenced by the application or reporting tool. I've even...

I assume the tables are used directly instead of a view. Later, you could possibly add a view that combines date and time columns as one value. Any future uses...

I wouldn't mind having some sample data to determine if the original primary key actually made sense. As Jeff mentioned a temporal based partition means having some sort of...

I am wondering if the "#TEMPTABLE" you mention is created inside your code, in which this would fall into the realm of a stored procedure. For a simple lookup as...

I realise this has been answered but I did note in your example under options you list what appears to be the result of a triangular join.

I produced exactly those...

It seems we are not aware what version of SQL Server is at play here. Thus the error messages some have encountered. Also no images are in the zip file,...

Remember the clustered index represents the order of the table, the primary key represents what is unique about each row. They are not necessarily the same as you know by...

then I tried it with temp tables (two temp tables then the join) and boom, total execution goes way way down.

not sure what is going on here but I guess...

If you are working inside of SSIS, make certain there are no event handlers behind the scenes overriding what you are trying to do.