SQL Performance Archives - Page 58 of 101 - SQL Authority with Pinal Dave

SQLAuthority News – I am Speaking at SQL Saturday 116 – Bangalore, India on January 7, 2012 – First SQL Saturday in India

January 5, 2012

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

Best Practices, Database, SQL Saturday, SQLAuthority Author Visit

SQLSaturday 116 is now only 3 days away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. This is very first SQL Saturday in India and I am very much excited that I will be speaking at this event on my favorite subject of SQL Server…

SQLAuthority News – Online Session Practical Tricks and Tips to Speed up Database Queries Today

December 15, 2011

Pinal Dave

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

I am presenting on performance tuning topic again today at Virtual Tech Days. This time I am going to talk about lots of practical tips and will focus on what we can do immediately right after the session is over. During the session I have two things for you to…

SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

December 13, 2011

Pinal Dave

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

SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of Tips and Tricks. For me, this is a very interesting subject. I perfectly enjoy a discussion when it is about performance tuning. I commonly get follow-up questions regarding this subject, but most of them do not give…

SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011

December 12, 2011

Pinal Dave

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

Performance tuning has been my favorite subject and any time when I have to present on this subject, this itself gives me tremendous pleasure as well. I am always excited to present something new on this topic. Virtual Tech Days is just here around the corner and I am going…

SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners

November 28, 2011

Pinal Dave

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

SafePeak, the unique automated SQL performance acceleration and performance tuning software vendor, announced the winners of their SQL Performance Contest 2011. The contest quite unique: the writer of the best / most interesting and most community liked “performance story” would win an expensive gadget. The judges were the community DBAs…

SQL SERVER – Video – Performance Improvement in Columnstore Index

November 7, 2011

Pinal Dave

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

SQL Index, SQL Scripts

I earlier wrote an article about SQL SERVER – Fundamentals of Columnstore Index and it got very well accepted in community. However, one of the suggestion I keep on receiving for that article is that many of the reader wanted to see columnstore index in the action but they were…

SQL SERVER – How to Ignore Columnstore Index Usage in Query

October 30, 2011

Pinal Dave

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

SQL Index

Earlier I wrote about SQL SERVER – Fundamentals of Columnstore Index and very first question I received in email was as following. “We are using SQL Server 2012 CTP3 and so far so good. In our data warehouse solution we have created 1 non-clustered columnstore index on our large fact table.…