Viewing 15 posts - 16,726 through 16,740 (of 19,564 total)
Lynn Pettis (3/8/2010)
WAY TO GO...
March 8, 2010 at 7:30 pm
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...
March 8, 2010 at 5:27 pm
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...
March 8, 2010 at 5:14 pm
mohammed moinudheen (3/8/2010)
There are some batch jobs which are taking more time than usual...
March 8, 2010 at 5:03 pm
Good to hear.
Thanks for updating back to the thread.
March 8, 2010 at 4:34 pm
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...
March 8, 2010 at 4:29 pm
Lynn Pettis (3/8/2010)
My daughter, Kirisa, made the JV squad during tryouts. This weekend (Friday and Saturday) she played 3 games at the Mesa Ridge Tournament...
March 8, 2010 at 4:23 pm
Roy Ernest (3/8/2010)
Good One jason... No Cursors.. 🙂I could use that script as well...
Thanks Roy.
Just pounded it out today.
I tried assigning "NULL" to the variable like:
Set @DBName = NULL
That doesn't...
March 8, 2010 at 2:04 pm
Angelindiego (3/8/2010)
March 8, 2010 at 1:59 pm
Angelindiego (3/8/2010)
March 8, 2010 at 1:57 pm
Viewing 15 posts - 16,726 through 16,740 (of 19,564 total)