All Articles - SQL Authority with Pinal Dave

SQL SERVER – Error : Fix : Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.)

October 5, 2010

I recently got email from friend who had suffered from following error. Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file “filepath” failed with the operating system error 2(The system cannot find the file specified.). Msg 1802, Level 16, State 1, Line 2 CREATE DATABASE failed.…

SQL SERVER – Find Total Number of Transactions on Interval

October 4, 2010

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Server, SQL System Table

In one of my recent Performance Tuning assignment I was asked how do someone know how many transactions are happening on server during certain interval. I had handy script for the same. Following script displays transactions happened on server at the interval of one minute. You can change the WAITFOR DELAY to any other interval and it should work.

SQL SERVER – The Limitations of the Views – Eleven and more…

October 3, 2010

Pinal Dave

SQL

SQL Server

I had earlier written, interesting article series on the limitations of the views. I had a great time writing this series. I got many many requests.

SQLAuthority News – SQL Server Seminar at Colombo Full – Hyderabad Few Seats Available

October 2, 2010

Pinal Dave

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

If you are familiar with my blog, you might be aware of that I am doing world-wide seminar on SQL Server Seminars. I have lots of request to do the event in various cities, now our plan is very simple and to do this in very few cities. Our current…

SQL SERVER – Get Query Running in Session

October 1, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table, SQL Utility

I was recently looking for syntax where I needed a query running in any particular session. I always remembered the syntax and ha d actually written it down before, but somehow it was not coming to mind quickly this time. I searched online and I ended up on my own…

SQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download

September 30, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

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 – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10

September 27, 2010

Pinal Dave

SQL

SQL Index, SQL Scripts, SQL Server, SQL View

I have recently written many articles on the limitation of the views. I have tried to sum up all the keywords which are not allowed in the indexed view.