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

Why does my header not stick to the top of my page

Bhuvneshwar

.navigation {
  color: var(--var-color-two);
  font-family: "Kanit-medium", sans-serif;
  font-style: normal;
  font-size: 26px;
  height: 1500px;
  padding-top: 42px;
  padding-left: 250px;
  position: sticky;
  top: 0;
}

.logo {
  display: inline-block;
  font-size: 30px;
}

.nav-links {
  position: relative;
  display: inline-block;
  left: 12rem;
}

.nav-item {
  display: inline-block;
  margin: 0 18px;
}

<div id="header">
  <div class="navigation">
    <ul class="logo">
      <li>
        <a class="home" href="index.html">HOME</a>
      </li>
    </ul>

    <ul class="nav-links">
      <li class="nav-item">
        <a class="ebay" href="Pages/Page1.html">Page1</a>
      </li>
      <li class="nav-item">
        <a class="stock" href="Pages/Page2.html">Page2</a>
      </li>
      <li class="nav-item">
        <a class="drop" href="Pages/Page3.html">Page3</a>
      </li>
      <li class="nav-item">
        <a class="pricing" href="Pages/Page4.html">Page4</a>
      </li>
    </ul>
  </div>
</div>

I have tried making the .navigation sticky, fixed, etc. The header doesn't seem to stick on the top of the page when I scroll down. Any ideas why it isn't sticking to the top of the page even though i did everything right? I don't mind adding Java Script if it is necessary. EDIT: I have tried adding sticky and top: 0; to the #header too, it doesn't work.