Update Statistics With Full Scan in SQL Server We all know to keep auto statistics update ON for a SQL server databases little overkill the performance and query may or may not use correct statistics and may choose the non-optimal execution plan. This may slow down the performance of complex queries to be run faster. Also, it is not a good idea to rebuild fragmented indexes every day in a busy production environment where thousands of query already running and there is no window for database maintenance task. When you will run index rebuild operation on a busy database you may encounter Query Timeout error for other running queries on a larger database. So the alternative and best solution are to update statistics with a full scan. Assuming you already knowing update statistics with sp_updatestats only update statistics a sample of records of the table and with full scan, it will scan the entire table. DECLARE @tablename varchar(80),@shemaname varchar(80) DECLARE @SQL AS NVARCHAR(200) DECLARE TblName_cursor CURSOR FOR SELECT t.name,s.name FROM sys.tables t join sys.schemas s on s.schema_id=t.schema_id OPEN TblName_cursor FETCH NEXT FROM TblName_cursor INTO @tablename,@shemaname WHILE @@FETCH_STATUS = 0 BEGIN SET @SQL = 'UPDATE STATISTICS '+@shemaname+'.[' + @TableName + '] WITH FULLSCAN ' EXEC sp_executesql @statement = @SQL FETCH NEXT FROM TblName_cursor INTO @tablename,@shemaname END CLOSE TblName_cursor DEALLOCATE TblName_cursor Instead of updating statistics for each table we can use below script to update statistics for all tables of a database

I'm trying to include CSS code in js file. But not working

Bhuvneshwar

So I'm new to this I don't really know what I'm doing wrong I'm trying to use some CSS code in JS file but not working it shows a white screen it suppose to style the Navbar but the code inside the back quotes doesn't work maybe the reason is silly but I'm new to this so I've no idea why should I add I hope you could help me

this is the code:

CSS:

import styled from 'styled-components';
import {Link as LinkR} from 'react-router-dom'

export const Nav = styled.nav`
    background: #000;
    height: 80px;
    /*margin-top: -80px;*/
    display: flex;
    justify-content: center;
    align-items: center;
    postiion: sticky;
    top: 0;
    z-index: 10;

    @media screen and (max-width: 960px){
        transition: 0.8s all ease;
    }
`

export const NavbarContainer = styled.div`
    display: flex;
    justify-content: space-between;
    height: 80px;
    z-index: 1;
    width: 100%;
    padding: 0 24px;
    max-width: 1100px;
`

export const NavLogo = styled(LinkR)`
    color: red;
    justify-content: flex-start;
    cursor: pointer;
    font-size: 1.5rem;
    display: flex;
    align-items: center;
    margin-left: 24px;
    font-weight: bold;
    text-decoration: none;
`
///////////////////////////////////////////////////////
HTML:

import React from 'react'
import { Nav , NavbarContainer , NavLogo} from './navparElements'

function index() {
    return (
        <>
            <Nav>
                <NavbarContainer>
                    <NavLogo to='/'>GUIDECK</NavLogo>
                </NavbarContainer>
            </Nav>
        </>
    )
}

export default index

///////////////////////////////////////////////////////
and:

import './App.css';
import Navbar from './componant/Navbar';
import {BrowserRouter as Router} from 'react-router-dom'


function App() {
  return (
    <Router>
      <Navbar />
    
    </Router>
  );
}

export default App;