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
5,170 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
Security on your SQL Server is important. That doesn’t need any explaining. But where...
It’s that time of year again! EightKB is back on August 20th at 13:00...
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers