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

SQLAuthority News – Presented on Database Worst Practices at SQL Live, Orlando – November 29, 2014

December 26, 2014

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

Earlier last month, I had the opportunity to present at SQL Live 2014. The event was held in Orlando in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 21, 2014. Here is the title and abstract of the session, which…

SQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059

December 25, 2014

Pinal Dave

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

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 59th episode of Notes from the Field series. I get over 100 emails everyday and out of 100 emails nearly 90 of them are really related to performance tuning. The emails I get is from various different IT professionals. There are quite a few application developers…

SQL SERVER – Puzzle – Why Decimal is Rounded Up?

December 24, 2014

Pinal Dave

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

SQL Scripts

Lots of people know the answer to this puzzle, but I am sure there are many who do not know the answer of the same as well. Here is the puzzle again for those who have vacation for the Holidays! Here is the first script: -- Decimal is rounded up…

SQL SERVER – List the Name of the Months Between Date Ranges – Part 2

December 22, 2014

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Scripts, SQL Server

Last week I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? In the original blog post, I made a small error, hence I corrected that in the follow up blog post. Thanks to Sanjay Monpara for helping me correct the error. There are some amazing comments received in the original blog posts.

SQL SERVER – List the Name of the Months Between Date Ranges – Correction

December 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function

Earlier I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? When I wrote the blog post, there was a small…

SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014

December 20, 2014

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 5, 2014. Here is the title and abstract of the session,…

SQL SERVER – Reverse String Word By Word – Part 4

December 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara and Yuri Petrov contributed to the blog post with their excellent script which I have blogged earlier. In this blog post we will see a similar script by SQL Expert Paul G. He has essentially sliced…