I have rectified the mistakes....the only thing I haven't been able correct is the incorrect create index statement in case where a column name has an "_" in its name....I...

thanks for the good response.....

I will review the code and will update by this weekend....

einman33 (10/20/2009)

---

Nice content author, keep up the good work.

Would like to bring up a dissenting opinion though. I struggle with the auto creation of indexes. I have used...

pnewhart (10/20/2009)

---

In some cases, the columns to be indexed disregarded the column names. For exampe, I have columns named with an underscore....these were parsed as separate column names. ...

jmcgarvey (10/20/2009)

---

The content is sound and fairly well thought out. As stated by others the code is a mess with errors, typos, etc. I do not like the...

ghughes (10/20/2009)

---

Where will the corrected code be placed? Will it be reposted? The articles topic and goals interested me, but the problems trying to get it...

jbuttery (10/20/2009)

---

One needs to be cautious about eliminating or filtering out 'unused' indexes. I think that sys.dm_db_index_usage_stats only shows indexes that were used since the last time SQL server was...

pnewhart (10/20/2009)

---

The create index syntax appears flawed as well. There are several occurrences where the column names are not parsed correctly. It does create a good result set...

dagfinn.molde (10/20/2009)

---

The code posted contains a lot of errors. Misspelled procedure names, missing columns, wrong aliases.

I don't have time to do the error checking right now, but will post my...

No..It doesn't applies to sql 2000

qualon (10/16/2009)

---

I'm looking for ideas why an index rebuild would go from ~8 minutes to ~8 hours without significant data changes. The rebuild ocurrs daily and has been running...

bruhaspathy (10/17/2009)

---

Using Snapshot replication to move the Large Database of 90GB would...

rambilla4 (10/1/2009)

---

Hi,

I have a requirement from the developer's team that they want the Production data to a separate server so that they can use that for Reporting purpose. We have...

you should look for 3rd party backup tools

you can use select into statement.