Glad to help Mike!

Could it be that is all the data in your sysjobhistory table?

The default for a given job is 100.

You can configure the amount of history that the SQL Server Agent...

smeye1 (9/14/2009)

---

I'm a DBA in New Orleans, LA, and I work for the Health Sciences Center. I concur that data is extremely important and guarding it with valid backups...

PAH (9/14/2009)

---

:unsure: Unfortunately it is not always us “Acidental DBAs” that need convincing. That manager you talked about needs convincing that buying SQL is not a panacea in itself. As...

Hi Tim,

Thanks for the great feedback.

Your psychic powers may have eluded you on this occasion but I guess you will just have to wait and see 🙂

Cheers,

It's like an OCD thing for some us 🙂

Interesting....

Have you enabled the FILESTREAM feature at the instance level i.e. did enable the FILESTREAM feature when you first installed SQL Server Express 2008?

Take a look at the following thread.

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/06/09/enabling-filestream-post-sql2008-setup-a-known-issue-in-sql-config-manager.aspx

You are correct in your understanding. The school of thought on this one is that because the size of the indexes in question is so small, there will be either...

Separate instances are sometimes implemented when a business wants to create clear separation. This may be for security reasons, compliance and regulatory reasons, or to create clear separation between software...

I believe that TOAD, from Quest software, can be used to administer multiple version of SQL Server as well as other DBMS's.

To find out more visit: http://www.quest.com/toad/[/url]

Keep in mind that the query you are currently using for your index analysis is only considering indexes...

I suspect that this is one of those "it depends" situations.

On the SAN kit I have worked hands on with, once a LUN has been defined you cannot "hot add"...

SQL Server Express cannot be used in a Log Shipping configuration as the Primary or Secondary server roles.

See the Microsoft SQL Server 2005 Feature Comparison for reference.

tosscrosby (8/12/2009)

---

The problem appears to be that the underlying files were not moved and the original server was rebuilt, destryoing the files. I would not have thought a attach would...

tosscrosby (8/12/2009)

---

Hi all. I'm relatively new to 2005 and trying to come up to speed. I have a full text catalog that is offline, apparently due to moving the database...