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

SQLAuthority News – Various Ways to Stay in Touch with SQLAuthority.com – Best Practices

September 29, 2011

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

Social Media is growing and quite commonly we reach to the point where we have confusion about the various aspects of the same. I have written a previous article on this subject SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me. I am present and active at…

SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns

September 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts

SQL Server version next Denali has lots of enhancements. Some of the enhancements are just game changing and overcomes needs of more coding to do the same thing. Similar function DMV is sys.dm_exec_query_stats. There are four new columns added to this DMV. I have often used this DMV to check…

SQLAuthority News – Tomorrow Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

September 28, 2011

Pinal Dave

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

Best Practices, Database, SQL Index

Today in few hours I am going to present on my very favorite subject of performance tuning. You can read more about this sessions over here. This presentation is based on the famous book ‘The Art of War’ written in sixth century BC by Sun Tzu. Index is usually a…

SQLAuthority News – 31 Millions Views – Free 5 Print Copy of SQL Wait Types and Queues

September 27, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros, SQL Wait Stats, SQLAuthority Book Review

Earlier this year in February, I wrote a 30-day series on Wait Types and Queue. This series was very popular and I have received a number of good and encouraging comments on various parts of the series. The no.1 request was to compile the concept in an eBook. This idea…

SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

September 26, 2011

Pinal Dave

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

Best Practices, Database, SQL Index

Performance Tuning has been my favorite subject always. I love this subject the most. I personally have enjoyed every aspect of performance tuning. Quite often I have seen that when it is about performance, people end up talking about Indexes. Index for sure can help performance, but it is like…

SQL SERVER – Denali – Startup Parameters Easy to Configure

September 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

If you are regular reader of this blog, you must be aware that I have written about SQL Server Denali recently. I just finished a writing about various functions of Denali SQL SERVER – Denali – 14 New Functions – A Quick Guide. While working with Denali, at one point,…

SQL SERVER – Denali – Download CTP3 Demo VHD Including Fully Configured Services and Integration with SharePoint 2010 and Office 2010

September 24, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

During my office hours observed, a very common question is”What is Denali?” once I answer that Denali is the next version of the SQL Server, the follow up question is where can I download it. I have explained the installation and download part over here: SQL SERVER – Denali CTP3…