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

SQL Contest – Hint for Identify the Database Celebrity

September 23, 2013

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Earlier week I have posted a SQL Contest about Identifing the Database Celebrity over here Identify the Database Celebrity – Win USD 100 Amazon Gift Card. We have got fantastic response to the blog post however, there are quite many readers have requested Hint to the contest. In the world…

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2

September 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?. Right after the blog post was published I received an email from SQL Server users who have no access to CTE and wanted me to help him out…

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?

September 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

The first email I read this morning had only one statement in it, and it gave me an idea to write this blog post. “How to access Previous Row Value and Next Row Value in SELECT statement?” Very interesting question indeed. The matter of the fact, I have written about this…

SQL Contest – Identify the Database Celebrity – Win USD 100 Amazon Gift Card

September 19, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

NuoDB

Regular readers of this blog are familiar with NuoDB and their generous offers for SQLAuthority.com readers. I was just talking to them earlier and together we have come up with a very interesting contest for all of us. This contest has two parts. Part 1 Identify Database Personality and in Part…

SQL SERVER – Detecting Potential Bottlenecks with the help of Profiler

September 17, 2013

Pinal Dave

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

Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation. At the first sight syntax of the INSERT statement may seem very trivial , especially when inserting one record – INSERT INTO ……

SQL SERVER – Execute Operating System Commands in sqlcmd

September 16, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

sqlcmd

Here is the email received just the other day – “Hi Pinal, I have been using sqlcmd for a long time and I find it very comfortable. I am going to soon learn Powershell as well. However, here is one typical problem I face it every day and I want to check…

Personal Technology – Who is Accessing your Google Account?

September 15, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Google, Personal Technology

Do you know who is accessing your Google Account? Well, I did not know till yesterday. However, when I learn what apps are accessing my Google Accounts and particularly Gmail, I was really really scared. I receive lots of emails and just like all of us, some are private and…