Seek or Scan – Cost Based Optimizer in SQL Server
When SQL Server has a choice of plans, it will compare the cost among a set of execution plans and will choose the cheapest one. In some cases, even...
2016-05-15
4 reads
When SQL Server has a choice of plans, it will compare the cost among a set of execution plans and will choose the cheapest one. In some cases, even...
2016-05-15
4 reads
SQL Server caches temporary objects (temporary tables and table variables), that are created in a stored procedure. Temporary objects that are created either in dynamic SQL statement or by...
2016-05-15
2 reads
In SQL Server, the concurrent creation of temporary objects (temporary tables and table variables) from many sessions can lead to tempdb allocation contention. This contention occurs on PFS and...
2016-05-15
2 reads
In SQL Server, the concurrent creation of temporary tables from many sessions can lead to tempdb metadata contention. Tempdb metadata contention does not affect the concurrent creation of table...
2016-05-15
5 reads
In SQL Server, ASYNC_NETWORK_IO wait time can be high due to slow network, like when the database is in the cloud and the application is on premise. Furthermore, it...
2016-05-15
Resource Governor in SQL Server provides CPU, Memory and I/O throttling. In SQL Server 2014 and earlier, CPU throttling works only for similar kind of workloads and not for...
2016-05-14
SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...
2016-05-10
2 reads
When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...
2016-05-09
3 reads
ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...
2016-02-01
1 reads
ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...
2016-02-01
2 reads
By John
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...
By Steve Jones
Ever since VS Code and Azure Data Studio came out, people have been asking...
Explore how to avoid unwanted results that oft occur due to lack of attention...
There is a lot of spam from time to time. Is it possible to...
With Bitcoin costs skyrocketing from 2017 to 2018, Bitcoin is in the news all...
Male UltraCore Review Exercises Are Extremely Successful - After using supplements, and after having...