All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site

October 11, 2010

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

I am delighted and very excited as I am going to attend very first time SharePoint Conference. Even though I will be attending SP conference, I will be presenting on my favorite subject – SQL Server Performance. Every SharePoint site runs on SQL Server and most of the SharePoint sites…

SQL SERVER – Encrypted Stored Procedure and Activity Monitor

October 10, 2010

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure

I recently had received question if any stored procedure is encrypted can we see its definition in Activity Monitor.

SQLAuthority News – SQL Server 2008 Add-ins and Feature Pack Downloads

October 9, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Utility

Here are few of the latest Microsoft Add-ins and downloads recently announced. SQL Server Reporting Services Add-in for SharePoint Technologies The Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of…

SQL SERVER – Simple Explanation of Data Type Precedence

October 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype, SQL Scripts

While I was working on creating a question for SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion, I had actually created yet another question along with this question. However, I felt that the one which is posted on the SQL Quiz is much…

SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion

October 7, 2010

Pinal Dave

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

SQL View

My very good friend, Jacob Sebastian, is running a month-long SQL Quiz Series where the best-of-the-best experts from around the globe would be the quiz masters. They will ask one question every day, and users are expected to answer them correctly. The winning prizes include cool gadgets like iPAD, Kindle…

SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution

October 6, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Scripts

As the title suggests, this is quite a dirty solution; it’s not as elegant as you expect. The Story: I got a phone call at night (11 PM) from one of my old friends, requesting a hand. He asked me if I could help him with a very strange situation.…

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

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

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…