Skip to content

Commit e3395a7

Browse files
unruledboyunruledboy
committed
v2.5
added isolation levels, features by versions
1 parent 0306cb4 commit e3395a7

2 files changed

Lines changed: 115 additions & 6 deletions

File tree

‎ux/DatabaseStack.htm‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -92,7 +92,7 @@
9292
<div class="container">
9393
<header>
9494
<div class="left">
95-
<h1><a href="https://github.com/unruledboy/DatabaseStack" target="_blank">Database Stack v2.4</a></h1>
95+
<h1><a href="https://github.com/unruledboy/DatabaseStack" target="_blank">Database Stack v2.5</a></h1>
9696
</div>
9797
<div class="right">
9898
<p><a href="http://github.com/unruledboy">Wilson Chen (twitter@unruleboy) - unruledboy@gmail.com</a></p>

‎ux/DatabaseStack.json‎

Lines changed: 114 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -214,12 +214,46 @@
214214
},
215215
{ "name": "Checkpoint" },
216216
{
217-
"name": "Isolation Levels",
217+
"name": "Isolation Levels (low to high)",
218+
"url": "https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx",
218219
"children": [
219-
{ "name": "Read uncommitted" },
220-
{ "name": "Read committed" },
220+
{
221+
"name": "Read uncommitted",
222+
"children": [
223+
{ "name": "dirty read" },
224+
{ "name": "same as NOLOCK hint" }
225+
]
226+
},
227+
{
228+
"name": "Read committed (default)",
229+
"children": [
230+
{
231+
"name": "READ_COMMITTED_SNAPSHOT",
232+
"children": [
233+
{
234+
"name": "ON",
235+
"children": [
236+
{ "name": "repeatable read" }
237+
]
238+
},
239+
{
240+
"name": "OFF (default)",
241+
"children": [
242+
{ "name": "Nonrepeatable read, phantom" }
243+
]
244+
}
245+
]
246+
}
247+
]
248+
},
221249
{ "name": "Repeatable read" },
222-
{ "name": "Snapshot" },
250+
{
251+
"name": "Snapshot",
252+
"children": [
253+
{ "name": "Database ALLOW_SNAPSHOT_ISOLATION ON" },
254+
{ "name": "2005+" }
255+
]
256+
},
223257
{ "name": "Serializable" }
224258
]
225259
}
@@ -398,6 +432,15 @@
398432
{ "name": "Key" },
399433
{ "name": "Default" },
400434
{ "name": "Synonym" },
435+
{ "name": "Sequence" },
436+
{
437+
"name": "Variable",
438+
"children": [
439+
{ "name": "Local Variable (@)" },
440+
{ "name": "Global Variable (@@)" }
441+
]
442+
},
443+
{ "name": "Common Table Expression (CTE)" },
401444
{ "name": "Cursor" },
402445
{ "name": "Collation" },
403446
{ "name": "Login" },
@@ -639,6 +682,67 @@
639682
},
640683
{
641684
"name": "Versions",
685+
"children": [
686+
{
687+
"name": "SQL Server 2005",
688+
"children": [
689+
{ "name": "SSIS" },
690+
{ "name": "SSRS" },
691+
{ "name": "SSAS" },
692+
{ "name": "Common Language Runtime (CLR)" },
693+
{ "name": "XML" },
694+
{ "name": "Data Service (SOAP)" },
695+
{ "name": "Service Broker" },
696+
{ "name": "Common Table Expression (CTE)" },
697+
{ "name": "Dynamic Management View (DMV)" },
698+
{ "name": "Database Mirroring (SP1)" },
699+
{ "name": "TRY/CATCH" }
700+
]
701+
},
702+
{
703+
"name": "SQL Server 2008",
704+
"children": [
705+
{ "name": "Always On" },
706+
{ "name": "FILESTREAM" },
707+
{ "name": "Integrated Full-Text Search (iFTS)" },
708+
{
709+
"name": "Spatial Types",
710+
"children": [
711+
{ "name": "GEOMETRY" },
712+
{ "name": "GEOGRAPHY" }
713+
]
714+
},
715+
{ "name": "Transparent Data Encryption (TDE)" },
716+
{ "name": "IntelliSense" },
717+
{ "name": "SSRS Charting (acquired Dundas charts)" }
718+
]
719+
},
720+
{
721+
"name": "SQL Server 2012",
722+
"children": [
723+
{ "name": "Columnstore Index" },
724+
{ "name": "Sequence" },
725+
{ "name": "THROW" }
726+
]
727+
},
728+
{
729+
"name": "SQL Server 2014",
730+
"children": [
731+
{ "name": "In-memory Table" }
732+
]
733+
},
734+
{
735+
"name": "SQL Server 2016",
736+
"children": [
737+
{ "name": "JSON" },
738+
{ "name": "Ploybase (connector to BigData)" },
739+
{ "name": "Always Encrypted" }
740+
]
741+
}
742+
]
743+
},
744+
{
745+
"name": "Editions",
642746
"children": [
643747
{ "name": "Express" },
644748
{ "name": "BI" },
@@ -697,7 +801,12 @@
697801
{
698802
"name": "Business Intelligence (BI)",
699803
"children": [
700-
{ "name": "SQL Server Integration Service (SSIS)" },
804+
{
805+
"name": "SQL Server Integration Service (SSIS)",
806+
"children": [
807+
{ "name": "Extract-Transform-Load (ETL)" }
808+
]
809+
},
701810
{ "name": "SQL Server Reporting Service (SSRS)" },
702811
{ "name": "SQL Server Analysis Service (SSAS)" }
703812
]

0 commit comments

Comments
 (0)