Ola solution is good, but that's something i cant implement right now. Due some complexities.

Thank you for your reply. I am trying to find out which DMV can help

thank you so much. Yes, imy manager is also inclined towards Red Gate product

i understand that, I specifically looking a tool for SQL server and cheap because i need to convince financial people in the company. However can you advice some names?

there are so many options available on the MS website. i am not sure which one to pick. Release note is little confusing for me

http://www.microsoft.com/en-us/download/details.aspx?id=26727

Thanks alot. Will try to fix it ASAP

quick question:

The above query is taking 5 secs to fetch 21 records in 150k records table. Is that speed ok??

thanks. one more thing, how you look the future of Big Data? should i jump into Big Data or should i continue working in SQL server. I am little...

thanks,

I thought of using table values param. However, This would need to change application code and its not possible at this point in time... (time constraints ) . But...

Thank you so much.

I just realized that i wasnt covering the index properly. Seems like no more look up... no high performance gain but no more key look ups.

I need...

</description>

<description name="Item23" isnull="true" iskey="true">

<description...

yes view is indexed and tables have indexes too (exectly the same). and infact, view has extra filter 'user_name () = user'

....same number of rows in result set.

--begin tran

----rollback

if exists ( SELECT1

FROM sys.objects o

join sys.columns c on c.object_id = o.object_id

WHERE o.name = N'MYTABLE'

AND type = 'U'

and c.name = 'MYCOLUMN')

begin

declare @default varchar(1000)

declare @comment varchar(500)

select @default...

OR if any one can help me with the script which checks for a index on column.....drops it.... and recreates it.

All i would pass is table name and column name

Thanks

Got it.

Thanks