homebrew01 (3/18/2011)

---

"...I'm wondering is my tlog backup is actually usable to restore to any point in time during the day. ..."

Only up to the point of your most recent t-log...

Tx, keep 'em coming!

My problem at this cie is they since I'm not "certified", what I say doesn't matter.

So I'm hoping to get more tractions with your comments and experiences :w00t:.

My point is...

was wrong... tx Steve

Any way you can use the 1st column in the where??

You might consider making an extra index with column 3, 2 in that order.

Assuming column 3 is selective,...

Ya, find ways to avoid doing that search. OR find other conditions that you could add that could use a filter.

OR do it like so where col like...

Check out this amazing article by Gail, that's what I do to solve performance issues. Usually takes less than 1 day of work over 1 week on most systems...

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

simonjday (3/17/2011)

---

I agree that it don't make any sense to have them to tune the db

This is a DB that we have a performance issue with and when i...

What's the point of creating normal views to tune the db????

More to the point, you won't have ANY gain if you...

The only idea I have right now is to check used / unused indexes scripts based on the clustered index. That should give a fair-ish assessment.

The real question is...

you can try using expression 4 / 2.

That will tell you if you have some sort of display issue.

If that works, change the 4 to the first column and test...

Jacque.Murrell (3/17/2011)

---

Try this, it came from one of my favorite SQL books, SQL Queries for Mere Mortals (second edition). Use the ESCAPE option.

SELECT ProductName, ProductCode

FROM Products

WHERE...

you need 3 tables.

Books

Authors

BooksAuthors

BooksAuthors will contain the id for the book and the author. You can add as many lines (authors) as required there for each book.

What do YOU, personnaly like to do???

That's the only question that matters! Period.

is250sp (3/16/2011)

---

I just want to add that if i write it to a temp table and requery WHERE CI is NULL then it works, however, in this instance I do...