1. do you want to change color of row or word

2. will this word come in any particular column or any of the existing columns

Hi,

For the SSAS in general goto this link

http://www.databasejournal.com/features/mssql/article.php/1429671/Introduction-to-SQL-Server-2000-Analysis-Services-Creating-Our-First-Cube.htm

and for MDX scripting see this link

http://www.databasejournal.com/features/mssql/article.php/1495511/MDX-at-First-Glance-Introduction-to-SQL-Server-MDX-Essentials.htm

Thanks Gromey,

Let me try to troubleshoot this issue using your advice.

zeeyenyes4u, as far i can say both are different faces of coin. If will do disaster recovery by making your server as high availability, and once set as high avaialability...

Make sure if you are trying to display any property of your dimension, you should do it as =Field!<<dimentionname>>("propertyname") instead of =Field!<<dimensionname>>.Value

If you are happy to delete rows in both the table, then you can go with cascading delete.

Is there any predefined plan about what you want to do with Table2 rows which are linking to deleted row from Table1. Do you want these rows in Table2 be...

It is quite good question for initial telephonic interview. And you can give simple answer by

1. CONVERT is SQL speicific but CAST is ANSI standarised

2. CONVERT deal nicely with...

One very common question asked by interviewers is:

CAST versus CONVERT in SQL Server

breakable

Apology, it will be more understandable if you provide sample data and table structure.

Thsts all depend on new application requirement. If you feel client you can keep client happy with using SQL Server Reporting Services front end that is wonderfull and will avoid...

As per my understanding NOLOCK table hint will not put shared lock so will be good to avoid deadlocks and will increase query performance. But have to make sure that...

thanks Lamprey13 for refreshing brain cells with this nice feature of SQL Server

It is always appropraite to follow coding standard properly documented. This document should be either provided by client and followed religiously by you OR created by you and approved by...