SQL Server Archives - Page 75 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Q and A from Facebook Page

March 30, 2014

Social media has changed everything, there were times when we used to send emails but nowadays things have changed. We all have many different ways to connect with each other. Here are a few questions which I have received on the Facebook Page in the month of the march and…

SQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases

March 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

SQL Server 2014 RTM is around the corner (2014). There is plenty of the interest in the SQL Server 2014 in recent time. One of the most frequently asked questions is about learning resources of SQL Server 2014. Everybody wants to learn SQL Server 2014 but there is not enough…

SQLAuthority News – Sign up for SQL Authority Low Frequency Newsletter

March 27, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

One More Newsletter! You might already be receiving our emails in your mailbox, so why should you sign up for SQL Authority Newsletter (Sign-up). Well, a great question. Let me answer this first. Why should you sign up? First of all – it is not going to be a daily…

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

March 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

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

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…