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

SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance

February 28, 2010

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

I recently presented in Hyderabad User Group on the subject of The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem , you can read more about this event here SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review. I really had…

SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT

February 27, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts

During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees suggested that I should also write about this script on my blog. Let me share this…

SQLAuthority News – Keeping Your Ducks in a Row

February 26, 2010

Pinal Dave

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

Last year during my visit to SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2 I have received ducks from the event. Well during the same event I had learned from Jonathan Kehayias the saying of ‘Keeping Your Ducks in a Row‘. The most popular theory suggests that…

SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review

February 25, 2010

Pinal Dave

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

MVP, SQL Index, SQL Training, SQL User Group, SQLAuthority Author Visit

Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as well her husband during my visit to Hyderabad. I had presented session on Index, which…

Data Mining Algorithms (Analysis Services – Data Mining)

February 23, 2010

Pinal Dave

SQL

Business Intelligence, Data Warehousing, SQL Documentation, SQL Server

I quite often receive requests for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.

SQLAuthority News – Blog Subscription and Comments RSS

February 22, 2010

Pinal Dave

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

Quite often I get email where many readers ask me how to get email from SQLAuthority.com blog. Today very quickly I will go over few standard practices of this blog using you can stay connected with SQLAuthority.com First the most important is search: I received hundreds of emails and hundreds…

SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

February 21, 2010

Pinal Dave

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

Best Practices, SQL Scripts

Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click…