All Articles - SQL Authority with Pinal Dave

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2

August 29, 2014

Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as it gives immediate details about Identity Values. SQL expert Mark Hickin…

SQL SERVER – Detecting Corruption with Suspect Pages Table – Notes from the Field #043

August 28, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a new episode of Notes from the Fields series. I often hear about database corruption and I like to stay away from the problems related to corruption. When database gets corrupted, there are not enough expert out in the world who can fix it properly…

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype

August 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity

SQL SERVER – Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified

August 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

The other day I received following error when I tried to restore a database from one server to another server. Msg 7202, Level 11, State 2, Line 1 Could not find server ‘MyLinkedServer’ in sys.servers. Verify that the correct server name was specified. Well, this is quite a popular error…

SQL Authority News – Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog

August 25, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Author Visit

When I started this blog, it was meant as a bookmark for myself for helpful tips and tricks. Gradually, it grew into a blog that others were reading and commenting on. While SQL and databases are my first love and the reason I started this blog, the side effect was…

SQL SERVER – How to See Active SQL Server Connections For Database

August 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV

Another question received via email – “How do I I know which user is connected to my database with how many connection?” Here is the script which will give us answer to the question. SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame FROM sys.sysprocesses GROUP BY dbid, loginame ORDER BY DB_NAME(dbid)…

Developer’s Life – Summary of Superhero Articles

August 23, 2014

Pinal Dave

SQLAuthority News

Developer, Superhero

Earlier this year, I wrote an article series where I talked about developer’s life and compared it with Superhero. Let us explore the article.

SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation

August 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

After reading my initial two blog posts on New Cardinality Estimation, I received quite a few questions. Once I receive this question, I felt I should have clarified it earlier few things when I started to write about cardinality. Before continuing this blog, if you have not read it before…

SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042

August 21, 2014

Pinal Dave

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

Notes from the Field

[Notes from Pinal]: The biggest challenge which people face is not taking backup, but the biggest challenge is to restore a backup successfully. I have seen so many different examples where users have failed to restore their database because they made some mistake while they take backup and were not…

SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072

August 20, 2014

Pinal Dave

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

SQL Server Management Studio

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving…