300x250 AD TOP

Search This Blog

Pages

Paling Dilihat

  • RISC-V Linux on ESP32
    RISC-V Linux on ESP32
    I've been playing with the idea of running linux on ESP32 since the first days I've met its more robust module, the WROVER-B, on pap...
  • LVGL ESP32 and Desktop Development Walkthrough
    LVGL ESP32 and Desktop Development Walkthrough
    UI for Embedded is always a hassle, find the right MCU, find the right Display, connect the right wires and that's even before writing t...
  • Embedding QuickJS in your Projects
    Embedding QuickJS in your Projects
    QuickJS is small and embeddable Javascript engine made by the famous Fabrice Bellard , it supports ES2020 specifications and made available...
  • Unit Testing with ESP32 and PlatformIO
    Unit Testing with ESP32 and PlatformIO
    Writing Quality Code and Tests usually goes hand in hand, some find it more productive to write code and then write tests for it and others,...
  • Using the ILI9488
    Using the ILI9488
    The ILITEK ILI9488 is one of the larger and cheaper SPI displays available to the maker community,, available in 3.5" and 4". How...
  • A Million Times
    A Million Times
    A while ago someone at work approached me with an idea to build a replica of  " A Million Times " by Humans Since 1982 , while the...
  • ESP32 SD Card Optimization
    ESP32 SD Card Optimization
     Reading and writing SD Cards with ESP32 should be simple, however, the amount of moving parts in esp-idf makes that a complicated task, fir...
  • ESP32 Performance Profiling
    ESP32 Performance Profiling
    The ESP32 is very capable but even the most capable of devices can get overwhelmed when using it extensively, so how can we find out what is...
  • PlatformIO Static Code Analysis
    PlatformIO Static Code Analysis
    Source Writing code and testing it with unit and integration tests can provide high quality executable, however, it does not indicate if its...
  • Embedding Micropython in your Projects
    Embedding Micropython in your Projects
    MicroPython is a python implementation for microcontrollers and other low resource requirement implementation which can make it perfect for...
Powered by Blogger.
View Dror Gluska's LinkedIn profileView Dror Gluska's profile

Monday, March 29, 2010

SQL Index Creation Date

A while back I was trying to figure out a performance problem in SQL, eventually it was traced to an index that improved performance on other queries but the specific query was rarely used and it wasn't tested, this query helped me to figure out which index was added when.

Select OBJECT_NAME( sys.indexes.object_id ) AS TableName, Name as IndexName, 
STATS_DATE ( object_id , index_id ) as IndexCreatedDate
From sys.indexes 
order by STATS_DATE ( object_id , index_id ) desc
Read More
Tags:
Dror Gluska March 29, 2010  No comment
Subscribe to: Posts (Atom)