Feeds:
Posts
Comments

Archive for September, 2010

SQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download

Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 30, 2010 | 5 Comments »

Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. You can download your preferred version from link here. The major enhancements are as following: 15K partitioning Improvement. Reporting Services in SharePoint Integrated Mode. SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008. SQL Server 2008 Instance Management. [...]

Read Full Post »

SQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts

Posted in Pinal Dave, SQL, SQL Authority, SQL Milestone, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL View, SQLAuthority News, SQLServer, T SQL, Technology on September 30, 2010 | 1 Comment »

Since I started the monthly round up of the blog post, I have received many positive feedback. I plan to continue doing this month refresher every month now. This rounds ups are my mirror and informs me what I have been doing whole month. Here is quick look at the last month. The month started [...]

Read Full Post »

SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11

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 29, 2010 | 2 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… When I wrote the article about SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2, I had received a comment that said: “If joining [...]

Read Full Post »

SQLAuthority News – SQL Health Check and SQL Seminars

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Milestone, SQL Optimization, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged on September 28, 2010 | 8 Comments »

After announcing the SQL Seminar series and SQL Health Check series, there has been a great response from them. I already have signed up assignments until December 2010 Mid Week for doing various health checks for different organizations. One thing that I noticed is that there’s something common and popular in many  health check services– [...]

Read Full Post »

SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10

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 27, 2010 | 1 Comment »

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… I have recently wrote many articles on the limitation of the views. In this article, I have tried to sum up all the keywords which are not allowed in [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers