SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not…
Read More

SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE

This is followed up a blog post of my earlier blog post on the same subject – Introduction to Hierarchical Query using a Recursive CTE – A Primer. In the article we discussed various basic terminology of the CTE. The article further covers following important concepts of common table expression. Let us learn in this video how to do Hierarchical Query using a Recursive CTE.
What is a Common Table Expression (CTE)
Building a Recursive CTE
Identify the Anchor and Recursive Query
Add the Anchor and Recursive query to a CTE
Add an expression to track hierarchical level
Add a self-referencing INNER JOIN statement

Read More

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

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…
Read More

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

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…
Read More

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

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…
Read More

SQL SERVER – Table Variables and Transactions – SQL in Sixty Seconds #007 – Video

Today’s SQL in Sixty Seconds video is inspired from my presentation at TechEd India 2012 on Misconception and Resolution. Quite often I have seen people getting confused with certain behavior of the T-SQL. They expect SQL to behave certain way and SQL Server behave differently. This kind of issue often…
Read More

SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video

A DBA’s role is critical, because a production environment has to run 24×7, hence maintenance, trouble shooting, and quick resolutions are the need of the hour.  The first baby step into any performance tuning exercise in SQL Server involves creating, analyzing, and maintaining indexes. Though we have learnt indexing concepts…
Read More
Menu