Case when name LIKE '%samsung%' then 'Samsung'

or are you trying to assign 3 different case conditions like:

Case when condition1 then result1 when condition2 then result2 when condition3

then result3...

Question a bit confusing, but here's a stab...

SSIS is for your dtsx packages, hosted in a SQL Agent Job Task to run on a schedule/once off.

select getdate() as TimeStamp

http://www.sqlservercentral.com/Forums/Topic1287903-392-1.aspx

no comment needed.

Excuse me if this sounds like a product punt, but BI Documenter from Pragmatic is an excellent documenter tool..

not sure what you mean with "a virtual one"...

Read up on the link I provided, also read up on PAE and /3gb switch for...

Identify the issues, determine if they can be corrected without downtime, investigate why the issues came up in production only but not in development of uat phases?

bit of a vague...

can i select "Boost sqlserver priority" and "use windows fibers(lightweight pooling)", Will there be a impact in the server having same no of processors and RAM?.

what will "AWE to allcoate...

as long as the DSV refreshes the updates from the source fields, I don't see any possible issues.

Question:

how does the source varchar table length just change on the fly? :ermm:

No worries, have a couple of those days myself.

not sure about books...

but

http://www.ipsure.com/blog/2010/clustering-ms-sql-server-2008-r2-on-vmware-virtual-windows-server-2008-r2-1/

http://clusterwhere.wordpress.com/2011/03/07/setup-microsoft-sql-server-2008-r2-failover-cluster-in-vmware-workstation-7/

Nice and easy - only because I've seen this as well.

Thanks for the question.

You need the Backward Compatibility Tools:

feature Pack: Microsoft SQL Server 2000 DTS Designer Components

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi

Microsoft SQL Server 2005 Backward Compatibility Components:

32 bit http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_BC.msi

64 bit http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_BC_x64.msi

is the hierarchy properly designed to ensure SSAS knows what the current and premembers are?