September « 2010 « SQL Server Journey with SQL Authority

Archive for September, 2010

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL View, T SQL, Technology on September 21, 2010 | 8 Comments »

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 the following case, you see [...]

Read Full Post »

SQL SERVER – How to Stop Growing Log File Too Big

Posted in SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 20, 2010 | 15 Comments »

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 anymore because there’s really no [...]

Read Full Post »

SQL SERVER – SSRS 2008 R2 – MapGallery and Codeplex – World Map

Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology, tagged SQL Spatial on September 19, 2010 | 2 Comments »

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 common request from developers around the [...]

Read Full Post »

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

Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged PowerPivot on September 18, 2010 | 2 Comments »

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 find the product extremely stable and [...]

Read Full Post »

SQLAuthority News – How to Subscribe to this Blog?

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 17, 2010 | 5 Comments »

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 see in how many different [...]

Read Full Post »

« Newer Posts - Older Posts »