Hi,

Looks like you are very new to this joins, Instead of starting directly working the SQL ANSI joins, it would be nice to practicse on simple joins and later get...

Hi

“GO” is a batch terminator. Technically speaking, the GO command is not even a part of the Transact-SQL language. It is really a command used by the SQLCMD, OSQL and...

Hi,

Can any one give some simulation lins on this exam.

Thanks -- Vj

http://dotnetvj.blogspot.com

HI,

May i know answer to the below questions, to understand your requirement in Better way.

1) Are you joing Oracle tables/views with SQL Server over the Linked Server?

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Oracle RAC allows multiple computers to run the Oracle RDBMS software simultaneously while accessing a single database, thus providing a clustered database.

In a non-RAC Oracle database, a single instance accesses...

Hi,

The suggestion which i would like to you give is,

Table A is one-to-many relationship with Table B. So bring the Table B to the same cardinality of the Table...

HI,

On what basis you want to concatinate? if ou have one Million records, you dont want to concatinate all the rows into one single column!!!.

So what is your...

Hi,

To your first question use the below query

SELECT * From sys.partitions

WHERE OBJECT_NAME(object_id) = 'Employee'

I am not sure about your second query, Even i am also lookin for that.

Thanks --...

Hi,

The best thing is use DELETE command directly.

Thanks -- Vj

http://dotnetvj.blogspot.com

HI,

If you project your trhoughts in terms of money and flexibility to your management then they will agree. You need to tell them about long term benifit. Probably you can...

Hi

Indexes cannot be created in a vacuum. In other words, before you can identify and create optimal indexes for your tables, you must thoroughly understand the kinds of queries that...

HI,

Please post code and the same data, so that we can debug the problem. It looks there is some issue with datatype, wheer you are getting varchar and you are...

Hi,

Check out the below link

this has the solution for you.

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ExpressBackups

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

I agree with GSquared answer, coz this way you can save data and from performance point of view also it is good. But curious to know do you have partitions...

Hi,

You can even write the query in below fashion.

DELETE FROM

table_name A

WHERE

a.IdentityColumn <

ANY (

SELECT

...