About Chintu

Chintu · 02-08-2017

Hello All,Need Powershell script to find the Fragmentation details greater than 30% for a list of servers and the results needs to be exported in excel. We need this results over the email in HTML or CSV format.But I have referred to below link but i...

Chintu · 02-20-2017

Hi Chris,I have fixed the issue now.Thank you so much for all your helpBest Regards,

Chintu · 02-20-2017

Hi Chris,I believe we can use this below command greater than or equal for above issue.Please suggest me if its correct.If ($frg -ge "30"){ or else $q = @"select avg_fragmentation_in_percent, page_countfrom sys.dm_db_index_physical_stats($dbid, $tb...

Chintu · 02-17-2017

Thank you Chris for all your help and now it seems like working fine but getting the results different manner .in other words is it possible to modify the script to remove the fragmentation which is in fragmentation as below 30% since I need only mor...

Chintu · 02-16-2017

Hi Chris,Whenever you get a time,please look into this and help me out.Thanks in advance!!

Chintu · 02-16-2017

Thank you Chris for your quick response and i have done all changes as you suggested but getting following error message and i tried with below code but no luck..requesting please check it once from your end. $res = @(invoke-sqlcmd2 $server $dbnam...

VOX

User Statistics

User Activity

Need a powershell script for SQL index Fragmentation

Re: Need a powershell script for SQL index Fragmentation

Re: Need a powershell script for SQL index Fragmentation

Re: Need a powershell script for SQL index Fragmentation

Re: Need a powershell script for SQL index Fragmentation

Re: Need a powershell script for SQL index Fragmentation