SQL Tips and Tricks Archives - Page 349 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download

September 30, 2010

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

SQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts

September 30, 2010

Pinal Dave

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

SQL Scripts, SQL View

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…

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

September 29, 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… 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…

SQLAuthority News – SQL Health Check and SQL Seminars

September 28, 2010

Pinal Dave

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

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…

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

September 26, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…