October « 2011 « SQL Server Journey with SQL Authority

Archive for October, 2011

SQL SERVER – DATEDIFF – Accuracy of Various Dateparts

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL DateTime, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 21, 2011 | 8 Comments »

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 the actual min is 0.05Min) [...]

Read Full Post »

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

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Wait Stats, SQL Wait Types, T SQL, Technology on October 20, 2011 | 1 Comment »

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 part of this book is [...]

Read Full Post »

SQL SERVER – A Simple Quiz – T-SQL Brain Trick

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 19, 2011 | 76 Comments »

Today we are going to have very simple and interesting question. Run following T-SQL Code in SSMS. There are total of five lines. Three T-SQL statements separated by two horizontal lines. SELECT MAX(OBJECT_ID) FROM sys.objects ______________________________________ SELECT MIN(OBJECT_ID) FROM sys.objects ______________________________________ SELECT COUNT(OBJECT_ID) FROM sys.objects Now when you execute individual lines only it will give [...]

Read Full Post »

SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL PASS, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on October 18, 2011 | 1 Comment »

Recently I attended SQLPASS 2011 and it had few announcements and some of them really important. I am going to write in detail in future all the announcements. However, there is one announcement needs special attention and blog post. The official name of the next version of the SQL Server. So far we were all [...]

Read Full Post »

SQLAuthority News – Your Performance Story – My Contribution to Your Learning

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 18, 2011 | 2 Comments »

I was recently playing with SafePeak‘s performance tuning tool, while I was on their site, I noticed that they have contest running where they are giving away expensive gadgets. The contest has some really nice entries and I few of the participants are my close friends as well. I liked most of the stories. I [...]

Read Full Post »

« Newer Posts - Older Posts »