ALTER INDEX ALL ON Production.Product

REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,

STATISTICS_NORECOMPUTE = ON);

Thanks!!

Well its fine if you click them until you are not able to open them. I reckon when we click on a database file be it mdf,ndf or ldf it...

Explain just files?

Also, if you say just files do you mean you are able to open them?

At last see the properties of the database to check the file names whether...

I would check the stored procedure that the reports run on. See if there is any blocking or you could try to look at the code of the sp and...

Did you configure DB Mail to use an SMTP server when creating the profile?

Thanks!!

Answer is NO, but-->

The bulk-logged recovery model increases the risk of data loss for these bulk-copy operations, because bulk logging operations prevents recapturing...

Why do you need to reindex everyday, that too entire database?

Anyways you can switch to bulk logged recovery before you begin reindex and once you are done switch it back...

You can always start with google and also bol. As and when you get issues with the setup you...

Does he intend to mean that 2:1 ratio...

As a DBA always learn to say No and please Question as...

ichbinraj (2/10/2009)

---

Hi ,

I have 2TB database in production which has 1 MDF file ,2NDF files i am Planning to add one more datafile with out any down time...

gupta1282 (2/10/2009)

---

Sir I searched a lot of jobs for junior level or entry level sql server dba, but did not find any such job.

Could you provide me some onlie...

You can use MyReports folder to allow users to manage their own content.MyReports is disabled by default. One MyReports folder is created for each user. One user doesn't have access...

Access to the folder only

Thanks!!

I would check the terminal services connectivity to the rebooted system. Also to check how long your server that was rebooted takes to come back online.

You can ping the server...