Paul, there's also the possibility that he's backing up to the same file without using WITH INIT, which is why I asked him to run RESTORE HEADERONLY. This is...

Well, if this hasn't been working for two months, chances are that you really do have a log file that's so large that you can't fit the backup on your...

Point taken, Drew - I should have phrased it better and said "your code would be clearer if" rather than "you need to". You're right that there's no syntactical...

You need to handle all eventualities once and once only in your case expression - something like this:

...

CASE WHEN Interval < 1 THEN 'X'

WHEN Interval >= 1 AND Interval <...

Something like this?

DECLARE @Years nvarchar(12)

SELECT @Years = CASE @@LANGUAGE

WHEN 'us_english' THEN N'years'

WHEN 'Français' THEN N'ans'

WHEN 'Español' THEN N'años'

-- etc

-- etc

END

John

Horses for courses. I use INFORMATION_SCHEMA views because, in many situations (such as the one in this thread), they expose all the information I need in one view, without...

As Chris says, nobody's laughing or joking - just trying to talk you out of what would be a bad idea.

Is the "Lead" you refer to a technical lead? ...

Thanks Gail. If anyone else is reading this and is struggling with it as much as I was, here's a full discussion:

http://www.sqlskills.com/BLOGS/KIMBERLY/post/UnderstandingDuplicateIndexes.aspx

John

GilaMonster (8/23/2012)

---

No. The include columns are what you specify in the INCLUDE section of the index definition

"Each index row contains the nonclustered key value, a row locator and any included,...

opc.three (8/22/2012)

---

Is this to say that in a not unique index that SQL Server will attempt to insert new index entries with an existing index key in the order of...

GilaMonster (8/22/2012)

---

The thing is, they're not quite the same indexes. The unique index (for reasons of index architecture) is essentially an index on the key column, include the clustered index...

Juanita

Can I just clarify - are both indexes on the same single column?

To answer your question, I think you need to assume that one of the indexes was created unique...

You won't get any performance improvement from doing this, and will just end up with a load of objects you don't need. I advise you not to do it.

If...

Don't use Profiler. Set up a server-side trace. It uses less resource than Profiler.

John

Did you restart the Integration Services service after making the change? Is the SQL Browser service running? Do you have a named instance, or a default instance? ...