Hi

SQL Girl

Try Ur setup on another PC or try an other setup cd/Dvd on same PC.

Hi

Simply policies get lost on new server of old server.

Hi

Visit following link for a good solution.

http://www.sqldisco.com/?p=57

Thanks Craig Farrell and All Others, its enough to me, to get an idea of DBA lines.

thanks

hi

visit

http://blogs.msdn.com/b/craigfr/archive/2008/07/15/partitioned-tables-in-sql-server-2008.aspx

Hi

Mohammad let us know u done the Vertical OR Horisental partitioning.

and In my opinion issue a select query to know where apropriete data entered?

Hi

Jeff Moden

Actually Its an other topics the DBA line, but right now my question is to get a Job in any DBA line , Coz I'm new and dont know...

Hi

For more detail visit microsoft.

Hi

U can check Ur query against database by using DTA and refer the result to change in query if possible.

hi

U can refer any testing software also, for time managing and better result. I refer transcender for mine exam.

Hi

Suresh B. I'm agree with U 'Positive thinking.....' actually I have worked a lot with SQL Server But it is on Practice level, not on Enterprize level, actually I'm Looking...

Thanks for reply

I think, to change Job track is some difficult.

Regards

Ali Tailor

MCTS MSSS2k8

I'm agree with Steve Jones - Editor

Regards

Ali Tailor

Hi

U may use this syntax:

DBCC shrinkfile (mylog,200)

Where 200 may your desired MB.

But in my opinion shrinking file/s is not a solution, it effect the performance.

Yes, the above link is perfect.