Ninja's_RGR'us (10/31/2011)

---

sqlfriends (10/31/2011)

---

Thanks all.

First, I see the script is so long, I will have to study it a little bit later before I use it .

Second, I checked in the...

Ninja's_RGR'us (10/31/2011)

---

Actually there's an easy way out of this.

Maint. Plans always reindex everything no matter what (needed or not). This is usually a big waste of time and ressources.

I...

Gianluca Sartori (11/7/2011)

---

Totally different topic: this thread asks how to format datetime values in T-SQL.

I think this is a very bad habit to kick and I put together an...

Anybody else going to SQLInspire in NYC?

It dawned on me that I have to fly 2000 miles east just to connect with Steve who is only 400 Miles East.

H

Straight forward simple question.

I had a similar thing happen just this last week. I had to delete the cluster resource and then recreate it.

The other note that seems interesting is that you...

Jeff Moden (11/6/2011)

---

SQLRNNR (11/6/2011)

---

Jeff Moden (11/5/2011)

---

SQLRNNR (11/3/2011)

---

Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

I have seen them perform marvelously...

Grant Fritchey (11/5/2011)

---

Really? Looks like a car...

SQL Kiwi (11/6/2011)

---

L' Eomot Inversé (11/5/2011)

---

That rCTEs are bad for counting doesn't make all use of rCTEs silly and it certainly doesn't demonstrate that rCTEs are not a set-based concept;...

Jeff Moden (11/5/2011)

---

SQLRNNR (11/3/2011)

---

Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

I have seen them perform marvelously as well. ...

you're welcome

Please provide a sample of the expected result along with sample data.

No, it's just an illusion:crazy:

I have an article on how to move the rdl files - which I adapted that very same method to export the data sources.

You can find it here[/url].

Read the article...