Oftentimes yes it will make that adjustment. Occasionally it may miss on it because it is checking so many different possible query plans in split second to find a...

Chris Harshman (3/13/2013)

---

Grant Fritchey (3/13/2013)

---

What I meant was store the Month & Day values as those, either during the insert/update process or as calculated columns. Performing functions on columns in...

Replication works wonders for that.

You are dealing with a Debbie Downer.

XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information about spinlocks, latches,...

That text does not appear usable or searchable. I don't know why they would want to store or search it. But if the business requests it, sure store...

Did you change it through Configuration Manager or through the services control panel?

Jeff Moden (3/13/2013)

---

That got me thinking. Why is this data removed? I'm sure some of the data is stored in memory and automatically reset, but is this the best way...

Welsh Corgi (3/13/2013)

---

Seemita Das (3/13/2013)

---

Did you check the 'protection level' on the package? I had faced a similar error earlier and it was resolved after I changed the protection level...

GilaMonster (3/13/2013)

---

Restore from last good backup, that's irrepairable.

If there's absolutely no backup whatsoever, export all the documents, lists, etc from sharepoint (not a SQL data export), then drop and recreate...

Are you asking if there is a way to fix without losing data?

You should start a new thread for this...

Are all of the packages performing tasks related to Oracle or something else?

Short answer is - yes it is possible.

You have three subqueries each aliased as "Summary." If you take each of those subqueries and Alias them to Summary1, Summary2, and...

How many records is this query returning?

Also, please post the actual execution plans, table definitions and sample data please.

Here is an example of something that has already been done.

http://p2p.wrox.com/content/articles/creating-report-server-usage-report-sql-server-reporting-services

It might not be exactly what you want, but give it a look and see if it will work.