Feeds:
Posts
Comments

Archive for June, 2010

SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on June 30, 2010 | Leave a Comment »

Last month I wrote monthly round up and I was very well received. For the same here it goes this months wrote up for all the SQLAuthority.com blogs. The month started very interesting subject of SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision which lead to few datetime related blog posts. I find [...]

Read Full Post »

SQL SERVER – Outer Join Not Allowed in Indexed Views

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Joins, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on June 29, 2010 | 5 Comments »

I recently received an email that contains a question from one of my readers. I have already replied the answer to his email, but I would still like to bring it to your attention and ask if you think I could have done any better with the example I gave. The question was raised when [...]

Read Full Post »

SQLAuthority News – Exam 70-433 – MCTS – Microsoft SQL Server 2008, Database Development

Posted in Best Practices, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged , on June 29, 2010 | 18 Comments »

I often receive lots of questions regarding how to pass SQL Server Certification exams. I have previously written about the road map over SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications. I have tremendous respect for Microsoft Certification and I enjoy the preparation phase as well as attending the real exam. The [...]

Read Full Post »

SQL SERVER – Default Statistics on Column – Automatic Statistics on Column

Posted in Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on June 28, 2010 | 3 Comments »

During the SQL Server Training, I frequently noticed confusion in people in terms of Statistics. Many people have no idea on how Statistics works. There are so many misconceptions with respect to Statistics. I recently had an interesting conversation with one attendee who believed that Statistics only exists on Column if there is an Index [...]

Read Full Post »

SQLAuthority News – Announcing Winners of the Office 2010 Giveaway

Posted in Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on June 27, 2010 | 1 Comment »

Thank you all for participating in Office 2010 giveaway. After carefully evaluation following user is announced as the winner. The question was as following. Choose best option: With which Microsoft Office Product Powerpivot is associated? Options: 1) PowerPoint 2) Excel 3) Word The answer was suppose to be most creative and informative. Many congratulations to [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers