SharePointCommunity
Die deutschsprachige Community für SharePoint, Microsoft 365, Teams, Yammer und mit Azure
Anmelden
|
Beitreten
|
Hilfe
Home
Angebote
Blogs
Foren
Podcast
Youtube
Social
Wikis
ToolBox
Partner
UserGroups
Termine
Impressum
SharePointPodcast
M.Greth
@IntranetBabett
TechNet
Mirror
UserGroups
SharePoint Mirror
»
Alle Tags
»
Performance
(
RSS
)
Nach Markierungen suchen
Blogs
SharePoint Mirror
Home
Sponsored by
Partner
Syndication
RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren
Recent Posts
Use ‘lodash’ in SPFx projects – important things to know
How to Save 7 Keystrokes with dbms_xplan
Bitmap-based COUNT(DISTINCT) Functions in Oracle 19c
Materialized View Refresh for Dummies
Data Types of Join Columns
Tags
Allgemein
Azure
Cloud
deutsch
Developer
Development
english
HowTo
Microsoft
MVP
News
Newsticker
next Generation Sync Client
Office 2010
Office 2013
Office 365
Office365
OneDrive
OneDrive for Business
SharePoint
SharePoint 2010
Sharepoint 2013
SharePoint Online
Ticker
Tipps
View more
Archives
Februar 2021 (13)
Januar 2021 (8)
Dezember 2020 (16)
November 2020 (20)
Oktober 2020 (24)
September 2020 (26)
August 2020 (20)
Juli 2020 (39)
Juni 2020 (26)
Mai 2020 (32)
April 2020 (26)
März 2020 (42)
Februar 2020 (28)
Januar 2020 (34)
Dezember 2019 (38)
November 2019 (28)
Oktober 2019 (32)
September 2019 (40)
August 2019 (31)
Juli 2019 (45)
Juni 2019 (54)
Mai 2019 (60)
April 2019 (40)
März 2019 (65)
Februar 2019 (56)
Januar 2019 (68)
Dezember 2018 (43)
November 2018 (47)
Oktober 2018 (54)
September 2018 (41)
August 2018 (45)
Juli 2018 (60)
Juni 2018 (76)
Mai 2018 (84)
April 2018 (88)
März 2018 (83)
Februar 2018 (91)
Januar 2018 (113)
Dezember 2017 (95)
November 2017 (85)
Oktober 2017 (97)
September 2017 (121)
August 2017 (60)
Juli 2017 (101)
Juni 2017 (92)
Mai 2017 (92)
April 2017 (111)
März 2017 (130)
Februar 2017 (110)
Januar 2017 (101)
Dezember 2016 (113)
November 2016 (107)
Oktober 2016 (129)
September 2016 (108)
August 2016 (84)
Juli 2016 (87)
Juni 2016 (95)
Mai 2016 (139)
April 2016 (104)
März 2016 (106)
Februar 2016 (83)
Januar 2016 (98)
Dezember 2015 (96)
November 2015 (106)
Oktober 2015 (94)
September 2015 (71)
August 2015 (76)
Juli 2015 (93)
Juni 2015 (85)
Mai 2015 (98)
April 2015 (113)
März 2015 (103)
Februar 2015 (107)
Januar 2015 (107)
Dezember 2014 (96)
November 2014 (110)
Oktober 2014 (141)
September 2014 (146)
August 2014 (106)
Juli 2014 (136)
Juni 2014 (133)
Mai 2014 (129)
April 2014 (143)
März 2014 (195)
Februar 2014 (150)
Januar 2014 (143)
Dezember 2013 (144)
November 2013 (130)
Oktober 2013 (173)
September 2013 (140)
August 2013 (120)
Juli 2013 (148)
Juni 2013 (155)
Mai 2013 (148)
April 2013 (164)
März 2013 (155)
Februar 2013 (151)
Januar 2013 (209)
Dezember 2012 (182)
November 2012 (190)
Oktober 2012 (219)
September 2012 (164)
August 2012 (167)
Juli 2012 (203)
Juni 2012 (112)
Mai 2012 (144)
April 2012 (150)
März 2012 (163)
Februar 2012 (164)
Januar 2012 (112)
Dezember 2011 (158)
November 2011 (120)
Oktober 2011 (101)
September 2011 (93)
August 2011 (80)
Juli 2011 (102)
Juni 2011 (139)
Mai 2011 (124)
April 2011 (134)
März 2011 (179)
Februar 2011 (102)
Januar 2011 (86)
Dezember 2010 (85)
November 2010 (54)
Oktober 2010 (108)
September 2010 (108)
August 2010 (57)
Juli 2010 (84)
Juni 2010 (67)
Mai 2010 (68)
April 2010 (65)
März 2010 (55)
Februar 2010 (66)
Januar 2010 (64)
Dezember 2009 (52)
November 2009 (64)
Oktober 2009 (138)
September 2009 (59)
August 2009 (43)
Juli 2009 (35)
Juni 2009 (25)
Mai 2009 (32)
April 2009 (11)
März 2009 (6)
Februar 2009 (1)
Januar 2009 (7)
Dezember 2008 (1)
September 2008 (1)
Juni 2006 (1)
#tc12c
$watch
.NET
12c
32767
acfs
adaptive cursor sharing
adaptive dynamic sampling
adaptive features
Administration
ads
ADWC
Allgemein
angular.js
App Service
App Service Plan
AppFabric
ASM
Azure
Azure Cloud Shell
Bandbreite
Bayes
Bayesian
Benchmarking
benchmarks
Berlin
Business
Caching
Client Programming
Cloud
columnar
Community
conferences
ContentDB
cost_based_optimizer
cursor sharing
db12c
dbms_feature_awr
dbms_spd
Deployments
DeveloperWeek
Dimensional Modeling
DistributedCacheService;Neuinstallation;SharePoint 2013;crash
DOAGcontent
DotNet
DWH Architecture
DWX
dynamic sampling
EntityFramework
Entwicklung
ETL
Event
execution plan
extended data types
extended varchar
Fabian Moritz
Feature Pack 1
Hibernate
hints
http
Ignite
Ignite 2016
Infrastruktur
in-memory
IOPS
Item
ITPro
IT-Pro
JAGS
Jason Himmelstein
java
JDBC
jOOQ
Materialized Views
Microsoft Technologien
Office 365
Optimierung
optimizer
Oracle
Oracle 12c
Oracle Database
Oracle Database 12c
Parallel Processing
Partitioning
podcast
PowerShell
SharePoint
SharePoint 2010
Sharepoint 2013
Sharepoint 2016
SharePoint Online
SQL
sql plan directives
SQL Server
statistics
Swingbench
Tracing
transparent data encryption
Trivadis Blog
Visual Studio
Use ‘lodash’ in SPFx projects – important things to know
Lodash is one of those utility classes many JavaScript developers uses. This modern JavaScript utility […] Mehr…
Veröffentlicht
24 Nov 2019 1:16
von
Stefan Bauer – N8D
Gespeichert unter:
Performance
,
Web Development
,
SPFX
,
webpack
,
optimization
,
lodash
How to Save 7 Keystrokes with dbms_xplan
An almost unknown simplification in the usage of dbms_xplan is possible since Oracle 12.2. Sometimes, there are small details that makes our job (a little bit) easier. In one of his presentations at the Kscope19 conference, Kim Berg Hansen mentioned an...
Veröffentlicht
16 Jul 2019 22:22
von
triBLOG
Gespeichert unter:
Oracle
,
Performance
,
PL/SQL
,
Oracle 12c
Bitmap-based COUNT(DISTINCT) Functions in Oracle 19c
Oracle 19c provides a set of new SQL functions for bitmap operations. They allow fast computation of COUNT(DISTINCT) expressions. What is the purpose of these functions? The Oracle documentation is very sparse, but at least it tells us that the main …...
Veröffentlicht
20 Apr 2019 21:13
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Performance
,
Materialized Views
,
oracle 19c
Materialized View Refresh for Dummies
Materialized Views are often used in data warehouses to improve query performance on aggregated data. But what if it takes too long to refresh the materialized views? Here are some basic rules to improve refresh performance. Unlike indexes, materialized...
Veröffentlicht
18 Feb 2019 21:19
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Performance
,
ETL
,
Materialized Views
Data Types of Join Columns
The data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema. In a performance review of a customer project, … Continue reading →...
Veröffentlicht
11 Dez 2018 18:16
von
triBLOG
Gespeichert unter:
Oracle
,
Performance
,
Data Vault Modeling
,
ADWC
Star Schema Optimization in Autonomous Data Warehouse Cloud
Oracle Autonomous Data Warehouse Cloud does not allow to create indexes. Is this a problem for star schemas because no Star Transformation can be used? Or are the required bitmap indexes automatically created? A look under the hood of ADWC. … Continue...
Veröffentlicht
13 Sep 2018 18:03
von
triBLOG
Gespeichert unter:
Oracle
,
Cloud
,
Performance
,
in-memory
,
Dimensional Modeling
,
ADWC
10 Tips to Improve ETL Performance – Revised for ADWC
The Autonomous Data Warehouse Cloud (ADWC) is a self-configuring, fast, secure and scalable platform for data warehouses. Does this mean we don’t have to take care anymore about performance of our ETL processes? Which performance tips are still important...
Veröffentlicht
20 Jul 2018 15:29
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Cloud
,
Performance
,
ETL
,
ADWC
Gathering Statistics in the Autonomous Data Warehouse Cloud
Optimizer statistics are essential for good execution plans and fast performance of the SQL queries. Of course, this is also the case in the Autonomous Data Warehouse Cloud. But the handling of gathering statistics is slightly different from what we …...
Veröffentlicht
11 Jul 2018 17:46
von
triBLOG
Gespeichert unter:
Oracle
,
Cloud
,
Performance
,
ETL
,
ADWC
Bloom filters and parallel execution
Today I want to share with you another interesting example of solving performance problem which happened in the database used for Business Intelligence purposes. Users were complaining that the performance in kind of staging database (STGDB) was much...
Veröffentlicht
5 Jul 2018 15:10
von
triBLOG
Gespeichert unter:
Oracle
,
Troubleshooting
,
Performance
,
optimizer
,
statistics
,
Parallel Processing
,
dynamic sampling
,
parsing
,
bloom filter
Adaptive Plans at Kscope Community Service Day
Since Oracle 12c, the query optimizer is able to change execution plans at runtime. This feature is called “Adaptive Plans”. Something similar happened on the ODTUG Community Service Day at the Kscope conference in Orlando. The ODTUG Community Service...
Veröffentlicht
14 Jun 2018 22:51
von
triBLOG
Gespeichert unter:
Oracle
,
Performance
,
conferences
,
Oracle 12c
Playing with statistics modification hints
How often did you have the situation when performance problem disappeared just after refreshing object statistics? Of course it is nice to solve the problem quickly and simply, but is always better to understand what has exactly happened. Recently I had...
Veröffentlicht
7 Jun 2018 9:00
von
triBLOG
Gespeichert unter:
Oracle
,
Performance
,
hints
,
optimizer
,
statistics
,
execution plan
10: Office 365 Performance
Wenn wir über Office 365 Performance reden, sollten wir die folgenden Punkte beachten: SharePoint on-premise vs. Online Bandbreite CDN (Content Delivery Network) UI, ggf. eigene Lösungen, Masterpage Mit Browser Developer Tools analysieren Große Listen...
Veröffentlicht
18 Mai 2018 11:08
von
SharePoint und Office 365 Blog
Gespeichert unter:
Office 365
,
podcast
,
Performance
Using Temporary Tables for Complex Reports
Global temporary tables (or private temporary tables, if you use Oracle 18c) are a practical feature to be used for SQL queries with multiple steps, for example complex reports in a data warehouse. If you want to use them, some … Continue reading...
Veröffentlicht
15 Mai 2018 23:40
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Performance
,
ETL
,
DWH Architecture
Azure App mit PremiumV2 App Plan klonen
In Microsoft Azure gibt es den neuen App Plan PremiumV2. Neuste Funktionen sind vor allem bessere Performance der aktuellen CPU Generation, sowie SSD Speicher – yeah. Hört sich vielversprechend an, also gleich mal ausprobieren. Doch die erste Hürde...
Veröffentlicht
20 Apr 2018 8:33
von
SharePoint und Office 365 Blog
Gespeichert unter:
PowerShell
,
Azure
,
Skalierung
,
Performance
,
Azure Cloud Shell
,
App Service
,
Scale up
,
Klonen
,
App Service Plan
,
Resource Group
Keep Your SQL Simple (and Fast)
Complex SQL statements are hard to understand – not only for us, but for the query optimizer, too. Sometimes, it is a good idea to write a simpler SQL query to do the same work. Here a nice story about … Continue reading →...( read more...
Veröffentlicht
3 Apr 2018 22:01
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Performance
1
2
3
4
5
Weiter >
...
Letzte »
CC BY-NC-ND - Michael Greth
3DZL:andrewbelon.com
Datenschutzerklärung