CirquedeSQLeil (4/5/2010)

---

Garadin (4/5/2010)

---

As of right now, our entire DB is in one file/filegroup. Would splitting this into multiple files provide any benefit in this regard? They'd all still...

Thanks again Steve. I think I might actually (for this one table at least) play with the idea of vertical partitioning and see how it works out. I've got...

As of right now, our entire DB is in one file/filegroup. Would splitting this into multiple files provide any benefit in this regard? They'd all still be on...

Jeff Moden (4/4/2010)

---

My first inclination is to invite the officers of the third...

I think it's a great thing that you can get some really great performing well thought out solutions on the forums and they should definitely be suggested. Whether or...

Unfortunately this isn't reporting or I'd do just that. The access is done from a front end forms module. The same forms that pull up data do the...

Robert L Miller (4/4/2010)

---

Take a look at the Trigger at make sure it is not running a cursor or some other activity like referencing a remote table via a Linked-Server...

Hrm, the faster disks is an option to explore....

If it's a relatively short trigger, posting the code for it would help as well.

I've read several of that guys articles, good stuff. 😉

Greg Snidow (4/2/2010)

---

What I am looking for is a way to capture non-conformances based on Employee Name. However, the field that the name goes into is a text field...

It sounds like you don't have all that much data that you're working with. Obviously a case statement explicity listing all the different variances would be out, but here...

One thing to try would be to do all the joins to the local tables first and populate variables with the information, then send across the update to the variables...

Also, have you checked the index usage DMV to see if all of those 20 indexes are actually being used?? Have you compared their create scripts to see if they...

renu.iitkgp (3/31/2010)

---

Dude, that was a mistake in changing the name of the table, before copying the piece of the code and removing company specific info and other parts, not concerned...