SQL Archives - Page 179 of 519 - SQL Authority with Pinal Dave

SQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021

March 26, 2014

[Notes from Pinal]: Lots of people think that SSIS is all about arranging various operations together in one logical flow. Well, the understanding is absolutely correct, but the implementation of the same is not as easy as it seems. Lots of people start with lots of enthusiasm, but when it…

MySQL – How to Connect to MySQL Server on Command Prompt

March 25, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

I have so far authored 5 courses on MySQL at Pluralsight, and one of the most popular question, I keep on getting is how to connect to MySQL with Command Prompt. You may find it funny enough that people who are learning MySQL would know how to connect to command…

SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join

March 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTE, Execution Plan, SQL Joins

I just had an interesting conversation the day before when I was discussing about Join Order in one of my recent presentations. The comment which triggered all the conversation was “If I want to change the order of how tables are joined in SQL Server, I prefer to use CTE…

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

March 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This may be surprising to many, but I have seen quite a few times so far so decided to blog over here. Here is the sequence of the action: The developer turns on Graphical Execution plan for any query with CTRL+M Now turns on the execution plan in the text…

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

March 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Professional Development, Software Development

I was just reading Dr. W. Edwards Demings 14 principles of Total Quality Management. It is indeed very impressive and interesting. I have tried to collect a few of the important resources related to the same over here. Dr. Demings’s 14 principles Create a constant purpose toward improvement Adopt the…

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

March 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

MySQL has an inbuilt function called FIND_IN_SET which will search for values within a comma separated values. It basically returns the index position of the first parameter within the second parameter. This can be alternatively used to replace the IN clause. Let us create the following tables CREATE TABLE items(item_id…

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

March 20, 2014

Pinal Dave

SQL

Notes from the Field, SQL Index, SQL Server

[Notes from Pinal]: Indexes are considered as a silver bullet for performance tuning and do amazing job when they are properly created. Just like any other engine they need maintenance and tuning. As we get more data, indexes start to get fragmented and performance starts to degrade. I asked direct questions to my friend Tim about index fragmentation and he gave me a very interesting answer.