GilaMonster (9/8/2010)

---

Stale statistics. I suspected that might be the case. That's why I wanted to see the full exec plan

Please run UPDATE STATISTICS <Table name> WITH FULLSCAN on the original...

the only difference i see is that the non-clustered indexes is set to fill factor 90% and is checked the option "Use Index'. I am trying now on the slow...

GilaMonster (9/8/2010)

---

Stale statistics. I suspected that might be the case. That's why I wanted to see the full exec plan

Please run UPDATE STATISTICS <Table name> WITH FULLSCAN on the original...

that's what i exactly did, just wanted to see if there is a better way. Thanks

Thanks. I have used try and catch and works for me now. I have created another topic on how to hightlight the print errormsg(). Thanks

thanks, but i want the the message ONLY from "print error_message()" to be printed in different font. I am using this in a cursor inside try/catch block and i wouldn't...

WayneS (9/7/2010)

---

For anyone else coming along, here's the code:

declare @database nvarchar (100),@SQLString nvarchar (max),@sql nvarchar (max),@statement nvarchar (max),@sp_executesql nvarchar (max)

declare @dbs table (DBname nvarchar (100))

set @SQLString =...

GilaMonster (9/7/2010)

---

Derrick Smith (9/7/2010)

---

Maybe Gail or someone else more knowledgeable can correct me, but creating a nonclustered index that contains every column is more or less identical (for selecting) to...

ksullivan (4/4/2008)

---

Many ways to do this. Here is a simple one to get started

select *

into #a

from information_schema.columns a

where table_name = 'aaa'

select *

into #b

from information_schema.columns b -- add linked server name...

GilaMonster (9/7/2010)

---

Answer 3 then.

The query could seek on a nonclustered index, but there are too many rows returned and the nonclustered index...

Oh yes, i have already read this article may be not fully but to certain extent. Also this code is not for any application,...

thanks but i need to restrict the loop to certain dbs'. I had to create a cursor and works fine. Thanks

Thanks Gail. Query takes more than 50 secs and will definitely time out from front end. The index suggested through DTA makes the query run in less than 1 sec....

GilaMonster (9/6/2010)

---

It means it's suggesting that you essentially duplicate the entire table. Usually a very bad idea. DTA is not perfect (or even good) a lot of the time.

Why don't...

Jeffrey Williams-493691 (9/6/2010)

---

As stated previously, you need to follow up with your SAN engineers. The documentation for the snapshot utility being used should document how it works with SQL...