Lynn Pettis (3/8/2010)

---

IT'S OFFICIAL!! Kirisa is now on Varsity! Coach told her today that she earned the position and is now one of his permanent defenders!!

WAY TO GO...

Yes, I have used DTA in the past. I only use it to see possible recommendations. I do not typically implement changes directly from DTA though. I...

The risk comes in the indexes that it may propose to remove. Any indexes or stats that are recommended are easy to spot and remove.

As for immediately implementing the...

mohammed moinudheen (3/8/2010)

---

I would like to run a workload file on the Database Tuning Advisor(DTA) for getting tuning recommendations.

There are some batch jobs which are taking more time than usual...

Could you provide sample data?

Good to hear.

Thanks for updating back to the thread.

You're welcome.

I think your app is not creating the table as it should. Using DBCC CheckIDent will permit you to verify the identity value of the table before you insert...

K. Thx

Lynn Pettis (3/8/2010)

---

Should have posted this Saturday.

My daughter, Kirisa, made the JV squad during tryouts. This weekend (Friday and Saturday) she played 3 games at the Mesa Ridge Tournament...

You're welcome.

Thanks Roy.

Just pounded it out today.

I tried assigning "NULL" to the variable like:

Set @DBName = NULL

That doesn't...

Angelindiego (3/8/2010)

---

One more piece of info I wanted to share....I opened up the replication script for TESTBED and it has in there the variable @replication_DDL = 1 (I think that...

Angelindiego (3/8/2010)

---

My question is this: I found this code (see below)....can I incorporate it WITHIN my other alter script, or do I need to break out the replicated tables...

Got it.