Thank you Steve for the reply.  Appreciate it.

I got the below script to find out unused columns in a database and the output looks good to me.....can someone help in adding 'DatabaseName' to this script?

DatabaseName, TableSchema, TableName...

Thank you Emperor100 for details.

Hi Emperor100, Can you plz explain this SP as to how it works....Do I need the pass the @TableName as value or DB name?

Thanks....the 2 tables in question are pretty small and have same amount of rows in both UAT & PROD

I've updated the STATISTICS on both tables and waiting for user to...

Thanks everyone for the responds....I will start with basics.

Do you have the link for "first responder toolkit sp_BlitzCache"

Thanks Jeff, yes, this is our plan....identify the columns first then rename it and monitor for sometime and if still not being used.....drop them as part of clean up.

I don't believe we allow for null in our data.  I would image it would be any that have all spaces(any character fields with the default space).

My understanding from app team is, historically they created additional columns for future use, but never used....so, I am doing this as part of a clean up process where I...

Thanks Jeffrey, do you have a link you can refer me to?

Thanks Frederico - I tried the below and getting the error below.

select Convert(datetime,dr_value,101) as Converted_Date from "users"."dr_tracking";

There was an error reading the results of the SQL statement.

The displayed results may...

I was trying something like this below..

select Convert(Varchar(100),dr_value,103) as Converted_Date from dr_tracking ;

• What is the data of "yourcolumn" (the original column)?

  • dr_value varchar(100)
    <li style="list-style-type: none;">

    • dr_value - below...

You can only do that if you install as a default instance.

looks like you installed as named instance, therefore connection will be servername\instanceName

Thank you Jeff, this is helpful.

Hi Jeff - quick question

I was trying to replace 'Green' color with color code #90EE90....but it's not working.....any idea what I am doing wrong?

(

SELECT td = CONCAT('~bgcolor="'

,CASE mirroring_state_desc

WHEN 'SYNCHRONIZED' THEN...