SQL Tips and Tricks Archives - Page 294 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – History of the Database – 5 Years of Blogging at SQLAuthority

November 1, 2011

Personal, SQL, SQL Server, SQL Tips and Tricks

Don’t miss the Contest:Participate in 5th Anniversary Contest Today is this blog’s birthday, and I want to do a fun, informative blog post. Five years ago this day I started this blog. Intention – my personal web blog. I wrote this blog for me and still today whatever I…

SQL SERVER – How to Ignore Columnstore Index Usage in Query

October 30, 2011

Pinal Dave

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

SQL Index

Earlier I wrote about SQL SERVER – Fundamentals of Columnstore Index and very first question I received in email was as following. “We are using SQL Server 2012 CTP3 and so far so good. In our data warehouse solution we have created 1 non-clustered columnstore index on our large fact table.…

SQLAuthority News – Online Webcast How to Identify Resource Bottlenecks – Wait Types and Queues

October 28, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

As all of you know I have been working a recently on the subject SQL Server Wait Statistics, the reason is since I have published book on this subject SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues [Amazon] | [Flipkart] | [Kindle],…

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

October 27, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database

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…