ViewTube

Why does my index not help and what would help? I hope you found a solution that worked for you :) The Content is licensed ...

is it possible to bifurcate a SQL Server database on specific drives? Hey guys! Hopefully you found a solution that helped you!

Rowgoals are great. Most of the time. But what if they are not? In this video, we look at a scenario where a rowgoal backfires in a ...

Today's Topic: Does it make sense to index a table with just one column? Thanks for taking the time to learn more. In this video I'll ...

It is quite obvious that a TOP clause introduces a rowgoal in the execution plan. But there are other cases that use the same ...

Text is annoying so in Postgress text is text in Oracle it's called clob character large object in Microsoft SQL server it's known as ...

Strange result return from sql server Helpful? Please use the *Thanks* button above! Or, thank me via Patreon: ...

SQL Server - Is there a way to prevent shared range locks to 'infinity' when using an indexed view? Hey guys! Hopefully you found ...

Today's Topic: SQL Server: how do I kill a -3 SPID? Thanks for taking the time to learn more. In this video I'll go through your ...

How do I maintain a specific cadence in a bi-weekly SQL Agent job schedule? Hey guys! Hopefully you found a solution that ...

Today's Topic: How to have the semicolon character in a password for a SQL connection string? Thanks for taking the time to ...

db_id() - can the database id change? Hey guys! Hopefully you found a solution that helped you! The Content is licensed under ...

How to use the result from a procedure in another procedure in SqlServer? Helpful? Please use the *Thanks* button above!

SQL Server 2025 comes with "Optimized Locking". A set of two features intended to alleviate the pain of locking. With Transaction ...

How to use sp_rename for an index with a target name that is the same in multiple tables Hey guys! Hopefully you found a ...

Today's Topic: SQL query to show data by today(current) date? Thanks for taking the time to learn more. In this video I'll go ...

Today's Topic: Powershell restore SQL Server database to new database Thanks for taking the time to learn more. In this video I'll ...

Today's Topic: SQL Server: how to use alias in update statement? Thanks for taking the time to learn more. In this video I'll go ...

How to overwrite empty column values in a GROUP BY with SQL Server? Helpful? Please use the *Thanks* button above!

Today's Topic: How can I create custom dynamic data mask function in SQL Server? Thanks for taking the time to learn more.