I've used workgroup edition. It does include database mail.

Barry, when I said, "your" I meant Milu's. He miscopied yours.

Milu, I actually answered on behalf of a number of other people, including Jeff Moden. If you look...

declare @SDate datetime, @EDate datetime

select @SDate = '1/8/2008', @EDate = '3/8/2008'

select

dateadd(month, number, -- Months in range

dateadd(day, -1 * datepart(day, @SDate), -- Last Day of (prior) month

dateadd(month, 1, -- Following...

Temporary tables can actually be quite valuable. I don't know of a specific single-source of data about using them. Best bet is starting with Books Online and doing...

On small tables, SQL will sometimes not even bother doing anything if you tell it to defrag the index, because the fragmentation doesn't matter. On really small tables (I...

The easiest solution is going to be deleting from the combined table, before the final upload. You could dump them in the load from the vendor-specific tables, but that's...

On the cursors questions, take a look at the system views. There are a set of them for cursors.

RAM utilization could definitely be an issue. If any of the reports are big enough, and you don't have the server configured to use all that RAM, they'll end...

There isn't "a" plan for that kind of thing. It depends too much on what you're doing, in what environment.

You say you're migrating your production environment from Dev to...

Milu (8/11/2008)

---

your code...

Create View vwRecursiveAW AS

WITH DirectReports(ManagerID, EmployeeID, EmployeeLevel) AS

(

SELECT ManagerID, EmployeeID, 0 AS EmployeeLevel

FROM AdventureWorks.HumanResources.Employee

WHERE ManagerID...

That's definitely odd. Are you certain that it's the SQL server that's timing out, and not something else in between the page sending the query and getting the data...

If you set up roles on the server (Security tab), you can tell a job to run under a particular login/role.

I don't know of a way to do that in SQL Server itself. Might be one, but I don't know of one.

If you have a log parser, you should...

I'm assuming you mean gigabytes, not gigahertz, for your amount of memory.

There's a setting in your server options for maximum (and minimum) memory. You need to make sure that's...

My personal favorite is the SQL Server Bible series by Paul Nielsen.

What I really recommend, though, is go to a bookstore with a good IT section. Take a list...