Thank you Michael,  Excellent article, this is definitely a article to  add as part of DBAS collection. 

It is not necessary to have Backup of Model DB if you have not created/added any object to model DB that you wish to be part of every user DB...

Chris,

One friendly an truely generous note.

When you are requesting details and members are trying to help you

with their thoughts and experience  in this great knowledge base, I request

you...

Hi Christian,

Welcome to DBA community.

After...

Why does the transaction log get so big?

Answer to this question in its simplest form is

Transaction log grows bcz. there are more transactions taking place in DB i.e. Database is...

Right Click Maintenance plan in Enterprise manager

MP History is 9th step in wizard, one after Report generate.

Select  Write history  to MSDB.dbo.sysdbmaintplan-history table

Select 1000 or whatever # or rows for this table.

Check this microsoft article

http://support.microsoft.com/default.aspx?scid=kb;en-us;q315062&sd=tech

Aaron I agree with your thoughts.

use of table variable or temptable for subqueries is good option. I thought I will come to that level in next post.

Thanks,

First thing you need to check here is appropriate

clustered and non clusetered index.

You need to consider the size of your table and

then if feasible create a non clustered covering...

Instead of regular reboot to fix the problem.

Try to Restore DB with good DB Backup.

If  this is problem with your user DB then keeping user db on primary

drive C...

Hi Diego ,

I will send you email in next few min.

I am Sql Server DBA-Developer with more

than 5 years of experience.

You can look at my 125 + posts in...

Microsoft has confirmed this problem.

Complete detail and workaround is provided

by Microsoft in following link.

http://support.microsoft.com/kb/303287/

In this case better use temp table to store the output

of  resultant row after inner join...

...like this

Select col1, col2,.....

into #temptable

From table1 A inner join table2 B

on .......

where ......

then apply...

Probably problem with Sql Server Agent.

Most of the time Stop and Start of Agent clears issues such as this one.

Hope this helps,

Create trace using Profiler for specific period of time with events tsql and SP.

Then collect the trace data in table and check with like on textdata column.   

This is one way to get...