Post the view definition.

Yes, I'd have to agree with Paul. While the current set of attributes may be identical, they are drawn from different domains and I'd bet that there will be...

RAP does not really address the problems of DBAs, whose primary job is to maintain existing applications. RAP is about new application development, where someone has to decide exactly how...

Yes, once a db is case sensitive, it's ALL case sensitive. I don't see a lot of case sensitve SQL Server installations in the wild.

You should be able to...

How is this any different from an 'employees' table with a 'gender' column recording 'm' or 'f'?

Do x and y have behavioral or processing differences? All the...

Unfortunately in the real world these important things constitute only a small fraction of developers’ time, because most developers spend most of their time:

reinventing data modeling (i.e. choosing from among...

You can get the valid ones for 2008 by:

select * from fn_helpcollations()

This should be valid:

SQL_Latin1_General_Cp1_CS_AS

as an alternative, per:

http://msdn.microsoft.com/en-us/library/ms180175(v=SQL.90).aspx

Are you running 2008?

The default collation in SQL Server is case insensitive. You need to change the collation of either the columns, the table, the database, or the server to a case...

Post the execution plan for the query. Let's see where it's slowing down and that may give a hint as to why the performance varies. Are you running...

Some possible paths would be to either broaden his scope and move into an Architect position, or specialize and do consulting in a specific area like data security, performance tuning,...

In a typical development the schema design is done by a database guy who is obsessed with micro-optimization of individual tables. He fusses over minimizing table size and deciding things...

No one is going to travel to a site they don't know to pick up an unexplained error message. Get a screen shot and post it, or post the...

It's telling you that the columns in the input are longer than your table columns. You may have to make the columns bigger, or the error may actually indicate...

It may not like the "" because someone set QUOTED_IDENTIFIER ON. It's looking for an object name between the double quotes.