Check Index Fragmentation in a SQL Server If we run INSERT, UPDATE or DELETE queries frequently than we can see indexes on the particular table are fragmented. And the SQL query may run slower as they may choose the non-optimal execution plan. Below script can be used for checking how much percentages of an indexes gets fragmented on a database. so that we can rebuild or reorganise the indexes. SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS IndexType, indexstats.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id WHERE indexstats.avg_fragmentation_in_percent > 10--You can specify the percent as you want AND ind.name is not null ORDER BY indexstats.avg_fragmentation_in_percent DESC

How do I conditionally render a tailwind class in react?

Rajan

I am creating a website that uses Tailwind(3.0.2) and ReactJs (17.0.2).

I have a div that wraps a navbar I would like to render conditionally depending on screen size. This code works as the base case:

<div className= { (showIcon ? "left-0" : `-left-full`) + " fixed bottom-0 top-12 bg-gray-500 bg-opacity-60 w-10/12 text-white p-2 flex flex-col"} >

For medium screens and larger (md: in tailwind), I have prepared this code which also works on its own :

<div className= {nav ? 'nav active' : 'nav'}  > // (Nav and nav active are states defined elsewhere)

I want to combine both snippets but my code throws compiler errors. For example:

<div className= { (showIcon ? "left-0" : `-left-full`) + " fixed bottom-0 top-12 bg-gray-500 bg-opacity-60 w-10/12 text-white p-2 flex flex-col"} md:{nav ? 'nav active' : 'nav'} >

 Line 40:151:  Parsing error: Unexpected token (40:151)