wolfkillj (1/29/2013)

---

I noticed that there's a user who seems to be digging up very old threads (all on the same topic with approximately the same question - inquiries about "sleeping"...

The same number as in...

ScottPletcher (1/24/2013)

---

Seems an odd way to read it in context here, since the OP stated in his original post that he could index a computed column w/o explicitly persisting it....

ScottPletcher (1/24/2013)

---

Of course indexing requires persisting. I thought everyone was clear on that.

But you claimed, in your first quote above, there was no (never a) need to persist except...

ScottPletcher (1/24/2013)

---

HowardW (1/24/2013)

---

ScottPletcher (1/24/2013)

---

That's not necessarily always true. You might persist a column if its requires...

ScottPletcher (1/24/2013)

---

That's not necessarily always true. You might persist a column if its requires significant overhead...

SQL* (1/23/2013)

---

Hi All,

While reading about Computed column if found that if we mentioned PERSISTED Key word while creating/altering table then we can create index. But i'm able to create index...

Sounds like you're going down the right lines. The correct order of deletes may be unresolvable without disabling/re-enabling constraints, especially if you have circular references spanning multiple tables (urgh).

You...

It looks like there was a bug prior to 2000 SP4 that could cause this, but post-SP4, table or index corruption would be more likely.

Start by running a CheckDB...

Which SQL Server Version and Service Pack did the error occur on?

You should be able to get that working with your original approach if you just add in the single quotes and set the data flow source to your variable. e.g.:

"Select...

When that's converted to a string, you'll be missing the required single quotes from around your date (as you're passing it as a string).

You're better off passing the variable directly...

The views are used to populate the DW, rather than for end user queries?

Yes, they can definitely produce sub-optimal plans as by definition, they sacrifice overall execution time in...

Done

SQL 2k8 SP3:

ALTER PROCEDURE [dbo].[sp_add_jobschedule] -- This SP is deprecated. Use sp_add_schedule and sp_attach_schedule.

...