SQL Server Archives - Page 224 of 393 - SQL Authority with Pinal Dave

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

September 23, 2010

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 – 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…

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 – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7

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

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

SQL SERVER – How to Stop Growing Log File Too Big

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

SQLAuthority News – How to Subscribe to this Blog?

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

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