Some clarification:

Are you using SQL Agent Job or SSMS Maintenenance Plan? It sounds like you are using both - so, correct me if I am wrong here.

I am guessing...

Are you running Enterprise Edition? If not, locking pages in memory won't do anything either - since Standard Edition cannot use it.

For your problem, what is the minimum memory...

And yet - you want to allow end users the ability to write ad-hoc queries? Even when you know you have a problem with developers (who should know better)...

Sorry - but I have to jump in here.

What happens to your OLTP web based application when a user submits a resource intensive ad-hoc query that blocks access to one...

Just a thought - but have you checked the SQL Agent service?

Well, if you really want to roll your own - how about Powershell and SMO. Yes, you still need to install both Powershell and SMO - but they are...

There are many ways to get this done - but, depending on where this is being done can have a performance impact.

One of the faster methods of getting...

The process you are going to need to following to shrink the log file is:

1) Change recovery model to simple

ALTER...

Mike,

Since you are already looking at Red-Gate SQLBackup, try creating a new backup using SQLBackup and compression to create a smaller file. Try restoring that file - copying that...

MALIK (3/3/2008)

---

HI

i just receive an email error msg from sql server by saying this..

The SQL Server performance counter 'Percent Log Used' (instance 'DATABASE') of object 'SQLServer:Databases' is now above the...

If you are on SQL Server 2005 - you can do everything you need to do in a maintenance plan. SSMS maintenance plans include a task called Execute SQL...

One more thing you might want to consider. Before running your backup set the database into single user mode then run the backup. This will insure that there...

My guess is that you are on a cluster. The drives have been added to the cluster, but not so that SQL Server can see them. On a...

Jason Selburg (2/23/2008)

---

Hi all, this may be a simple fix, but I can't find any documentation on it, and noe of the Management Studio options seem to affect it. It...

I think what you are going to need to do is have a separate column for each OR condition, for example:

SELECT

...

,case when...