SEO report of tsql.nu

Magnus Ahlkvist | SQL Server, mostly T-SQL

tsql.nu
Error! The "meta description" is missing, the page has no summary description!

 Language

Declared Language Code
En-GB
Detected Language Code
en

 SSL checking

HTTPS
not used

 Content Report

Number of letters:
17790
Number of words:
3940
Number of sentences:
211
Average words per sentences:
19
Number of syllables:
5941
Syllables in words
5934
Average syllables in words:
1.51
Number of words in first three syllables:
585
Percentage of word / syllables:
14.85

 Readability

Readablitiy
  • Flesch–Kincaid Grade Level: 9.50
  • lesch Reading Ease: 60.30
  • Coleman Liau Index: 10.80
  • Automated Readability Index (ARI): 9.20
  • Dale–Chall Readability: 5.70
  • SMOG Index: 12.00
  • Spache Readability: 5.00
  • Words not in Dale-Chall easy-word list: 1209
  • Words not in Spache easy-word list: 592

 Keywords (2 words) / counter

  • "the table" / 11
  • "million rows" / 11
  • "for the" / 10
  • "union all" / 9
  • "sql saturday" / 9
  • "all select" / 9
  • "the delete" / 8
  • "with the" / 7
  • "cross join" / 7
  • "one million" / 7

 Keywords (3 words) / counter

  • "union all select" / 9
  • "one million rows" / 6
  • "for current period" / 5
  • "cross join cte" / 4
  • "brandname modelname releaseyear" / 4
  • "and non clustered" / 3
  • "generate time slots" / 3
  • "rows for current" / 3
  • "training and conferences" / 3
  • "non clustered indexes" / 3

 Important Meta Datas

Meta Title
Magnus Ahlkvist | SQL Server, mostly T-SQL

 Other Meta datas:

  • Name:
    Content: en_GB
  • Name: viewport
    Content: width=device-width
  • Name: generator
    Content: WordPress 4.4.2

 Html Elements

  • <a> : 92
  • <span> : 43
  • <p> : 42
  • <div> : 38
  • <li> : 26
  • <h1> : 16
  • <link> : 15
  • <script> : 14
  • <br> : 12
  • <meta> : 10
  • <aside> : 9
  • <header> : 8
  • <ul> : 7
  • <time> : 7
  • <article> : 7
  • <input> : 6
  • <strong> : 5
  • <pre> : 5
  • <footer> : 5
  • <style> : 4
  • <label> : 3
  • <form> : 3
  • <img> : 2
  • <abbr> : 2
  • <h2> : 1
  • <body> : 1
  • <nav> : 1
  • <head> : 1
  • <html> : 1
  • <button> : 1
  • <title> : 1

 Html Classes

  • <entry-meta> : 18
  • <entry-date> : 14
  • <widget> : 9
  • <widget-title> : 8
  • <url> : 8
  • <byline> : 7
  • <n> : 7
  • <vcard> : 7
  • <fn> : 7
  • <author> : 7
  • <type-post> : 7
  • <cat-links> : 7
  • <entry-header> : 7
  • <hentry> : 7
  • <format-standard> : 7
  • <post> : 7
  • <status-publish> : 7
  • <entry-title> : 7
  • <comments-link> : 7
  • <entry-content> : 7
  • <;> : 5
  • <screen-reader-text> : 5
  • <title:> : 5
  • <notranslate> : 5
  • <sql;> : 5
  • <brush:> : 5
  • <cat-item> : 4
  • <tag-links> : 4
  • <search-field> : 3
  • <search-submit> : 3
  • <search-form> : 3
  • <widget_search> : 2
  • <widget-area> : 2
  • <category-training-and-conferences> : 2
  • <tag-sql-training> : 2
  • <tag-sqlpass> : 2
  • <tag-sqlsaturday> : 2
  • <category-performance-tuning> : 2
  • <category-t-sql-code> : 2
  • <tag-link-4> : 1
  • <tag-link-5> : 1
  • <tag-link-10> : 1
  • <tag-link-6> : 1
  • <tag-link-14> : 1
  • <masthead-fixed> : 1
  • <tag-link-9> : 1
  • <tag-link-16> : 1
  • <tag-link-12> : 1
  • <widget_tag_cloud> : 1
  • <grid> : 1
  • <hfeed> : 1
  • <list-view> : 1
  • <tagcloud> : 1
  • <widget_image> : 1
  • <tag-link-15> : 1
  • <tag-link-11> : 1
  • <jetpack-image-container> : 1
  • <cat-item-13> : 1
  • <cat-item-8> : 1
  • <blog> : 1
  • <cat-item-7> : 1
  • <cat-item-1> : 1
  • <site-info> : 1
  • <site-footer> : 1
  • <widget_meta> : 1
  • <widget_categories> : 1
  • <widget_archive> : 1
  • <primary-sidebar> : 1
  • <site-description> : 1
  • <alignleft> : 1
  • <widget_recent_entries> : 1
  • <widget_recent_comments> : 1
  • <comment-author-link> : 1
  • <recentcomments> : 1
  • <content-sidebar> : 1
  • <category-uncategorized> : 1
  • <skip-link> : 1
  • <nav-menu> : 1
  • <page_item> : 1
  • <menu-toggle> : 1
  • <primary-navigation> : 1
  • <post-32> : 1
  • <site-navigation> : 1
  • <page-item-2> : 1
  • <search-box-wrapper> : 1
  • <content-area> : 1
  • <site-content> : 1
  • <post-39> : 1
  • <main-content> : 1
  • <site-main> : 1
  • <hide> : 1
  • <search-box> : 1
  • <home> : 1
  • <tag-dbcc-show_statistics> : 1
  • <header-main> : 1
  • <site-title> : 1
  • <post-21> : 1
  • <site-header> : 1
  • <site> : 1
  • <post-13> : 1
  • <wp-smiley> : 1
  • <tag-t-sql> : 1
  • <tag-performance> : 1
  • <search-toggle> : 1
  • <tag-statistics> : 1
  • <tag-index-maintenance> : 1
  • <post-27> : 1
  • <post-24> : 1
  • <tag-indexes> : 1
  • <tag-execution-plans> : 1
  • <post-1> : 1

 Links

We found a total of 53 different links.
External dofollow links:
11
Internal dofollow links:
42

External dofollow

Number of External dofollow links: 11

  • Href: /en-us/library/ms177564(v=sql.105).aspx
    Title: https://msdn.microsoft.com/en-us/library/ms177564(v=sql.105).aspx
    Count: 1
  • Href: /433/Sessions/Details.aspx
    Title: http://www.sqlsaturday.com/433/Sessions/Details.aspx?sid=38722
    Count: 2
  • Href: /433/Sessions/Details.aspx
    Title: Biml for Beginners: Generating SSIS packages with BimlScript
    Count: 1
  • Href: /433/Sessions/Details.aspx
    Title: When good SQL design goes bad
    Count: 1
  • Href: /433/Sessions/Details.aspx
    Title: How to kill SQL Server Performance
    Count: 1
  • Href: /433/Sessions/Details.aspx
    Title: SQL Server Magic buttons: What are Trace Flags, and why should I care
    Count: 1
  • Href: /433/EventHome.aspx
    Title: here
    Count: 1
  • Href: /Profile/9406530945
    Count: 1
  • Href: /IDisposable
    Title: Marc Brooks
    Count: 1
  • Href: /
    Title: WordPress.org
    Count: 1
  • Href: /
    Title: Proudly powered by WordPress
    Count: 1

Internal dofollow

Number of Internal dofollow links: 42

  • Href: /
    Title: Magnus Ahlkvist
    Count: 1
  • Href:
    Title: Search
    Count: 1
  • Href:
    Title: Skip to content
    Count: 1
  • Href: /about/
    Title: About me
    Count: 1
  • Href: /category/t-sql-code/
    Title: T-SQL code
    Count: 3
  • Href: /t-sql-code/archiving-with-the-output-clause/
    Title: Archiving with the OUTPUT clause
    Count: 3
  • Href: /author/admin/
    Title: admin
    Count: 7
  • Href: /t-sql-code/archiving-with-the-output-clause/
    Title: Leave a comment
    Count: 1
  • Href: /category/performance-tuning/
    Title: Performance tuning
    Count: 3
  • Href: /performance-tuning/statistics-on-ascending-columns/
    Title: Statistics on ascending columns
    Count: 3
  • Href: /performance-tuning/statistics-on-ascending-columns/
    Title: Leave a comment
    Count: 1
  • Href: /tag/dbcc-show_statistics/
    Title: DBCC SHOW_STATISTICS
    Count: 2
  • Href: /tag/index-maintenance/
    Title: index maintenance
    Count: 2
  • Href: /tag/statistics/
    Title: statistics
    Count: 2
  • Href: /t-sql-code/generate-time-slots/
    Title: Generate time slots
    Count: 3
  • Href: /t-sql-code/generate-time-slots/
    Title: 1 Comment
    Count: 1
  • Href: /performance-tuning/delete-and-non-clustered-indexes/
    Title: DELETE and Non Clustered Indexes
    Count: 3
  • Href: /performance-tuning/delete-and-non-clustered-indexes/
    Title: Leave a comment
    Count: 1
  • Href: /tag/execution-plans/
    Title: execution plans
    Count: 2
  • Href: /tag/indexes/
    Title: indexes
    Count: 2
  • Href: /tag/performance/
    Title: performance
    Count: 2
  • Href: /tag/t-sql/
    Title: t-sql
    Count: 2
  • Href: /category/training-and-conferences/
    Title: Training and conferences
    Count: 3
  • Href: /training-and-conferences/impressions-from-sql-saturday-433/
    Title: Impressions from Sql Saturday 433
    Count: 3
  • Href: /training-and-conferences/impressions-from-sql-saturday-433/
    Title: Leave a comment
    Count: 1
  • Href: /tag/sql-training/
    Title: SQL Training
    Count: 3
  • Href: /tag/sqlpass/
    Title: SQLPass
    Count: 3
  • Href: /tag/sqlsaturday/
    Title: SQLSaturday
    Count: 3
  • Href: /training-and-conferences/sql-saturday-433-gothenburg/
    Title: SQL Saturday 433, Gothenburg
    Count: 2
  • Href: /training-and-conferences/sql-saturday-433-gothenburg/
    Title: Leave a comment
    Count: 1
  • Href: /category/uncategorized/
    Title: Uncategorized
    Count: 2
  • Href: /uncategorized/hello-world/
    Title: Hello world!
    Count: 2
  • Href: /uncategorized/hello-world/
    Title: Leave a comment
    Count: 1
  • Href: /t-sql-code/generate-time-slots/
    Title: Generate time slots
    Count: 1
  • Href: /2016/04/
    Title: April 2016
    Count: 1
  • Href: /2015/11/
    Title: November 2015
    Count: 1
  • Href: /2015/10/
    Title: October 2015
    Count: 1
  • Href: /2015/09/
    Title: September 2015
    Count: 1
  • Href: /2015/07/
    Title: July 2015
    Count: 1
  • Href: /wp-login.php
    Title: Log in
    Count: 1
  • Href: /feed/
    Title: Entries RSS
    Count: 1
  • Href: /comments/feed/
    Title: Comments RSS
    Count: 1

Mistakes

sql.nu, trsql.nu, rsql.nu, tfsql.nu, fsql.nu, tgsql.nu, gsql.nu, thsql.nu, hsql.nu, tysql.nu, ysql.nu, t5sql.nu, 5sql.nu, t6sql.nu, 6sql.nu, tql.nu, tsqql.nu, tqql.nu, tswql.nu, twql.nu, tseql.nu, teql.nu, tszql.nu, tzql.nu, tsxql.nu, txql.nu, tscql.nu, tcql.nu, tsl.nu, tsqwl.nu, tswl.nu, tsqel.nu, tsel.nu, tsqsl.nu, tssl.nu, tsqal.nu, tsal.nu, tsq1l.nu, ts1l.nu, tsq2l.nu, ts2l.nu, tsq.nu, tsqlp.nu, tsqp.nu, tsqlo.nu, tsqo.nu, tsql.nu, tsq.nu, tsqli.nu, tsqi.nu, tsqlk.nu, tsqk.nu, tsqlm.nu, tsqm.nu, tsql..nu, tsq..nu

More Sites

  • Title: Not set
  • Description:
  • Sites loading time: 5718
  • Internet Protocol (IP) address: 202.124.241.178
  • Javascript total size: 0.00B
  • CSS total size: 34.63KB
  • Image total size: 54.37KB
  • Total size: 101.95KB
  • Tech:
    • Other
      • Html (HyperText Markup Language)
  • Title: Kallmaier & Haslbauer GmbH
  • Description: Ihr Fachbetrieb für Sanitär, Heizung und Lüftung
  • Internet Protocol (IP) address: 217.160.122.153
  • Tech:
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • Php (Hypertext Preprocessor)
      • SVG (Scalable Vector Graphics)
  • Title: tottalprotect.com
  • Description:
  • Sites loading time: 878
  • Internet Protocol (IP) address: 185.53.178.8
  • Javascript total size: 80.27KB
  • CSS total size: 960.00B
  • Image total size: 42.78KB
  • Total size: 137.90KB
  • Tech:
    • Analytic
      • Google Analytics
    • Advertisement
      • Google Adsense
    • CDN
      • CloudFront
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Javascript
      • Php (Hypertext Preprocessor)
  • Title: Mako Medical - Award winning reference laboratory.
  • Description: Mako Medical is a full service, award winning laboratory. Mako Medical offers toxicology, genetics and pathology testing. COLA & CLIA certified.
  • Internet Protocol (IP) address: 192.185.51.160
  • Tech:
    • CMS
      • Wordpress CMS
    • Analytic
      • Google Analytics
    • Other
      • CSS (Cascading Style Sheets)
      • Flexslider
      • Google Font API
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • jQuery
      • jQuery UI
      • Php (Hypertext Preprocessor)
      • Pingback
      • Revslider
      • SVG (Scalable Vector Graphics)
  • Title: Anstrom Elektrotechnik GmbH
  • Description: Anstrom Elektrotechnik GmbH - Wir bieten individuell abgestimmte Lösungen im Bereich der Elektrotechnik und Elektroinstallation.
  • Sites loading time: 269
  • Internet Protocol (IP) address: 178.63.162.142
  • Javascript total size: 29.37KB
  • CSS total size: 19.35KB
  • Image total size: 93.99KB
  • Total size: 228.90KB
  • Tech:
    • Analytic
      • Google Analytics
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Html5
  • Title: Ship Bottom Rentals Ship Bottom Rental Vacation Beach Front Rentals New Jersey Shore Rentals Beach Lodging Bed And Breakfast
  • Description: Ship Bottom Rentals, Ship Bottom Rental at the New Jersey Shore. Find Ship Bottom motels, beach hotels, lodging, bed and breakfast, condominiums, apartments, house rentals at the New Jersey Shore. Vacation resorts, beach vacations, New Jersey casinos, shore destinations, beach resorts, boardwalk attractions, rides, amusements, fishing, boat rentals, fishing charters at the New Jersey Shore. Fun at the Jersey Shore.
  • Sites loading time: 1361
  • Internet Protocol (IP) address: 64.237.34.53
  • Javascript total size: 459.39KB
  • CSS total size: 0.00B
  • Image total size: 22.26KB
  • Total size: 642.68KB
  • Tech:
    • Advertisement
      • Google Adsense
    • Other
      • CSS (Cascading Style Sheets)
      • Javascript
  • Title: ?????????????????(??????????????)
  • Description:
  • Sites loading time: 2454
  • Internet Protocol (IP) address: 27.254.144.221
  • Javascript total size: 0.00B
  • CSS total size: 721.00B
  • Image total size: 273.43KB
  • Total size: 296.37KB
  • Tech:
    • Other
      • CSS (Cascading Style Sheets)
      • Google Font API
  • Title: All Things Yummy
  • Description:
  • Sites loading time: 13536
  • Internet Protocol (IP) address: 104.16.87.230
  • Javascript total size: 177.10KB
  • CSS total size: 144.52KB
  • Image total size: 1.92MB
  • Total size: 2.31MB
  • Tech:
    • Analytic
      • Google Analytics
    • Other
      • CSS (Cascading Style Sheets)
      • Google Font API
      • Html (HyperText Markup Language)
      • Html5
      • Javascript
      • SVG (Scalable Vector Graphics)
  • Title: Pripa Design and Painting - About
  • Description: Interior Exterior Painting by professional painters
  • Internet Protocol (IP) address: 199.34.228.57
  • Tech:
    • Analytic
      • Google Analytics
      • Quantcast Measurement
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Html5
      • Iframe
      • Javascript
      • SVG (Scalable Vector Graphics)
  • Title: Energeia Nutechsys
  • Description: Energeia, nutechsys, energia, solare,termico, eolico, acqua, acque, bianche, chiare, reflui, diogene, generatori, impianti, rifiuti, trattamento, strade, sicurezza, stradale, biogas, risparmio, nuove, tecnologia,cogenerazione, termodistruttori, termovalorizzatori, scanner, sicurezza, sistemi, risanamento
  • Sites loading time: 1401
  • Internet Protocol (IP) address: 62.149.140.52
  • Javascript total size: 163.29KB
  • CSS total size: 23.39KB
  • Image total size: 498.78KB
  • Total size: 698.20KB
  • Tech:
    • CMS
      • Joomla CMS
    • Other
      • CSS (Cascading Style Sheets)
      • Html (HyperText Markup Language)
      • Javascript
      • jQuery
      • MooTools
      • Php (Hypertext Preprocessor)