SQL Performance Archives - Page 64 of 100 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010

October 19, 2010

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

MVP, SQL Training, SQLAuthority Author Visit

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we…

SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology

October 13, 2010

Pinal Dave

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

Best Practices, Database, SQLAuthority Author Visit

Everyone always dream of visiting their school and college, where they have had studied once. It is a great feeling to see the college once again – where you have spent the wonderful golden years of your time. College time is filled with studies, education, emotions and several plans to…

SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution

October 6, 2010

Pinal Dave

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

Best Practices, Database, SQL Scripts

As the title suggests, this is quite a dirty solution; it’s not as elegant as you expect. The Story: I got a phone call at night (11 PM) from one of my old friends, requesting a hand. He asked me if I could help him with a very strange situation.…

SQLAuthority News – SQL Server Seminar at Colombo Full – Hyderabad Few Seats Available

October 2, 2010

Pinal Dave

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

If you are familiar with my blog, you might be aware of that I am doing world-wide seminar on SQL Server Seminars. I have lots of request to do the event in various cities, now our plan is very simple and to do this in very few cities. Our current…

SQLAuthority News – SQL Health Check and SQL Seminars

September 28, 2010

Pinal Dave

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

After announcing the SQL Seminar series and SQL Health Check series, there has been a great response from them. I already have signed up assignments until December 2010 Mid Week for doing various health checks for different organizations. One thing that I noticed is that there’s something common and popular…

SQL SERVER – Disabled Index and Index Levels and B-Tree

September 14, 2010

Pinal Dave

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

SQL Index, SQL Scripts

This blog post is written in response to T-SQL Tuesday hosted by Michael J. Swart. Recently, I presented a session at the Microsoft Bangalore office. Everybody eagerly wanted to learn more, to the extent that they wanted a mentor to train each of them in order to move on to…

SQL SERVER – Soft Delete Conversation – Your Opinion Needed

September 12, 2010

Pinal Dave

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

Best Practices

Last Week I wrote article about SQL SERVER – Soft Delete – IsDelete Column – Your Opinion and this article has got excellent community response. There have been some very interesting feedback on both the side. There are few opinions where expert have explained the conversation very balanced way. I…