Only by dropping the columnstore index as part of your batch process to update the data warehouse,...

There's no generic solution to these kind of issues, so people will need a lot more detail in order to help. I'd recommend having a read through this:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

and posting some...

Nothing to do with the CTE - you've got a BEGIN with no END

Steve Jones - SSC Editor (3/9/2012)

---

The iPad is arguable overpriced, but less capable products on Android still sold for similar prices. Those companies didn't want to sell for less....

I doubt it has anything to do with the 64-bit or running it in a SQL Agent job. There are definitely plenty of Unicode characters that won't convert to a...

Theoretically, you can, but I'd say this is a bit of a misuse of what configuration files are for.

They're generally to control the environment dependent values of a package, so...

Can I just clarify something as the details of this sound a bit odd:

I have a compressed backup from 1 SQL 2008 Standard edition. Trying to restore it to a...

Is the SQL 2012 launch event site down for everyone else?

Not the best advert for high availability 🙂

There is a wider point about whether a specific optimisation could be put in place for catch-all queries. It's true that there's no one plan that fits all for these...

PaulB-TheOneAndOnly (3/6/2012)

---

Even if there is an index on "timestamp" column it will not be used because predicate includes a function e.g. TO_DATE()... also, in this particular scenario doing a between...

It's worth noting that parameter sniffing itself is not really the problem here, it's that the conditional logic limits that types of plans that can be safely cached in the...

This is a classic catch-all query.

To work out why these can provide bad plans and what the possible solutions are, I recommend checking out Gail's comprehensive blog post on the...

fritshoutsma (3/6/2012)

---

I think i'm going to use the extra tabels.

Do you think it's an option to lose the central attachment table and just use CustomerAttachment, EmployeeAttachment and ProjectAttachment tables to...

Lowell (3/6/2012)

---

Anything wrong with having an "AllAttachments" table, and then a multiple linking tables that join the desired tables keys together?

So for example, if i decided to add an attachments...

None that I'd consider. I'm not sure why the number of tables would be a deciding factor; normalisation tends to lead to more tables.

You could have 3 nullable FK columns...