edit - special thx to GilaMonster for the free ebook

i double checked the vendor database reccommendation sheet and it doesnt mention locked pages. just as ya'll said 'it should...

Our max server memory was unlimited. Consultant said he limited max server memory for another client with a similar issue.

After this discussion, I set max server memory to...

working code.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/a5791483-1002-4304-8188-740e451a6252/

select T1.* from #tblEmail1 T1

INNER JOIN (select min(subject) as ID from (select * from #tblemail1

UNION select * from #tblemail2) X

GROUP BY LEFT(Subject,5)

HAVING COUNT(*)...

you could change it to x.receive or you can use this modified query for the data load. in the real scenario the other column is receivedate

--===== If the test...

i updated the sample data query using varchar 200 and removed the explicit convert

I've tested this code using SQL 2005 (v9), maybe this should be moved to tsql 2005?

the...

Works like a charm Sean. Thanks for all your help.

i wouldnt think they are milliseconds because they are always zero. or maybe the software is rounding when creating timestamps.

i've never thought of it that way before.

edit - ill...

i edited the original post shortly after i made it. the timestamps should include three zeros after each. this is why i use a calculated feild to display...

@ Phil - i might be able to but id rather not. its not my db. i think it could be done with just a query

@ Sean...

returns all ten rows when

where created_dt > DATEDIFF(s, '1/1/1970', '9/1/2011')

is used

edit - maybe i need to create a subquery to generate the unix timestamp from a sql datetime.

I ran the query last night and the output is much more useful. Many thanks.

Now I've added it to a Sql Agent Job that is associated with a weekly...

hmm, i'm thinking i'll add forwarded_record_count to the select statement. I'm planning on running the query on a weekly basis and analyze. Currently, we're running a alter index...

it turns out all the nulls for name have 0 for indexid. im reading info about heaps now to determine whether or not i should be concerned about fragmenation...

Ideally you should be able to create a object that loads the excel application. I dont know how to do this in tsql but in vbscript, it looks like...

As far as posting table def and such, I'm just not that comfortable with it. That and the problem hasnt reached a critical point yet. I believe I...