Simple recovery will mark the log as re-usable as soon as a checkpoint happens within the DB which will prevent the need for regular log backups and will stop the...

Please post error messages from the windows event viewer.

Read the memory management chapter in the Accidental DBA guide, link to the guide in my signature below.

You set the max memory so that the buffer pool doesnt consume all your servers resources resulting in SQL starving the OS of resources and the time it takes for...

Just...

Do not cross posts it fragments replies

replies here http://www.sqlservercentral.com/Forums/Topic1388508-148-1.aspx

Yes, SQL can go over what you have defined as the max server memory as certain things are stored in memory outside of the buffer pool.

First off why is the statement wrapped in sp_cursorprepexec?

Second, the parameters supplied in both sql scripts are different so will affect query time.

Third, read uncommitted brings in a whole different...

Permissions are cumulative but deny's take precidence.

Now what permissions have you already granted to the existing user group?

Yes you can create another AD group for user1 and user2 then grant...

And how are you doing the notification? A job step which is triggered should a step fail? Using a notification to an operator on job failure?

If notification of...

Please provide sample data for the tables in question and what you want the output to be based on that sample data so we can get you off on to...

Well Table B has to have a value it its ID Column which exists in Table A you would an inner join.

If you want TableA to TableB then you would...

thava (11/22/2012)

---

for give me i changed my post previous post

since the column 'Aid' is not null

Then every record in TableB has a Aid which is strictly in TableA

now which...

Server with 80GB of RAM and SQL using 65GB of RAM is not a problem if the server is dedicated to SQL only.

I would strongly recommend setting a max limit...

As its a web page you handle what a particular user can and cannot do in your application, be that via a users table which has flags to say, I...