Far too often, an indexed view is created without consideration for the costs of the indexed view. In this article, Jason Brimhall covers some of the more important costs that are frequently overlooked when considering an indexed view as a performance panacea.
2019-04-05
Kevin Feasel provides three SSMS keyboard shortcuts for the sp_whoisactive calls he uses most often in day-to-day database development and query tuning work.
2019-04-02
The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell. I was asked to look into an issue recently where a 40-core SQL Server instance was fully utilizing a one node over all others...
2019-03-30
It’s surprisingly useful to know the number of active sessions on each of the databases on your servers. With a bit of SQL, we can create a custom metric to track how many sessions recently performed reads or writes on a database.
2019-03-30
I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be in setting up the test. Let’s try it out.
2019-03-30
Everything can be fixed with a query hint (*cough* directive), right? If a certain process is consistently causing deadlocks, a simple ROWLOCK hint can be added to prevent it, right?
2019-03-30
Previously Gail Shaw looked at using Query Store to compare execution plans, but it’s not the only way that two execution plans can be compared. The other method requires a saved execution plan and the Management Studio execution plan viewer.
2019-03-30
In this webcast, Tim Smith takes a look at various tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join him to learn how to optimize your systems
2018-08-15
4,840 reads
Optimize searching for a string within another string with this string storage and indexing technique.
2018-07-31
4,774 reads
Performance tuning is a creative process which requires a lot of attention and manual work. SQL Server 2016's Query Store makes some of this work much easier, but what if you're using an earlier version? Fikrat Azizov shows how to automate assessing SQL Server query performance changes by using custom performance collection tools and reports.
2016-06-23
4,487 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hello all, I would like to create an INSERT statement and use a UDF...
Comments posted to this topic are about the item Initial Config of tempdb
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers