SQL SERVER – Recently Executed T-SQL Query

10/16/2009

About a year ago, I wrote blog post about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER.

The Short Answer in is both of them will be deprecated Please refer to following update query to [...]

Full story: Journey to SQL Authority with Pinal Dave

Similar articles

Journey to SQL Authority with Pinal Dave

SQL SERVER – Parallelism Query in Database I recently came across two interesting questions asked by Feodor over here. He has asked very interesting questions. Please check them as follows: If I have a dual core computer and I would like to ge...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Comic Slow Query – SQL Joke Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detail report of th...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Download Logical Query Processing Poster Earlier this year, I had written article on SQL SERVER – Logical Query Processing Phases – Order of Statement Execution and I had asked one question to readers. I got very good response for this quest...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Get Query Plan Along with Query Text and Execution Count Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following handy script, which I use when I need to know the de...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Get Query Running in Session I was recently looking for syntax where I needed a query running in any particular session. I always remembered the syntax and ha d actually written it down before, but somehow it was not coming to mi...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Identifying Statistics Used by Query “Can I know which statistics were used by my query?” I was recently asked this question in my recent training of the class of query optimization and performance tuning. I really like the q...

Comments on this article

Add your comment

Report

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Developer Training – Importance and Significance – Part 1 Developer Training – Importance and Significance – Part 1 Developer Training – Developer Training Morals and E...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Before continuing this blog post – please read the two part of the SEQUENCE Puzzle here A Puzzle – Fun with SEQUENCE in SQ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Before continuing this blog post – please read the first part of the SEQUENCE Puzzle here A Puzzle – Fun with SEQUENCE in ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Yesterday my friend Vinod Kumar wrote excellent blog post on SQL Server 2012: Using SEQUENCE. I personally enjoyed reading the c...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117 During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use th...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Renaming Index – Index Naming Conventions If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn rece...

Journey to SQL Authority with Pinal Dave

SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to sh...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at ...

SQL SERVER – Recently Executed T-SQL Query

Similar articles

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Comments on this article

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Sign In