Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2

October 26, 2014

Yesterday I wrote a blog post about SQL SERVER – How to Flip Value of Bit Field in SQL Server? . Lots of good suggestions I have received in response of the same. Here are a few different methods to flip value of a bit field suggested by my very…

SQL SERVER – How to Flip Value of Bit Field in SQL Server?

October 25, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

How do you flip bit field in SQL Server? Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. Bit field can hold two different values zero (0) and one (1).…

SQL SERVER – Database Stuck in Restoring State

October 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

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…