As I mentioned earlier in this thread, the...

Please read the article.

I'll put what you gave into the suggest format, but there's a lot of info that I don't have. Also please post your expected results based off...

Sorry, but I'm not sure I understand what your question is

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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

Barry, I think he's talking about the "Additional Articles" that appear on the home page that are from TechNet, SearchSQLServer or other sites.

vgrimes: If you look at the notes beneath...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic743086-149-1.aspx

1/1/1900 is 0 as a date. It means that either you're explicitly inserting the value 0 or '' into that column, or there's a default of 0 or '' on...

Grant Fritchey (6/26/2009)

---

I wanted to be sure of the answer before I posted it, but it seems that SQL Server will most frequently pick the index with the most columns....

Ray Laubert (6/26/2009)

---

The question then becomes does SQL treat the selection of covering indexes the same way it does the selection of candidate indexes. left to right and stopping...

Do a last log backup and select the option "Back up the tail log, and leave the database...

Scott Coleman (6/26/2009)

---

So you're saying you have to count all the notes for an incident, and the sequence number of the one you're looking for is in the Custom_1 field?...

Grant Fritchey (6/26/2009)

---

And if things get REALLY bad, we'll just toss Gail into the middle of them. Although, that might be considered a cruel thing to do to a crowd......

rkwitcher (6/26/2009)

---

Thanks Gail, but I must get a recordset and choose the the correct record to get the NoteID.

-I have a list of notes on and incident.

-Someone selects...

shnex (6/26/2009)

---

Unfortunately the pk is a uniqueidentifier...but I asked you before about this and we agree that is better to put on the uniqueidentifier than not to put one at...