All Articles - SQL Authority with Pinal Dave

SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9

September 26, 2010

SQL Index, SQL Joins, SQL Scripts, 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… Previously, I wrote an article about SQL SERVER – The Self Join – Inner Join and Outer Join, and that blog post seems very…

SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only

September 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Stored Procedure, SQL String

I have earlier wrote article about SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only and it was very handy tool for me. Recently blog reader and SQL Expert Christofer has left excellent improvement to this logic. Here is his contribution. He…

SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8

September 24, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts, 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… This blog post was previously published over here. I am republishing it in the series Limitation of the Views with a few modifications. While…

SQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7

September 23, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, 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… One of the requirements of Indexed View is that it has to be created ‘WITH SCHEMABINDING’. If the View is not created with that…

SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6

September 22, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Union clause, 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… If you want to create an Indexed View, you ought to know that UNION Operation is not allowed in Indexed View. It is quite surprising…

SQL SERVER – COUNT() Not Allowed but COUNT_BIG() Allowed – Limitation of the View 5

September 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, 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… One of the most prominent limitations of the View it is that it does not support COUNT(*); however, it can support COUNT_BIG(*) operator. In…

SQL SERVER – How to Stop Growing Log File Too Big

September 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

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…