rbarryyoung (5/6/2008)

---

Actually, I've discovered recently that that does not in fact script everything in the database. For instance there are no Service Broker objects on the list.

Kind of disturbing,...

I did a Google search for:

sql "sequential index"

And found a few articles. Some say one thing, some say another. You'll need to look at them yourself to figure...

I...

Understood on the efficiency thing.

You're welcome.

Since there's no relationship in the data, just insert from the first table, then insert from the second table.

You're right. I didn't...

It's a good question and gives all the necessary information.

Excellent article, Jeff. Good introduction.

I've been using Numbers tables for a couple of years now, and I just keep finding more uses for them all the time.

Examples include: String...

chris (5/7/2008)

---

How about using recursion :hehe: to replace loops? (One of the great new functions in SQL2005)

No need for a tally or temporary tables.

Heres a params example:

DECLARE @Params varchar(8000)

SET @Params...

Hugo:

Just SP is fine (though I personally dislike the habit - as if anything other than a stored procedure might follow an EXEC keyword). It's SP_ (with an underscore...

The easiest is just to right click the database in Management Studio and select Tasks, Create Scripts, and go from there. Does that not do what you need?

Matt Miller (5/6/2008)

---

wdillon (5/6/2008)

---

Hi Jeff, I got the Tally table thing worked out from finding on another post of yours. WOW!!!! The data looks great!! Do...

I'm not certain from your description, but it sounds like Full Text Indexing might do what you need. Check that out in Books Online.

Not sure what "sequential" index would be, unless you mean "clustered index", which stores the sequence of the rows in the table.

A "covering index" is an index that has all...

In case it matters, the table I created was 104 Meg, while the indexes were 350 Meg.