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

SQL SERVER – Database Stuck in Restoring State

October 24, 2014

Here is a one of the very common question I keep on getting via email. “I just restored all the backup files of my database, however, my database is still stuck in restoring state. How do I fix it?” Well, if you have already restored all the database, you can…

SQL SERVER – The Why of BIML – Notes from the Field #051

October 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it. If you have been reading this blog, when it is…

SQL SERVER – Search Records with Single Quotes – SQL in Sixty Seconds #075

October 22, 2014

Pinal Dave

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

SQL Server Management Studio

Earlier I wrote two blog posts about Search Records with Single Quotes in two parts. Refer the blog posts over here. Search Records with Single Quotes Search Records with Single Quotes – Part 2 Though I had clarified that all the methods displayed in these two blog posts have the exact same…

SQL SERVER – Search Records with Single Quotes – Part 2

October 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Yesterday I wrote a blog post about and it has created quite a lot of interest in the community SQL SERVER – Search Records with Single Quotes. Here are a few other alternatives which I received as a comment. The question was how to search records with single quotes in…

SQL SERVER – Search Records with Single Quotes

October 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. How do I search records with single quotes in it? Here is the answer to find records with single quotes in…

SQL SERVER – Combined Multiple .SQL files into One Single File

October 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Batch

Here is an interesting problem which I enjoyed solving yesterday. There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zip it to send it via email. My friend who was…

EXCEL / SQL SERVER – Extract the Domain from an Email Address

October 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Just like any business person, I work with Excel pretty much half of my time when I am not working with SQL Server. Recently I faced challenges when I wanted to extract domain from the email address. I was using excel. I was in extreme rush so I did something…