With the system using 5.7GB of memory (page file) - you are definitely running into memory issues. This is only leaving approximately 300MB available to the OS and other...

Oh, also - if you only have 6GB of memory available, setting max memory to 5GB (5200) might be a bit high. I would drop that down to 4GB...

Switch over to the Performance tab and view the PF Usage graph. That should show you the max that is being used.

To verify that SQL Server is using the...

First - what is reported in that view does not tell you how much memory SQL Server is actually using. You can look at PF Usage to get a...

To add to what Lynn has already stated - I think you need to lookup OUTER JOIN's. Once you have posted additional information about the problem, I am sure...

Order By in SQL Server 2005 does work, however - it only works to guarantee the order to satisfy the TOP requirement and does not guarantee the order the results...

Are you looking for something like:

SELECT is_disabled FROM sys.sql_logins WHERE name = 'username';

Or,

SELECT is_disabled FROM sys.server_principals WHERE name = 'username';

Jeff

Or, you can use EXCEPT:

SELECT * FROM TABLEA

EXCEPT SELECT * FROM TABLEB;

Look in BOL for further information,

Jeff

I am going to assume that you have the following in your view:

CREATE VIEW dbo.MyView AS

SELECT TOP 100 PERCENT ... ORDER BY someorder

GO

If so, I don't know of a fix...

You can find the downloads for SQL Server sample databases at: http://www.codeplex.com/MSFTDBProdSamples

Jeff

marchbrown1529 (6/6/2008)

---

Thank you to all who replied. Here is what I finally came up with. It isn't elegant, but it does get the job done.

DECLARE @todaysdate DATETIME

set @todaysdate...

I am not sure what you are asking for. I don't know of any properties that keep track of maintenance plans in SMO. You could look at Microsoft.SqlServer.Management.Smo.Agent...

Open up the maintenance folder in Object Explorer, right-click on the Maintenance Plan and View History. In the log viewer - you can then open up the job and...

It is not real clear what you are trying to accomplish here. I am going to assume that you are using a linked server from SQL Server to your...

Just my opinion, but things like phone numbers, ssn, zip code, etc... are not numbers (although they contain numerals). Since there would most likely never be any need to...