aus Wikipedia, der freien Enzyklopädie
Zur Navigation springen
Zur Suche springen
Programmierung
Programmierung
|
Administration •
Links •
Vorgehensmodelle •
NuGet •
Transformations •
MSBuild •
Raspberry •
Cheatsheets •
Git •
Mathematica
|
C♯
|
|
F♯
|
|
Python
|
Classes •
Loops •
Anonymous Types •
Lambda Expressions •
Queries (LINQ) •
Iterators (yield)
|
PHP
|
|
T-SQL / SQL Server
|
T-SQL Fundamantals
|
Select •
Programming •
Pitfalls •
Query from Multiple Tables •
Groups and Summaries •
Advanced Select •
Aggregation and Windowing •
Insert, Update, Delete •
Strings •
Date and Time •
Numbers •
Transactions, Locking, Blocking, Deadlock •
Tables •
Views •
Large Tables and Databases •
Indexes •
Stored Procedures •
User-Defined Functions and Types •
Triggers •
Error Handling •
Query Performance and Tuning •
Hints •
Index Tuning and Statistics •
XML •
Files, Filegroups, Integrity •
Backup •
Recovery •
Principals and Users •
Securables, Permissions, Auditing •
Objects and Dependencies
|
SQL Server Performance Tuning
|
Memory Performance Analysis •
Disk Performance Analysis •
CPU Performance Analysis •
Baseline Creation •
Query Performance Metrics •
Query Performance Analysis •
Index Architecture and Behavior •
Index Analysis •
Database Engine Tuning Advisor •
Key Lookups •
Statistics, Data Distributuon, and Cardinality •
Index Fragmentation •
Execution Plan Generation •
Execution Plan Cache Behavior •
Parameter Sniffing •
Query Recompilation •
Query Design Analysis •
Reduce Query Resource Use •
Blocking and Blocked Processes •
Causes and Solutions for Deadlocks •
Row-By-Row Processing •
Memory-Optimized OLTP Tables and Procedures •
Database Performance Testing •
Database Workload Optimization •
SQL Server Optimization Checklist
|
Service Broker
|
Message •
Contract •
Queue •
Service •
.NET Integration •
Route •
Security
|
|
Datatypes •
Unit Testing •
Dependency Injection •
Partitioning •
|
|
.NET
|
|
ASP.NET
|
|
Messaging
|
|
User Interface
|
|
Parallel Programming
|
|
ECMAScript
|
|
SharePoint
|
|
Microsoft CRM
|
Reporting and Dashboards •
SharePoint Integration •
Authentication •
Entity Handling •
Workflows •
Queries
|
Security
|
Forms Authentication •
Membership and Role Provider •
Zertifikate •
OAuth •
OpenID •
Windows Identity Foundation
|
Dateiformate
|
CSV •
Excel •
Word •
PDF •
Email
|
Azure
|
|
Muster
|
|
Powershell
|
|
Android
|
ROM Flashen •
Unit Testing •
Assistant
|
Machine Learning
|
|
Core Server
|
Hyper-V •
Active Directory User Groups •
Active Directory Domain Services •
Active Directory Federation Services •
DHCP •
IIS •
DNS •
RDP •
WSUS •
User Permissions •
IP •
SMB •
DHCP •
IPAM •
Sonstige
|
Bot Framework
|
Rich Messages •
|
Arithmetic Operators
Operator |
Example |
Description
|
+ |
x + y |
Addition
|
- |
x - y |
Subtraction
|
* |
x * y |
Multiplication
|
/ |
x / y |
Division
|
% |
x % y |
Remainder
|
- |
-x |
Unary minus
|
Comparison Operators
Operator |
Example |
Description
|
< |
x < y |
Less than
|
<= |
x <= y |
Less than or equal to
|
> |
x > y |
Greater than
|
>= |
x >= y |
Greater than or equal to
|
(=) |
x = y |
Equality
|
<> |
x <> y |
Inequality
|
min |
min x y |
Minimum
|
max |
max x y |
Maximum
|
Math Operators
Operator |
Example |
Description
|
abs |
abs x |
Overloaded absolute value
|
acos |
acos x |
Overloaded inverse cosine
|
asin |
asin x |
Overloaded inverse sine
|
atan |
atan x |
Overloaded inverse tangent
|
ceil |
ceil x |
Overloaded floating-point ceil
|
cos |
cos x |
Overloaded cosine
|
exp |
exp x |
Overloaded exponent
|
floor |
floor x |
Overloaded floating-point floor
|
log |
log x |
Overloaded natural logarithm
|
log10 |
log10 x |
Overloaded base-10 logarithm
|
(**) |
x ** y |
Overloaded exponential
|
pown |
pown x y |
Overloaded integer exponential
|
round |
round x |
Overloaded rounding
|
sin |
sin x |
Overloaded sine function
|
sqrt |
sqrt x |
Overloaded square root function
|
tan |
tan x |
Overloaded tangent function
|
|