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

SQL Authority News – 3000th Blog Posts and Thank You

August 31, 2014

Personal, SQL, SQL Server, SQL Tips and Tricks

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…