The view must be dropped first if it has been created using schemabinding

you stated cpu and memory were ok.

What's the ammount of physical RAM on the windows server, how much is in use and how much is in use by sqlserver ?

Any...

can you free the proccache ?

(to get rid of the "unperformant" plans)

dbcc freeproccache

Maybe now (holliday) is the moment to rebuild indexes, ...

befor you implement the new ones.

We've recently had a...

As SQL Noob stated, contact your mail admins, they will be able to find your mail (or in an output queue or in an received state, but maybe filtered by...

leonp (3/11/2009)

---

I wanted to check on a regular basis if all the databases we have online are being backed up and devised the following script -

select x.name as 'Databases...

My guess, your delete generated a bunch of log and is still running (cascading deletes ?)

DBCC opentran (executed in the correct db) may give some answers.

can you find traces of your missing in action mail in these objects ?

use msdb

go

exec sysmail_help_queue_sp -- @queue_type = 'Mail'

go

select *

-- delete

from sysmail_event_log

order by log_date desc

select *

from sysmail_mailattachments

select...

Just prepare your action a little bit, so you don't end up having a dozen of similar indexes.

No. SA is the sql user which is sysadmin !

It is not the service account!

Do you have your sqlinstance in Mixed authentication mode ?

hmm ... a whole bunch of clustered index scans.

That indicates absence of usable indexes for the predicates you provided.

Even tough stats indicate only 1 row to return, it...

Does your SA password match your domain password policy ?

(maybe even change it temporary during the upgrade only)

Thank you for the feedback.

HTH

2 Tim 3:16 (3/10/2009)

---

even for 64-bit, you still need to "lock pages in memory"

Open the Group Policies Console:

START-RUN , enter - gpedit.msc

Computer Configuration - Windows Settings - Security...

Most of...

thieuquanghuy (3/9/2009)

---

...

Thanks marina.kudryashov, I wonder if Idera is a shareware.

Thanks ALZDBA, this link http://www.sqlservercentral.com/articles/Administration/64974/ is very useful.

and article in http://www.sqlservercentral.com/articles/Security/66151/ is interesting.

I replace FOR LOGIN_EVENT with FOR LOGON, but...