SQL Scripts Archives - Page 217 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Detect Virtual Log Files (VLF) in LDF

December 30, 2010

In one of the recent training engagements, I was asked if it true that there are multiple small log files in the large log file (LDF). I found this question very interesting as the answer is yes. Multiple small Virtual Log Files commonly known as VLFs together make an LDF file.…

SQL SERVER – Plan Cache and Data Cache in Memory

December 28, 2010

Pinal Dave

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

SQL Memory, SQL Scripts

I get following question almost all the time when I go for consultations or training. I often end up providing the scripts to my clients and attendees. Instead of writing new blog post, today in this single blog post, I am going to cover both the script and going to…

SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber

December 27, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I strongly favor ORDER BY ColumnName. I read one of the blog post where blogger compared the performance of the two SELECT statement and come to conclusion that ColumnNumber has no harm to use it. Let us understand the point made by first that there is no performance difference. Run…

SQL SERVER – Server Side Paging in SQL Server Denali – Part2

December 26, 2010

Pinal Dave

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

SQL Paging, SQL Scripts

The best part of the having blog is that SQL Community helps to keep it running with new ideas. Earlier I wrote about SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative. A very popular article on that subject. I had used variables for “number…

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 – Securing TRUNCATE Permissions in SQL Server

December 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts, SQL Server Security

Download the Script of this article from here. On December 11, 2010, Vinod Kumar, a Databases & BI technology evangelist from Microsoft Corporation, graced Ahmedabad by spending some time with the Community during the Community Tech Days (CTD) event. As he was running through a few demos, Vinod asked the…