It is an option in Index. I have always been curious to check how much indexes are that way, because the TempDb is already strained with some queries the developers...

Jeff Moden

Yes, that is our first bet- it seems like a instant exact replica of the Production Database-data and log included.

Thanks Ignacio for your point there.

JW, what is the...

MJ.

The link gives idea of how to control users who want to have access to the jobs etc. In my scenario I just want to have an 'user'- not a...

talltop-969015 very good point. Job security often gives false security to coast, and then you are caught off-guard down the road.

Amol, yes, he may be taken off guard, or may...

"How do you move a table to a different filegroup" is not a simple question, some of the senior DBA's that i have interviewed couldn't answer this question [Smile]

---------------

Amol

Granted, no...

if Senior DBA's do not know the answers to these questions, what were they doing at work, while gathering their experience?

I would expect the junior DBA with a modest experience...

GSquared

I had to stop reading as I was not able to stop laughing out loud

Good creativity

Dan

Jeff

Thanks for the analysis. It was very helpful.

We talked about the database system/model best suited to replace the backup/restore.

Now, would going with a new server be the only best...

talltop-969015

You asked some simple 'baby' questions.. here they are..

*Difference between delete and truncate

*What is identity column?

*Login vs User

*What are Collations

*CAST Vs CONVERT

*Union Vs Union All

*What is ANSI

*View vs Table

*SPs...

I created a SQL Login, and created the user for that login in the required databases, and also granting permissions for the Login on the few objects in the databases;...

Thanks Ramu

Thanks Bru.

Bru

When I tried to restore it into DB2, I get this message:

The file 'c:\OVE\OVE_Data.ndf' cannot be overwritten. It is being used by database 'OVE'. [SQLSTATE 42000] (Error 1834) File 'OVE_Index'...

ChiragNS

I was meaning non-clustered indexes.

Dan

ramuvanparti

your were suggesting the RO DB Snapshot, because it will be easy on deadlocks/locks for reporting?

thanks

Dan