SQL Video Archives - Page 33 of 36 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer

April 24, 2012

SQL, SQL Server, SQL Tips and Tricks, SQL Video

This blog post is inspired from SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 2. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] What is a Common Table Expression (CTE) A CTE can be thought of as a temporary result…

SQLAuthority News – Select the Best SQL in Sixty Seconds Episode – Help us Improve

April 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database

It has been more than 3 months since we have started experimenting with a new concept in SQL in Sixty Seconds. Every Wednesday, we putt a fresh new interesting concept out via video. Rick Morelan, Vinod Kumar and myself – the three of us decided to do something new and something exciting. We decided to…

SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video

April 11, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts

SQL Server has so many enhancements and features that quite often I feel like playing with various features and try out new things. I often come across situation where I want to try something new but I do not have sample data to experiment with. Also just like any sane developer I…

SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video

April 4, 2012

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL Index

Storing data non-contiguously on disk is known as fragmentation. Before learning to eliminate fragmentation, you should have a clear understanding of the types of fragmentation. When records are stored non-contiguously inside the page, then it is called internal fragmentation. When on disk, the physical storage of pages and extents is not contiguous. We…

SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video

March 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts

There were plenty of request for Vinod Kumar to come back with SQL in Sixty Seconds with T-SQL constructs after his very first well received construct video T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video. Vinod finally comes up with this new episode where he…

SQL SERVER – Transcript of Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave

March 24, 2012

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL Index

Recently I just wrote a blog post on about Learning SQL Server Performance: Indexing Basics and I received lots of request that if we can share some insight into the course. Here is 200 seconds interview of Vinod Kumar I took right after completing the course. We have few free codes to…

SQL SERVER – Using MAXDOP 1 for Single Processor Query – SQL in Sixty Seconds #008 – Video

March 23, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts

Today’s SQL in Sixty Seconds video is inspired from my presentation at TechEd India 2012 on Speed up! – Parallel Processes and Unparalleled Performance. There are always special cases when it is about SQL Server. There are always few queries which gives optimal performance when they are executed on single…