Performance
- Home /
- Categories /
- Performance
You can now access the SQL Server Diagnostic Book remotely!
UPDATE: This is now somewhat deprecated, because you can install the Book as an extension, without having to type anything, as detailed here .
Read MoreHow to lose hundreds of thousands of dollars by using functions in SQL Server
Ahh, functions, the greatest tool at a programmer’s disposal, they make code reusable and easy to read, they’ve been essential since the first function call was made in the last century…
Read MoreA Self-deployable TICK Stack for ingesting data, monitoring and alerting for any service (including SQL Server)
Oh boy, this is a spinoff of my previous post on “How To Use Grafana (On Docker) To Monitor Your Sql Server (Eventually On Docker Too) – Feat.
Read MorePROTIP: Performance Tuning on the cloud will save you money by the hour
Note: I'll be focusing on Azure Cloud and SQL Server, but these considerations are valid for any Cloud/DB Vendor.
Read MoreGet faster performance and lower network usage in SQL Server Loops by avoiding the "DONE Token" overload
FYI: You can get the Notebook for this article on my github and experiment yourself (opens with Azure Data Studio ).
Read MoreRow Level Security Performance Implications
A conversation had me wondering about performance implications in SQL Server RLS feature, specifically on how to mitigate the performance impact;
Read MoreA script to automatically align columnstore indexes to enhance segment elimination (and hence performances)
Columstore indexes are a “new” neat data structure that I like, even if technically they’ve been around for years, only recently they’ve become usable by most customers.
Read MoreA clarification on the waitstat: SOS_SCHEDULER_YIELD
Are you one of the people that says “we have a CPU related issue” whenever it sees SOS_SCHEDULER_YIELD popping up?
Read MoreWhat's the best way to massively update a big table?
A thing that can happen once in a while in a DW is the need to massively update a column in a table, let’s find out.
Read MoreTest: confronting various methods of bulk loading data from a table to another, what's the fastest?
Most of the support request I get involved with can be summarized with the following keywords: “slow” + “datawarehouse” + “ETL” + “Save us” What about thinking about ETL performance before it goes bad?
Read MoreScan Performance Showdown: INROW Predicate pushdown VS Batch Mode Adaptive Join vs Columnstore indexes
I was reading Paul White’s post about bitmaps in SQL Server and, other than realizing that I basically know nothing about anything (like a Socrate’s epiphany) I wanted to at least see how this good stuff added up in the latest 7 years.
Read MoreCreate an asynchronous multithreaded workflow on your SQL Server using the Service Broker
As any other *Server, SQL Server is born with concurrency in mind, a lot of users/applications can connect concurrently and do their job, as designed, perfect, but, what if you’re the only user?
Read MoreHow to avoid the traps when dealing with parallelism
I work with a vendor application which needs to do all sorts of data crunching in some nightly batches, and, depending on the size of data, this process may take a lot of time.
Read More