ViewTube

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 ...

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 ...

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

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 ...

Today's Topic: "The imported project Microsoft.Data.Tools.Schema.SqlTasks.targets was not found" since Visual S... Thanks for ...

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

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

How do I drop an extended property with the wrong collation? I hope you found a solution that worked for you :) The Content is ...

How to make an exe file to connect SQL Server and export excel file by using pyinstaller? Helpful? Please use the *Thanks* ...

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

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

ARX Data Anonymization Tool - SQL Server connection and anonymization Helpful? Please use the *Thanks* button above!

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

This session dives into Data Migration Accelerator tools and approaches—with and without AI—to deliver projects faster with ...

Today's Topic: Docker container app cannot connect to SQL Server in Docker host Thanks for taking the time to learn more.

Do you really need the partitioned column as the first column in the index in SQL Server? Helpful? Please use the *Thanks* button ...

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

SQL Server: how to construct a IF like system within "where" clause? Helpful? Please use the *Thanks* button above! Or, thank ...