I thought it was a user defined Table Type...

Rather simple, but BOL is a good source for examples, syntax, etc. Good luck and let us know how it goes 🙂

What is the total number of records return for the report?

I agree with the above, in that its doubt that your indexing (and maintenance) is setup for the reporting...

Use the Windows Scheduler to execute a SQLCMD command and point the SQLCMD to .sql file. There are other connection details that SQLCMD will require, but this is how I...

What is the search criteria for the reports? Are there any joins?

Which column(s) are the indexes on?

I dont see a PK declared is there one?

Is there a clustered index, if...

Silly question, but has someone put in an upper limit on the amount of memory that SQL can use?

Where are you looking at the memory consumption? If I remember correctly (maybe wrong, its been a while :)), with the AWE switches, Task Manager does not report the correct...

CREATE TABLE #table1

(

columns....

)

or

DECLARE @table2 TABLE

(

columns...

)

SQL is a resource pig, it will grab resources (especially memory) and not let go. If you are running 64bit SQL servers, you will need a minimum of 5GBs of...

DPM, as in Data Protection Manager from Microsoft?

If so, then I believe you are correct. I used this at a previous place and remember the documentation stating that it...

You could write a stored procedure that executes the job (using sp_start_job), but you have to specify the execution user (using the EXECUTE AS clause).

Are you upgrading to 2008R2? If so, from what?

blurb - ignore me

PaulB-TheOneAndOnly (6/28/2010)

---

grahamc (6/28/2010)

---

and there in lies the problem... generally speaking, if you are very god on technical side, its because you have always pushed to learn/understand more, thrive under pressure,...

and there in lies the problem......