Duplicate post, please post answers here

Maybe look into Plan Guides.

Can you open the trace file successfully in Profiler? What if you change the second parameter to 1?

With SQL Server 2005 and later you do not have to manually assign rights as the install creates local groups with appropriate rights and places the Service account in those...

I don't think that there is a way to set grouping in one table based on data from different dataset.

Luke L (5/13/2009)

---

I've always had decent luck with Dell laptops. they just seem to consistently beat out IBM And HP on price for the same hardware. My only...

Are you considering putting a trigger on each of the tables to get the data to flow through?

Ideally triggers should be short and quick if you use them at all...

Can you post the code you are using?

Here's a link I found on Jeremiah Peschka's blog[/url] that creates and populates a calendar table

Paul White (5/13/2009)

---

It's an AlienWare M-17 with QX9300 Extreme Edition Penryn Quad Core, 8GB RAM, Dual 512MB ATI...

If I recall correctly, on my machine, mine included a worktable while yours didn't and mine had more logical reads than yours (Set Statistics IO ON). For small data...

Depending on the voice, those who get to hear it...

RBarryYoung (5/12/2009)

---

Based on...

Well, you can do it with existing roles, but I would recommend creating your own role. The reason is that if you use the built-in db_datareader and db_datawriter roles,...

Yeah,...