June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts
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

SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts
We got tremendous response to video of Error and Reaction of SQL in Sixty Seconds #002. We all have idea how SQL Server reacts when it encounters T-SQL Error. Today Rick explains the same in quick seconds. After watching this I felt confident to answer talk about SQL Server’s reaction to…
Read More

SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts
We got tremendous response to our very first video of SQL in Sixty Seconds #001 and SQL in Sixty Seconds #002. We talked about how to convert Subquery to CTE and Error and Reaction. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we…
Read More

SQL SERVER – What is Big Data – An Explanation in Simple Words

Pinal Dave
Big Data
Data Warehousing, Database

Let us start with a very interesting quote for Big Data.

Decoding the human genome originally took 10 years to process; now it can be achieved in one week – The Economist.

This blog post is written in response to the T-SQL Tuesday post of The Big Data. This is a very interesting subject. Data is growing every single day. I remember my first computer which had 1 GB of the Hard Drive. I had told my dad that I will never need any more hard drive, we are good for next 10 years. I bought much larger Harddrive over 2 years and today I have a NAS at home, which can hold 2 TB and have few file hosting in the cloud as well. Well the point is, the amount of the data any individual deals with has increased significantly.

Read More