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

SQL SERVER – Reverse String Word By Word – Part 4

December 19, 2014

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…

SQL SERVER – Reverse String Word By Word – Part 3

December 17, 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 wrote a great comment to the blog post where he has proposed alternate solution. Right after the solution of the Sanjay, another expert Yuri Petrov suggested a modification to the script. In this blog…

SQL SERVER – Proving that the Source of the Problems aren’t Tied to the Database

December 16, 2014

Pinal Dave

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

Dell

I have always wondered how Sherlock Holmes cracked the toughest of mysteries every single time. This fascination always lead me to learn new techniques every single time. The backbone for every successful detective is to be logical in their approach while working on the case. While watching movies, I have…

SQL SERVER – Reverse String Word By Word – Part 2

December 15, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. Right after the solution of the Sanjay, another expert Yuri Petrov suggested a modification to the script. I have…

SQL SERVER – Can Database Primary File Have Any Other Extention Than MDF

December 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Here is interesting question I received yesterday. I personally think it is one of the most interesting questions I have received this month. “Can Database Primary File Have Any Other Extention Than MDF?” Before you read the answer – think for a moment. Now read the answer in the next…

SQL SERVER – Download RML Utilities for SQL Server

December 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Microsoft RML Utilites are very helpful when analysing performance. It helps answering questions like Do you know which databases are using the most resources on your server? Do you know which applications are using the most resources on your server? How will a service pack upgrade, configuration change or application…

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

December 9, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Here is another interesting question, I received the other day. “How to list the name of the months between two date ranges?” Very interesting question. I had no script ready for it so I asked my friend who used to my co-worker earlier and he has sent me the script…