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

SQL SERVER – Why my Database is in Restoring Mode After Taking Backup?

November 1, 2014

Once upon a time there was a SharePoint consultant named Pepper. She wanted to learn about SQL Server Administration/DBA work. While she was a master SharePoint consultant at her office in Bethel she grew curious to learn SQL Server. She wanted to be independent when dealing with SQL server chores…

SQL Authority News – 8th Year Anniversary – Thank You!

November 1, 2014

Pinal Dave

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

Today is very special day in my life. Exactly 8 years ago today, I had started writing this blog. When I started writing a blog post, I really had no idea what exactly I am starting and where exactly I was going to end. Today, after 8 years, I am…

SQL SERVER – Answer to Puzzle – ISNUMERIC and Unexpected Results

October 31, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier I blogged about Puzzle – ISNUMERIC and Unexpected Results – SQL in Sixty Seconds #076 and it is one of the most popular blog posts. Lots of people answered the question correctly. In the blog post I had a video puzzle. You can watch the video over here. [youtube=http://www.youtube.com/watch?v=nGH1bv-qmBI]…

SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052

October 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 52th episode of Notes from the Field series. I am very happy that the journey which we started one year ago is a amazing milestone. In this 52 episode in the entire year we have learned a lot of new things from industry experts…

SQL Authority News – Embarcadero DB PowerStudio Promotion & Savings

October 27, 2014

Pinal Dave

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

If you are regular readers of this blog, you may be aware of that I use many different tools in my daily routine. One of them is DB PowerStudio for Embarcadero. The team has recently announced special saving for up to 51% when you buy the DB PowerStudio bundle. With…

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

October 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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).…