Paul White (5/2/2009)

---

GilaMonster (5/2/2009)

---

It allows for tablespaces (SQL filegroups) to...

Thanks, Flo.

Thanks Paul. Yeah I did notice that after I posted. I actually did a lot of work emulating Oracle transportable tablespaces in SQL Server and I always forget...

Michael Valentine Jones (5/1/2009)

---

...

Backup and restore by filegroup is just a way to spread out the backup processing, and is useful mainly for very large databases.

You can backup and restore...

As I stated above, this is a very complex question and neither backup schedules nor cross-database performance usually even makes the top 10 issues to take into consideration for it....

Hey, could Gail or anyone else who knows about FileGroup backup and restore issues please comment on the OP's question in this thread? What he is saying feels really...

troy.hodge (5/1/2009)

---

Our Legacy DB2 Z/OS System has 13 databases broken up into logical business areas. In no situation do we have R/I spanning between databases. All R/I is contained within...

Hmm, I am not keen on the term "Hybrid" here at all. Note that nowhere in the msdn reference used to justify the answer does the word "hybrid" appear.

...

The answer text says it all:

Since the index created is a nonclustered one, when "top 1" is queried for; we get the value 'A' and not '$'. The data remains...

Looks doable to me. Maybe even in a view. If you can get us the stuff that Lynn asked for, it shouldn't be too hard.

I usually use SET only for one-offs and only because its shorter. As soon as I am into multiple variables or anything else I use SELECT because its faster,...

To make your XML show up, you need to qoute it with [ code="xml"]...[/code] tags, instead of '...'. Like this:

Click the QUOTE button on my post to see...

Thanks for the feedback, Paul. It's always nice to know how a suggestion worked out.

Luke L (5/1/2009)

---

I never knew about it until today when the question was asked. I started playing around with the thread navigation buttons and I found it. Not...

Tell us what you are doing and what version of SQL Server you are using.