ViewTube

The CE's job is to use statistics to determine how many rows will come back for any given operation in a query plan. SQL Server's ...

New Cardinality Estimation Logic in SQL Server 2014 improves performance of queries. In this quick demonstration to see how ...

Looking for deep-dive content on SQL Server Performance Tuning? Get lifetime access to master class recordings. Check this: ...

Want access to all our free webinars? Become a free member at SQLMaestros.com and access all the free webinars.

SQL Server Performance Tuning Master Class is happening again. Learn more. https://bit.ly/SQLMaestrosClasses Want Amit ...

A cardinality estimate is the estimated number of rows, the optimizer believes will be returned by a specific operation in the ...

Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One ...

Kate Smith - Senior PM, Microsoft SQL Server - Goes into details about Intelligent Query Processor in SQL SQL Server 22 ...

Animation tools: Adobe Illustrator and After Effects ABOUT US: Covering topics in database systems.

When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use ...

ISNUMERIC is SQL Server Function which returns 1 or 0 based on the results passed into the function. In this example, it gives ...

SQL Server Statistics and the New Cardinality Estimator Part 1.

You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and ...

Watch the full HD course: http://pluralsight.com/training/courses/TableOfContents?courseName=sqlserver-tqpq When creating an ...

A quick tutorial to generate reports for schema changed in recent time with the help of SQL Server Management Studio. Click here ...

Episode 5 of my videos for my undergraduate Real Analysis course at Fairfield University. This is a recording of a live class.

COUNT(*) and COUNT(1): Performance Battle Let us learn which one is faster. Must Watch: ...

In this video, I delve into how indexes store and sort data in SQL Server, focusing on B-tree rowstore indexes as they are the most ...

Check out SQL Server Management Studio 2016's Live Query Stats feature in action.