SQL Tips and Tricks Archives - Page 166 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Live Plan for Executing Query – SQL in Sixty Seconds #073

September 3, 2014

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

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced live plans. For query before you execute it, you can see the estimated execution plan and after you executed you can see the actual execution plan – however, how to…

SQL SERVER – Live Plans for Long Running Queries

September 2, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…