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...

Since you have to resort to dynamic SQL anyways, don't bother with two statements and a temp table. You can do something like:

Declare @sql varchar(max);

Set @sql = 'Use '...

Whether or not you use simple or full recovery model is not dependent upon any features of SQL Server....