SQL Tips and Tricks Archives - Page 211 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course

September 3, 2013

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

Every year around September 1st, I have decided to do something cool. This is because September 1st is my daughter Shaivi’s birthday. In previous years, I have released my new books as well new courses on this day. This year I have done something similar for her. I like to…

SQL SERVER – SQL Basics Video: SQL 2012 Certification Path – SQL in Sixty Seconds #065

September 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 10th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). The new breakdown of the Microsoft SQL 2012 certification model offers new incentives…

SQL SERVER – Weekly Series – Memory Lane – #044

August 31, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane, SQL Scripts

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – SQL Basics Video: What Are Filegroups – SQL in Sixty Seconds #064

August 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 9th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). There are many advantages to using filegroups to manage the database workload. A…

SQL SERVER – SQL Basics Video: Database Datafiles and Logfiles – SQL in Sixty Seconds #063

August 29, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 8th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). We know that SQL Server stores its data much like other applications, in…

SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan

August 28, 2013

Pinal Dave

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

Update: You can download dbForge Studio for SQL Server for free trial. One of the most exciting periods of my life relates to the maintenance and optimization of ERP system for one large manufacturing company. The problem was that the system was initially created for a limited range of tasks, which over…

SQL SERVER – SQL Basics Video: Database Careers – SQL in Sixty Seconds #062

August 28, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 7th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). The live system is the one that interacts with our customers and must…