All Articles - SQL Authority with Pinal Dave

SQL SERVER – How to Stop Growing Log File Too Big

September 20, 2010

I was recently engaged in Performance Tuning Engagement in Singapore. The organization had a huge database and had more than a million transactions every hour. During the assignment, I noticed that they were truncating the transactions log. This really alarmed me so I informed them this should not be continued…

SQL SERVER – SSRS 2008 R2 – MapGallery – World Map

September 19, 2010

Pinal Dave

SQLAuthority News

SQL Documentation, SQL Download, SQL Spatial

SQL Server 2008 R2 has negatively integrated ability to work with maps. There are few ways how one can select map and use them in their projects. The one I recently came across was MapGallery. By default SQL Server 2008 R2 is enabled for USA maps. This is quite a common request from developers around the globe that they want the same feature available in their own country.

SQL SERVER – 2008 R2 – PowerPivot for Microsoft Excel 2010 – RTM

September 18, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

PowerPivot, SQL Documentation, SQL Download

PowerPivot Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010. I have recently started to work with SQL Server 2008 R2 and…

SQLAuthority News – How to Subscribe to this Blog?

September 17, 2010

Pinal Dave

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

Best Practices

How do I subscribe to this blog? I have received this question quite a few times, and have answered them accordingly. As we all know, blogs are part of a social network, and the whole social networking thing is very interesting as everything in it is interwoven together. Let us…

SQLAuthority News – What is an MVP? – How to become an MVP?

September 16, 2010

Pinal Dave

SQLAuthority News

MVP

There are a lot of basic questions I get that inquires about being an MVP.

SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4

September 15, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL View

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more…

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 – What are Wait Types, Wait Stats and its Importance

September 13, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier last month Solid Quality India announced SQL Server Health Check Service and since then, it has got very good response from the industry. However, the only question we are be asked all the time is: “What is “SQL Server Resource Wait Stats Analysis” and how can it be useful?”What…

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…

SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper

September 11, 2010

Pinal Dave

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

Best Practices, SQL Documentation, SQL Download

I had previously written article on SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial. Microsoft has come up with white paper regarding same Best Practice Analyzer. In the new R2 version the SQL BPA introduces advanced capabilities in conjunction with the PowerShell architecture and also raises the…