Feeds:
Posts
Comments

Archive for December, 2010

SQLAuthority News – Community Service and Public Speaking Engagements

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, T SQL, Technology on December 31, 2010 | 3 Comments »

Today is the last day of the year and I was going over my memories for year 2010. Almost all of them are good and I feel for sure better person in terms of knowledge, nature and overall human being. Looking back at the year, it is very satisfying as I was able to go [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 30, 2010 | 14 Comments »

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. The writing of the VLF [...]

Read Full Post »

SQLAuthority News – My Evaluation of Singapore SharePoint Conference

Posted in Pinal Dave, SharePoint, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology, tagged on December 29, 2010 | 2 Comments »

Earlier this year, I presented at SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore. It was an unforgettable experience to present at Singapore SharePoint Conference as I was the only SQL Speaker at the event. The event was filled with SharePoint enthusiasts and many other experts from all [...]

Read Full Post »

SQL SERVER – Plan Cache and Data Cache in Memory

Posted in Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, tagged on December 28, 2010 | 2 Comments »

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 link to original blog posts [...]

Read Full Post »

SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 27, 2010 | 16 Comments »

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 following two scripts together: USE [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers