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

SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052

May 29, 2013

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…

SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL

May 28, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

Earlier I have posted a puzzle which received so many valid responses and got a fantastic explanation to the questions as well. I encourage all of you to read the original puzzle here. First run following script: SET ANSI_NULLS ON; -- Query1 SELECT 'SQLAuthority' AS Statement11 WHERE 'Authority' IN ('S','Q',…

SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods

May 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Here is a very common question which I keep on receiving on my facebook page as well on twitter. “How do I insert the results of the stored procedure in my table?” This question has two fold answers – 1) When the table is already created and 2) When the…

Blogging Best Practices – Checklist for Building Successful Blog – Part 6

May 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Blogging

Abstract of my Pluralsight Course Building a Successful Blog Module – Checklist for Building Successful Blog. [youtube=http://www.youtube.com/watch?v=12p4j4Ht8os] I hope everyone has learned a little or a lot with me through this whole course. Even if you are already a professional blogger, my hope is that everyone could learn something. I love blogging…

SQL SERVER – Weekly Series – Memory Lane – #030

May 25, 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…

Blogging Best Practices – Frequently Asked Questions – Part 5

May 24, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Blogging

Abstract of my Pluralsight Course Building a Successful Blog Module – Frequently Asked Questions. [youtube=http://www.youtube.com/watch?v=12p4j4Ht8os] If you have been following this blog series about starting and maintaining a blog, you might be excited to go start blogging right now. But if you have a few more questions, let me get them out…

Blogging Best Practices – Blogging Rules, Ethics and Etiquette – Part 4

May 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Blogging

Abstract of my Pluralsight Course Building a Successful Blog Module – Blogging Rules, Ethics and Etiquette. [youtube=http://www.youtube.com/watch?v=12p4j4Ht8os] To have a successful blog, your posts should be interesting, you probably would like to have a large audience, and you want to provide quality content to the subject. However, to be truly successful, you…