Good news! there is an easy way out:

CREATE UNIQUE CLUSTERED INDEX pk_table(pkcol)

WITH (DROP_EXISTING = ON) ON partition_scheme(pkcol)

The key is the DROP_EXISTING = ON clause.

Now, if you plan to...

You have that information in sys.destination_data_spaces.

No, it is not a silly question. But to be sure that you have the very last log backup, you should put the database in single-user mode before you take...

mister.magoo (7/8/2013)

---

your original error may be due to SQL server attempting to enlist a distributed transaction and MySQL cannot take part in that transaction.

This would be because you are attempting...

Since the description you give is on a fairly high-level, it is difficult to give exact advice, but, no, from what you say I don't think indexed views is what...

This is not a simple problem, but mister.magoo is correct. The trigger way is not likely to work out well. First a few words on why the trigger you have...

Sean Grebey (7/2/2013)

---

I was asking because from what I understand if there is a clustered index non-clustered indexes use the clustered key, otherwise it uses the rowID (file number, page...

Have you considered log shipping?

How does the format file look like? Any chance you can attach the problematic datafile?

You could do away with the big CASE expression if you use the datename function:

datename(MONTH, ins.lasUpdateDate) + ', ' + datename(YEAR, ins.lastUpdateDate)

As for the actual problem, I assume that ins.LastUpdateDate...

If I understand the query correctly, the task is to find the RefKey for the interactions which INum is @INum, PromoOrRef is R, ResultStatus is 312 and DeleteFlg is N...

Yes, the data type for isnull is always the type of the first argument.

When you use EXECUTE AS, you impersonate a database user, not a server login and you are sandboxed inside your database. You can break out of the sandbox - and...

However, there is a major problem with...

shyam00 (7/5/2013)

---

Thanks for the reply.

Is there any way to tackle my scenario mentioned here.?

I need to combine (UNION) two non related derived tables and create an indexed...