mickyT (5/25/2014)

---

Hi Lynn

For a start I am no expert on these things.

I couldn't find anything overly specific regarding this, however given the amount of times I saw that using the...

Actually migrating to SQL Server 2008 R2 and it is what we are authorized to put on the network out here in Afghanistan....

Jeff Moden (5/25/2014)

---

Lynn Pettis (5/25/2014)

---

Realize that you lose any benefits of having an index on the TransDesc column. If you can, you may want to consider adding a persisted...

Realize that you lose any benefits of having an index on the TransDesc column. If you can, you may want to consider adding a persisted computed column that stores...

Edit: Wrong thread.

Jeff Moden (5/23/2014)

---

Ahhhh.... be careful folks. This table is a 300 MILLION row table according to the op. Even with as narrow as it is, that could take...

Sean Lange (5/23/2014)

---

Maddave (5/23/2014)

---

Thanks. That doesn't work unfortunately and still performs just as badly.

Just talking this problem over on this forum, I think I have solved it by using...

yuvipoy (5/23/2014)

---

actually beyond 98 mb the trace stopped.

i mark the trace for 10 hour , it ran only for 7 hours which reached 98 mb after that there is...

Nassan (5/21/2014)

---

i have migrated a database from ms access to sql server and application developer is not available. i was told migrate database from access to sql server and...

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is...

I could use some assistance over here: http://www.sqlservercentral.com/Forums/Topic1574043-146-1.aspx.

Thanks in advance.

A good place to start is right here: http://www.sqlservercentral.com/articles/SQL+Server+2012/87518/

How often does this problem occur? I have run your code multiple times in my environment (11.0.3128) with no problems.

Nassan (5/21/2014)

---

i have migrated a database from ms access to sql server and application developer is not available. i was told migrate database from access to sql server and...

webrunner (5/21/2014)

...

Thank you for your response, Jeff!

Yes, I am working on a test server. I just want to be confident that when I submit all these changes to production that...