SQL Archives - Page 287 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Wait Stats – eBook to Download on Kindle – Answer to FREE PDF Download Request

October 27, 2011

Personal, SQL, SQL Server, SQL Tips and Tricks

Being a book author is a completely new experience for me. I am yet to come across the issues faced by expert book authors. I assume that these interesting issues can be routine ones for expert book authors. One of the biggest requests I am getting for my SQL Server…

SQLAuthority News – Book Signing Event – SQLPASS 2011 Event Log

October 26, 2011

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

I have been dreaming of writing book for really long time, and I finally got the chance – in fact, two chances! I recently wrote two books: SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 [Amazon] | [Flipkart] | [Kindle] and SQL Wait Stats Joes…

SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log

October 25, 2011

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

One of the biggest reason I go to SQLPASS is that my friends are going there too. There are so many friends with whom I often talk on Facebook and Twitter but I rarely get time to meet them as well talk with them. One thing I am usually sure…

SQLAuthority News – Story of Seattle – SQLPASS 2011 Event Log

October 24, 2011

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

Just like every year I attended SQL PASS in Seattle earlier this month. The event was scheduled from Oct 11-14, 2011 in the convention center of the Seattle. I have been to Seattle more than 6 times so far so it is not a new city for me anymore. The…

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

October 23, 2011

Pinal Dave

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

SQL Error Messages, SQL Server Express

Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When…

SQL SERVER – DATEDIFF – Accuracy of Various Dateparts

October 21, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I recently received the following question through email and I found it very interesting so I want to share it with you. “Hi Pinal, In SQL statement below the time difference between two given dates is 3 sec, but when checked in terms of Min it says 1 Min (whereas…

SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution

October 20, 2011

Pinal Dave

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

SQL Wait Stats

Earlier this year I wrote for a whole month on SQL Server Wait Stats and the series was one of the best reviewed I have ever written. The same series has been enhanced and compiled into a book as SQL Server Wait Stats [Amazon] | [Flipkart] | [Kindle]. The best…