Vlad-207446 (9/4/2015)

---

on one of the places I worked a few years back, we had similar situation.

although we had an update/upgrade windows from 12AM to 6AM once or twice per...

The problem is that is that 1000 might be too many or too few.

andy.m.guscott (9/4/2015)

---

I'm sure there's no need for the view, I'd just loop on the identity coulmn(or another suitable indexed column) and delete where less than min(ident column ) + 2000...

Lee Linares (8/17/2015)

---

Jonathan,

Great script. Thanks for sharing. One small problem though is this line:

IF CONVERT(int, @ServerVersion) < 10

The issue is that SQL Server 2008 does NOT support sys.dm_os_volume_stats which was...

Perry Whittle (8/14/2015)

---

Jonathan AC Roberts (7/24/2015)

---

Hi Christopher

The script only calls xp_fixeddrives if the version of SQL server is below 2008, When the version is 2008 or higher it uses dm_os_volume_stats...

I've got to say the first thing I thought as I got halfway through the article was "my god they need some indexes on those tables". You'd be surprised how...

Hi Christopher

The script only calls xp_fixeddrives if the version of SQL server is below 2008, When the version is 2008 or higher it uses dm_os_volume_stats and reports on the mounted...

Thanks for the script, it looks useful particularly the queries that return the growth settings. I'll use it when I need that information. Unfortunately, sys.dm_os_volume_stats doesn't exist in versions of...

I've written a script which works on both SQL Server 2005 and 2008. I'm running it from a registered server group. It all works but for some reason I'm getting...

SimonH (7/6/2015)

---

...

I can improve performance by performing a soft delete (Updating a bit column(isdeleted)) and then purging the records at a more convenient time. This runs in a second but...

I think you can optimise this by using a CROSS APPLY and TOP(1). Doing it with this method you should be able to remove the master table from the subquery...

That's a horrendous complicated query! Personally I think it needs a complete rewrite.

But if you don't have time and want to improve the performance the first thing to check is...

27 seconds is quite a long time to delete from a table if the system is live. You could come across errors where inserts and updates are failing as the...

You could write a stored procedure to return the results, with a parameter of jobname. then just grant them permissions to execute the stored procedure.

What does it say in the history of the scheduled task?

Have you got the correct folder in the Start In option under Actions?