May 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts
Have you ever needed WAIT or DELAY function in SQL Server?  Well, I personally have never needed it but I see lots of people asking for the same. It seems the need of the function is when developers are working with asynchronous applications or programs. When they are working with…
Read More

SQL SERVER – Maximize Database Performance with DB Optimizer – SQL in Sixty Seconds #054

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts
Performance tuning is an interesting concept and everybody evaluates it differently. Every developer and DBA have different opinion about how one can do performance tuning. I personally believe performance tuning is a three step process Understanding the Query Identifying the Bottleneck Implementing the Fix While, we are working with large…
Read More

SQL SERVER – NuoDB in Sixty Seconds – SQL in Sixty Seconds #053

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts
Earlier this week, I have done five part blog series on NuoDB and it was very well received by audience. NuoDB is an elastically scalable SQL database that can run on local host, datacenter and cloud-based resources. t is an operational NewSQL database built on a patented emergent architecture with full support for SQL and ACID…
Read More

SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts
Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…
Read More

SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts
This is the 51th episode of SQL in Sixty Seconds Video and we will see in this episode how to RESEED identity of the table column. Identity column is every increasing (or decreasing) value based on the interval specified in its property. In today’s SQL in Sixty Seconds video we…
Read More

SQL SERVER – Identity Fields Review – The SQL Query Techniques Tutorial for SQL Server 2012

Pinal Dave
SQL Tips and Tricks
Joes 2 Pros, SQL Identity, SQL Scripts, SQL Server

In this blog post we are going to learn about Identity Fields Review.

Why buy this Book: The beta of this book actually existed for a year and was tested and used in my classroom. Its purpose back then was to help the students do the steps individually that led to the skills where they could all pass the Microsoft test. It worked and then many went out for their SQL interview. They did good enough to get the job, but they told me about one or two questions they were not able to answer. A year of collecting this data and turning them into lessons doubled the size of this book of 300 pages to 600 pages. This book is designed to make the query question and query skills in the professional work must seem easier. Let us learn about Identity Fields Review.

Read More