Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What the heck does 'ALFKI' mean?

I've seen this abbreviation (or mnemonic) used in various examples in SQL and web services.

What does it mean? And if you know, what are its origins?

like image 635
Even Mien Avatar asked Apr 27 '09 14:04

Even Mien


People also ask

How is SQL used in real life?

SQL is used in everyday life by some of the biggest companies like Netflix, Linkedin, Amazon, Flipkart, Instagram. Uber for data analysis and performance analysis. Even small companies and startups employ SQL for similar purposes. SQL is a great tool for interacting with databases and fetching vital data.

How do I find the top 10 queries in SQL Server?

If you want to find the top 'n' queries that are currently in the cache, which are consuming more CPU, then you are at the right place. sys. dm_exec_query_stats DMV contains all the information about the resource (CPU, Memory, I/O) consuming queries that are currently in the cache.


2 Answers

It's the primary key (CustomerID) of the First Customer entry in the Microsoft Northwind Demo Database

ALFKI    Alfreds Futterkiste  Maria Anders     Sales Representative     Obere Str. 57   Berlin       12209    Germany  030-0074321  030-0076545 
like image 98
Eoin Campbell Avatar answered Sep 23 '22 02:09

Eoin Campbell


It's the unique key of "Alfreds Futterkiste", the first "Customers" table entry in Microsoft's "Northwind" sample database that ships with SQL Server.

like image 44
Tomalak Avatar answered Sep 27 '22 02:09

Tomalak