DBADave (1/4/2009)

---

The log drive is also showing poor performance, although not as bad and most are during the transaction log backups that occur every 15 minutes. The transaction log...

Hi

Thanks for the reply George. Its a beautiful day down here, winter has started though ...

When you say compete for resources, is this an issue other than with...

Be aware that selecting the 'do checks for backups' option also apllies to the trans logs; this can lead to situations where your log file backups take excessive time and...

Or fix it, using syntax like the following. Note the [] around the word with a reserved char.

alter database mntrDevl

MODIFY FILE (NAME = [mntrDevl-Log] , NEWNAME =...

Hi

I ran 2 Prod instances on IBM blade servers for the last 3 years. No problems, once we had the IO working nicely.

As the previous post suggests, check your...

Also consider user behavior. Has anyone changed roles, new staff hired, etc?

Ideally any action that involves the DB issuing locks should be completed quickly but the user may not...

Hi

I feel for you; been there too and sometimes its been very painful.

I try to describe what SA is for; some people assume that SA is just a more powerful...

Hi

I strongly recommend that you consider a Reverse Proxy Server. This is the approach we use - no databases to replicate or otherwise move tot he DMZ, less disk...

Hi

If you only want a single row this is easily acheived with a symntax like

select max(a) a, max(b) b

from (

select...

I concur with the (possibly most important) comment in the above posting - check business rules.

Once you have clarified the rules you should know whether there is an issue with or...

Hi

The only means I know to confirm a restore is to detail some data changes in the backed up DB before and after the restore-to-time.  Then after restoration confirm that...

> != is most GUI folks write and it's a bit more difficult to read than <>. 

Totally a matter of opinion.  ! mean Not (negation operator) and = means equal...

It is my opinion (and at this site, my manager's I'm glad to say) that there are two components to security; technical and HR.  Use the technical side to limit...

We should always ensure that the values we hold are correct - resist any suggestion that you enter an incorrect value as a place holder as you then have to...

Does US law offer any protection from Constructive Dismissal (process of forcing a employeee to resign when that employee otherwise would not have done so without the pressure from the...