Just to make your code a little cleaner,

DECLARE @T AS TABLE (y INT NOT NULL PRIMARY KEY);

DECLARE @cols AS NVARCHAR(MAX)

,@y AS INT /* not used */

,@sql AS NVARCHAR(MAX);

Note that...

If you are referencing a large dataset through a linked server, especially if used multiple times in a join condition, you are better served with a temp table. Also a...

You mention in your first post " process 500 records." I'd lile to know more what you mean by process.Are you transforming the data in the foreach loop? There is...

...

Oh... and I almost forgot (this one is a brilliant). They have some funky "automated" way of creating their DWs but it means that most dimensions are basically cookie...

You can also try getting the default value directly from the result of a dataset query. This is a fully dynamic way to get what you want :

SELECTDATEADD(d, -1,

DATEADD(q,DATEPART(q,getdate())-1,CAST(year(getdate()) AS...

Again, it is doing a clustered index scan (also known as a table scan) instead of using the nonclustered index you created on C6 (with no included columns) because the...

Try DBCC OPENTRAN to view any open transaction the machine you are currently connected to.

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...