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

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

December 14, 2014

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…

SQL SERVER -Fix Error – Cannot open backup device. Operating system error 5(Access is denied.)

December 8, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server

This has to be the most popular error in taking database backups. There are many reasons for this error and there are different ways to resolve it. I recently faced this error and for a while I was taking backup and found a very interesting solution to the problem. The error was as mentioned below:

SQL SERVER – Finding if Current Week is Odd or Even – Script

December 7, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Here is an interesting question I received from my friend who is working in Bank as a DBA. “Pinal, We have a requirement in bank that every 2nd and 4th week we keep more cash in our bank where as we can keep less cash on other weeks. I want…

SQL SERVER – Reverse String Word By Word

December 6, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Earlier I wrote a blog post where I have reversed the entire string which was passed to the function. You can read that over here User Defined Functions (UDF) to Reverse String. In that blog post I wrote a function which would reverse an entire string. However, recently I read…

SQL SERVER – FIX: Error 5161 – An Unexpected file id was Encountered

December 5, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Recently I was planning to give a demo about increasing tempdb files and its performance benefit. So while making the demo at home, I was doing multi-tasking. Talking to my daughter, having food and making demo. So, I ran the script and restarted SQL Server service but SQL Service didn’t…