SQL View Archives - Page 2 of 5 - SQL Authority with Pinal Dave

SQL SERVER – CTE can be Updated

May 19, 2014

Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused. Here is his…

SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer

September 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL View

Earlier this week, I was surfing various SQL forums to see what kind of help developer need in the SQL Server world. One of the question indeed caught my attention. I am here regenerating complete question as well scenario to illustrate the point in a precise manner. Additionally, I have…

SQL SERVER – Get File Statistics Using fn_virtualfilestats

January 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics, SQL View

Quite often when I am staring at my SSMS I wonder what is going on under the hood in my SQL Server. I often want to know which database is very busy and which database is bit slow because of IO issue. Sometime, I think at the file level as…

SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2

December 23, 2010

Pinal Dave

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

SQL Scripts, SQL View

Earlier, I have written an article about SQL SERVER – Index Created on View not Used Often – Observation of the View. I received an email from one of the readers, asking if there would no problems when we create the Index on the base table. Well, we need to…

SQL SERVER – Index Created on View not Used Often – Observation of the View

December 21, 2010

Pinal Dave

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

SQL Scripts, SQL View

I always enjoy writing about concepts on Views. Views are frequently used concepts, and so it’s not surprising that I have seen so many misconceptions about this subject. To clear such misconceptions, I have previously written the article SQL SERVER – The Limitations of the Views – Eleven and more….…

SQL SERVER – Index Created on View not Used Often – Limitation of the View 12

December 18, 2010

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server, SQL Training, SQL View

I have previously written on the subject SQL SERVER – The Limitations of the Views – Eleven and more…. This was indeed a very popular series and I had received lots of feedback on that topic. Today we are going to discuss something very interesting as well. Let us learn about the issue of index created on view on used often.

SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz

November 6, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL View

My very good friend, Jacob Sebastian, is running a month-long SQL Quiz Series where the best-of-the-best experts from around the globe would be the quiz masters. They will ask one question every day, and users are expected to answer them correctly. The winning prizes include cool gadgets like iPAD, Kindle…