To be honest, leave it at Char(5). It's not a huge columns, there isn't a massive waste of space if the data is smaller. Make the column char(5) in the...

0

Primary key is part of your table design. It's the unique...

Query, table definitions, index definitions please.

Lynn Pettis (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

GilaMonster (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.

Systems here won't...

ChrisM@Work (4/22/2014)

---

GilaMonster (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.

Systems here won't let me...

ChrisM@Work (4/22/2014)

---

And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.

Systems here won't let me anywhere his...

ChrisM@Work (4/22/2014)

---

The question I'm asking is here - http://www.sqlservercentral.com/Forums/FindPost1563832.aspx and the query, to save you a few moments, is this:

select KeyInstn, MAX(dateendedstandard) DateEndedStandard

from ObjectViews..InternalOperCBGEstimate

where dateendedstandard <...

Maybe, what do you want to know?

I get the rush, but please remember we're all volunteers here.

With just part of the error log, really hard to answer, but the stack dump is a hint

Non-yielding IOCP Listener

IOCP...

Probably is.

Read-only filegroups in simple recovery, not read-write.

Nice error log. And???

Perhaps some background, some details, a question, maybe a please or thank you?

You can take file and filegroup backups in simple recovery, however unless the file/filegroup is read only, you won't be able to restore them and bring the entire DB online....

The row counts in sys.dm_db_partition_stats and sys.partitions are accurate. The old inaccuracies that sysindexes had don't occur. While the documentation for sys.partitions says 'approximate', the value is in fact accurate.

It's not about performance, it's about what meets your requirements.

Option 2 will only show the last user who changed the row and won't show what they changed. If you need...

You don't, there's nothing wrong.

The database is part of a Database Mirroring setup. It's a high availability feature...