Hi,

I tried a lo to get this but i couldn't find option in ERWin. Please let me know if you find one.

thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

If you are apply any functions like(i.e. ISNULL or COALESCE) this then the query will not give you good performance. Please be carefull on that.

Thanks -- Vj

Hi Dipak,

Check out the below link

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1098157,00.html

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

The simple way to see why it is not updating the base table is take the update query and replace all the variables with the values that you want to...

Hi,

Probably you may need to convert the data set into commong language format which is supported by ANSI and export the data and while loading the data into SQL Server...

Hi,

The guy asked me:

What is an index?

In database design, a list of keys (or keywords), each of which identifies a unique record. Indices make it faster to find specific...

Hi,

You can even try out with PIVOT functions.

http://technet.microsoft.com/en-us/library/ms177410.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

I agree with above posts on using BCP to export the data. This gives more flexibility and faster way to export the data.

You may want to check out the below...

Hi,

Its hard to say whther your design supports large volumes of data or not!. The way you should see your database design is by having set of Non-Functional requirements and...

Hi,

Simply you can use INSERT INTO

I am curiuos to know about why you want to do this?

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

NULLs confuse people...

Let's talk for a minute about what exactly NULLs do that cause this type of reaction. The first problem is that the definition of NULL is "unknown." So,...

Hi,

You can achieve this by having linked server in SQL Server.

Check out the below link

http://www.sqlmag.com/Article/ArticleID/22264/sql_server_22264.html

Thanks -- Vj

Hi,

Rather posting what is the equivalent tool in SQL Server, what is your requirement?

Oracle Datawarehousing -- is not a tool..

Oralce PL/SQL is not a tool -- its a language and...

Hi,

@@VERSION reports the edition to which you have connected.

that means may be your admin is giving you wrong information.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

if you are very sure about the values that you can have for that columns is less than 3 then you can go ahead with bit data type. But its...