Try this one: exec sp_configure 'show advanced options', 1

go

reconfigure

exec sp_configure 'min server memory (MB)'

GO

exec sp_configure 'max server memory (MB)'

GO

But I thought that you stated that you have a 64-bit SQL Server on a 64-bit OS? Argenis's blog doesn't apply to your situation unless I am wrong and you...

Let's...

First of all you don't need AWE on 64-bit server http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-530-awe-must-be-enabled-on-64-bit-servers/. Second if you want it to take 7GB of memory then set the "min server memory" and it will...

SQL only takes memory as it needs it. Right now the server only needs 3.8 GB of memory as it needs more it will take more. If you need it...

You could use SQL Trace and put a filter on Text Data for the table name or you could use Extended Events and put a filter on the SQL Statement,...

Aaron Bertrand has a great article on this topic http://www.sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join

Can you supply the desired output give the sample data that you provided? That way we are on the same page.

david.gugg (4/10/2014)

---

Yes, PageType = 1.

So if I'm understanding you correctly, when a table is first created the data is put into mixed extents. Once the data is big enough...

I have created a sample table and some sample data for you (please do this in the future). I also added a StudentID since you will probably have something like...

I'm not sure what you are trying to do now. Are you comparing the values between the two columns (which...

When you create the object it will first get it's pages from a mixed extent after that you should be the PagePID return sequential order (for 8 pages) and then...

I would first consider creating an enumeration type table for the Action and using that instead of the name, i.e. 'BaseMaking' etc. Can you supply the desired outcome for the...

Try using CAST instead like so:drop table #datediff

create table #DateDiff (

Verdate char(10) null

,secdate date null)

insert #DateDiff

values ('20140101', '20140201')

SELECT *

FROM #DateDiff

where datediff(DAY,cast(verdate as date), secdate) <...

I believe that it works, but it is not very efficient. It that is fine with you then problem solved. Otherwise you would want to use something like Lowell suggested...