SQL Tips and Tricks Archives - Page 337 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Resolution for New Year 2011

January 1, 2011

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

Today is the first day of the year so I want to write something very light. Last Year: 2010 Last Year was a blast; really traveled a lot. My family and I went on vacation. There I enjoyed being father, rolling on the floor and playing with my daughter. Here…

SQLAuthority News – Community Service and Public Speaking Engagements

December 31, 2010

Pinal Dave

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

SQLAuthority Book Review

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…