You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide to Table-Valued Parameters! Hello and welcome! My name is Vedran Kesegić and this video is an absolute “must” for database developers. Fast performing database …
How to pass arrays to SQL? TVP – The Ultimate Guide Read more »
Want to learn SQL and need some guidance? SQL is the language you communicate with most of databases today, including SQL Server. Watch these videos: SQL for absolute beginners https://www.youtube.com/watch?v=27axs9dO7AE SELECT basics https://www.youtube.com/watch?v=SoxHivg9Ldw SELECT extended https://www.youtube.com/watch?v=D37_7p0-iKM Subqueries (a bit advanced) …
There are ways to greatly improve performance and power of your SQL Server databases in Azure. Even better, monthly costs are reduced at the same time! How is that even possible? I routinely do that for my customers and will …
OUTER APPLY(SELECT TOP 1) pattern is widespread, even baked into some frameworks like Entity Framework. But is it a good practice? This demo will show. Based on a real-world optimization problem and solved with great success. The demo shows it …
There is no official information (that I am aware of) on how to calculate maximum capacity one can get from physical disks of different sizes in Storage Spaces. Based on partial documentation and logic, I got the formula that all …
If you still leave your databases at default settings, namely default isolation (READ COMMITTED – does it suck?), you are risking three things: increased blockage and deadlocks NOLOCK hints everywhere exposing users to dirty read issues wrong results! The third …
Did you know that SUM() aggregate can be used together with OVER() clause? A short intro to windowing functions:
|
1 2 3 4 |
SELECT SUM(Amount) OVER() -- What!? FROM dbo.PersonCityAmount |
The result is graphically visualized by using only SQL Server Management Studio and unicode characters:
Have you noticed that storage is a major bottleneck in all cloud providers (Azure, AWS, Google Cloud)? Machine throughput (total MB/s) for storage is severely limited. Even on very expensive server VMs they give you not much more than about …
Introduction If you are in search for a good ORM, keep reading. Alan Hyneman, the author of SQLPlus.net was very kind to give an interview and answer tough questions that a developer might ask. Feel free to ask more in …
When multiple sessions insert into the same table, and something unique is there (uq index, uq constraint), a “duplicate key” error (2601, 2627) occurs from time to time, almost inevitable. If your app is affected with intermittent “duplicate key” surprises, …
