Hi,

I think in my pervious post i explained the question in much better way.

No i did not get what i need from u all.

from

Killer

Few days back i was interviewd and was asked a question

the Question is below?

THE DBA need to tranfer data from one table from the database to other table of...

did u enbabled these option on database level

HTH

killer

Is there anyother way of doing?apart for all this.

from

Killer

Hi bkelley,

That is what i need to know.When we should create a clustered index or non clustered index.

If i had a table with 16 GB of Data with 87 columns.

Do...

Thanx a lot.

pls also help in my other posts.

from

Killer

Hi,

It is confusing.Can u pls explain more clear.

from

killer

Hi, Thanx for the reply.

But u did not answered  any of my question asked.

The discription cant help me.

from

Killer

Hi,

How are u uploading the data from file.

HTH

Killer

Hi Dear,

DBArtisan is also a good DBA tool.

Start writing SP for ur full Database Backup.Tlog backup on a standby server with good spec.

or Create DBMP and delete the backup enough...

Hi,

To get the accurate size execute first

sp_updatestats ,dbcc updateusage

then u can use sp_spaceused

or

SELECT [TableName], (SELECT rows FROM sysindexes s WHERE s.indid < 2 AND s.id = OBJECT_ID(a.[TableName])) AS [Rowcount],

[Total_space_used...

Hi ,

Logical Scan Fragmentation is the percentage of out of order pages in index.

The only way to reduce logical fragmentation is to create the index again.

If there are lot of...

Hi,

AWE =Address windowing Extension.

When this option is enabled on sql server EM.Then SQL server uses more RAM.

U also have to edit the boot .ini file and add /PAE or /AWE...

Hi,

Have u selected both the processor in ur sqlserver property task.

Have u enabled awe for 4 GB memory usage.

HTH

Killer

Pls provide the trace name u are executing.

from

Kiler