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

SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course

May 1, 2013

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

Here are few of the question I often receive – Do you know anything besides SQL Server? So how does it feel when the only thing which you know is SQL Server? Have you worked in the past with any other programming language? Actually, I find these questions very interesting…

SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement

April 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. In recent times I have seen a developer writing a cursor to update a table. When asked the reason was he had no idea how to…

SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database

April 29, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

Here is an email I received during the weekend. “Hi Pinal, I am a senior tester in the leading organization and we have two different environments 1) Testing 2) Production. As a part of the testing we want to insert garbage data into the database system and see how the application…

SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop

April 28, 2013

Pinal Dave

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

PowerPivot, SQL Download

Earlier this week Microsoft have released two very interesting downloads which got my attention. Haddop, PowerPivot and PowerView all three are not directly related to traditional RDBMS but their important is growing in the industry as big data is taking over market. The Microsoft SQL Server SQOOP Connector for Hadoop…

SQL SERVER – Weekly Series – Memory Lane – #026

April 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

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 – UNION ALL and UNION are Different Operation

April 26, 2013

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Union clause, Union

I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again. Let us learn about the different operations about the unions.

SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2

April 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, Union

“How do I return a few of my resultset rows at the bottom of the entire resultset?” I was previously asked this question and my response was that we can do this by using the CASE statement in the ORDER BY clause and I wrote a blog post describing the…