All Articles - SQL Authority with Pinal Dave

SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward

March 21, 2010

SQL Backup and Restore, SQL Error Messages, SQL Scripts

I received the following email from one of my readers. Dear Pinal, I am new to SQL Server and our regular DBA is on vacation. Our production database had some problem and I have just restored full database backup to production server. When I try to apply log back I…

SQLAuthority News – Microsoft SQL Server Protocol Documentation Download

March 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Download Microsoft SQL Server Protocol Documentation Authored by Microsoft The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft products. The documentation includes…

SQL SERVER – Interview Questions & Answers Needs Your Help

March 19, 2010

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Click here to get free chapters (PDF) in the mailbox About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions…

SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist

March 18, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Certifications, SQL Error Messages, SQL Mirroring, SQL Scripts

Regular readers of my blog will be aware of my friend who called me few days ago with very a funny SQL Problem SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results. This time, it did not take long before he called me up with another interesting problem,…

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE

March 17, 2010

Pinal Dave

SQL Tips and Tricks

SQL Documentation, SQL Index, SQL Scripts, SQL Server

We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.

SQL SERVER – Quick Note of Database Mirroring

March 16, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Mirroring

Just a day ago, I was invited at Round Table meeting at prestigious organization. They were planning to implement High Availability solution using Database Mirroring. During the meeting, I have made few notes of what was being discussed there. I just thought it would be interested for all of you…

SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

March 15, 2010

Pinal Dave

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

SQL Scripts

This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number…

SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You

March 14, 2010

Pinal Dave

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

Business Intelligence, SQL White Papers, SSIS

We Loaded 1TB in 30 Minutes with SSIS, and So Can You SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009 In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30…

SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)

March 13, 2010

Pinal Dave

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

Business Intelligence, Data Warehousing, SQL Documentation, SQL Download, SQL Training

Note: Download SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update) Authored by Microsoft SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is…

SQLAuthority News – Download Microsoft SQL Server JDBC Driver 3.0 CTP 1

March 13, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Note: Download Microsoft SQL Server JDBC Driver 3.0 CTP 1 Authored by Microsoft Download the SQL Server JDBC Driver 3.0 CTP, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5. In its continued commitment to…