SQL Archives - Page 329 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Community Service and Public Speaking Engagements

December 31, 2010

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

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…

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

December 30, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, VLF

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.…

SQLAuthority News – My Evaluation of Singapore SharePoint Conference

December 29, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SharePoint, SQLAuthority Author Visit

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…

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…

SQLAuthority News – 18 Seconds of Fame – My PASS Experience

December 25, 2010

Pinal Dave

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

SQLAuthority Author Visit

Happy Holidays to All of YOU! Life is full of little and happy surprises. I think Christmas and Santa are based on it. I just received very interesting email earlier today, I had no idea about it. Earlier this year, I had visited Seattle to attend SQLPASS – read the…