SQL Server Archives - Page 213 of 393 - SQL Authority with Pinal Dave

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

December 26, 2010

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

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…

SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

December 24, 2010

Pinal Dave

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

SQL Documentation, SQL Download, SQL Service Pack

If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL…

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 – Public Training and Private Training – Differences and Similarities – Public Training vs Private Training

December 22, 2010

Pinal Dave

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

SQL Training

Earlier this year, I was on Road SQL Server Seminars. I did many SQL Server Performance Trainings and SQL Server Performance Consultations throughout the year but I feel the most rewarding exercise is always the one when instructor learns something from students, too. I was just talking to my wife, Nupur –…

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…