On a side note. Do you guys know how to access the rdl file of the default reports so that we can edit them?

Jason Selburg (7/19/2011)

---

Ninja's_RGR'us (7/19/2011)

---

I just googled it.

Detroit, Michigan, USA.

I rest my case. You can always trust what Google says...

Are you doing this with sa permissions?

This screams only 3 things to me :

#1 Bad install of the gui

#2 Missing permissions

#3 Missing patch.

I just googled it.

Detroit, Michigan, USA.

I rest my case. You can always trust what Google says 😀 :-P.

When's the last time you updated the stats on that table?

What's the current, bad execution plan of the sp?

What's the good execution plan of the query?

With or without order by? Doing table scan or some sort of...

Tx, so now that's 2 votes for me...

homebrew01 (7/19/2011)

---

In addition, I run a job to script out objects to a folder every week as another layer of protection. If I need to recover stored procedure code, it's...

Ask for more details. This is now a sql 2008 DB. I'm sure they can send you a checklist of steps to go through to "complete" the conversion.

It...

I think that would be a waste of ressource, but you could also include it in the datasource itself. But over 100K rows, it starts to add up!

davidsalazar01 (7/19/2011)

---

Ignacio,

Yes, I have run that query previously but I wasn't sure what to look for. We actually fixed the issue. It had to with how the Select...

For those missing the un-obvious point, I'm based in Canada, that thing north of USA.

Jeff Moden (7/19/2011)

---

Ninja's_RGR'us (7/19/2011)

---

Jeff Moden (7/18/2011)

---

Ninja's_RGR'us (7/18/2011)

---

Holly Koch (7/18/2011)

---

I am in need of a SQL Server DBA for a client based in Lansing, MI. If you would be interested...

Ya but I'm guessing you have a project # as well in there (data list I suppose).

Please post the previous and current project value instead of the adress.

Also see if...

How do you decide that you change group? Or more specifically what do you group by?