All Articles - SQL Authority with Pinal Dave

SQL SERVER – Live Plans for Long Running Queries

September 2, 2014

If you are a SQL Server DBA or developer who is majorly dealing with queries which are running for a long time, you may have one request every time you see a long running query. The request is how to see a plan for a query when it is still…

SQL SERVER – How to Know Cardinality of Executed Query?

September 1, 2014

Pinal Dave

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

Earlier I wrote three blog posts on SQL Server 2014 Cardinality. Read them over here to get the context of this blog post. SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014 SQL…

SQL Authority News – 3000th Blog Posts and Thank You

August 31, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Milestone

3000th Blog Posts! When I realized that I am writing my 3000th blog post (list of all of my blog posts), I just got blank with happiness. I could not come up with what exactly to write. It has been a long time since I have stopped writing about milestones.…

SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS

August 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL Shortcut

I just formatted my computer and installed fresh SQL Server 2014. The very first thing which I did was to open SQL Server Management Studio and execute a sample query. As soon as I executed the query, it returned me some result. Once I did not need the result, my…

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

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity

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