Ellen (1/23/2009)

---

I don't know why the original DBA created the log with 4 files. They are/were on the same physical drive so there was nothing gained. I have...

Not sure what you're...

Why do you think you have a performance issue?

Few questions.

Why is the tran log set up as 4 files?

Are the log files on a separate physical drive from the data files?

Likewise, is the drive that the log backups...

ashepard (1/23/2009)

---

I've been told to make database page size an even multiple of disk page size.

If you are working with short rows, like a domian table of values then...

See here - http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

Edit: don't use index hints unless you are really sure you know what they're doing and why the optimiser didn't pick that index itself.

The 20 is compiles/sec, not sec/compile. There's no counter...

Keena Ferguson (1/23/2009)

---

Gail,

You are correct ... I only copied the first few lines ... I have attached the entire results set ... I have been looking at the DBCC CHECKDB...

Is that the full output from CheckDB? It doesn't look like it. Can you please the full output. (If it's large, save it to a text file, zip and attach)

Good catch. I didn't even read the...

What you can do in VS is build that up as a string, assign it to a variable, do a debug.print (or equivalent) to get the string that will be...

I think I've found the major problem. You're missing brackets in the where clause. ANDs have precedence over ORs, so the way your where clause is written (with an or...

Zip it and attach it. If possible, for the actual exec plan, not the estimated.

The jpg doesn't have...

You say you're getting an error when calling that? What would the specific error message be?

It means you're calling a procedure, view or function from your procedure, and then from that proc calling another, etc 32 levels deep. Or it could be recursive with the...