Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2

January 7, 2013

Before you start reading this blog post, I strongly suggest you to read the part 1 of this series. It talks about What is Redundant Index. The story is a conversation between two individuals – Jon and Mike. They are different but have single goal learn and explore SQL Server.…

SQLAuthority News – Download Whitepaper – Cleanse and Match Master Data by Using EIM

January 6, 2013

Pinal Dave

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

SQL White Papers

Master Data Services (MDM) and Data Quality Services (DQS) go hand to hand together when they have to maintain the integrity of the database. If you are new to either of concept I suggest you to read following two articles to get an idea about them. Why Do We Need…

SQL SERVER – Cursor, Truncate Log and More – Memory Lane #010

January 5, 2013

Pinal Dave

SQL

Memory Lane, SQL Server

This is the 10th episode of memory lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite articles this week are about cursor and truncate log. Let me know which one of the following is your favorite article from memory lane.

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1

January 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Index never stops amazing me, there are so much to learn about Index that I never feel that there is enough knowledge out about this subject. If you are interested you can watch my Indexing Course on Pluralsight for further learning on this subject. On my production server I personally use embarcadero DB…

SQLAuthority News – Year 2012 in Review – Perspective of Blog

January 3, 2013

Pinal Dave

SQLAuthority News

SQL Milestone

The WordPress.com stats helper monkeys prepared a Year 2012 annual report for this blog. I am very much delighted that the blog has been helping many different people throughout the world for many years. I really really thank you for your kind support in helping SQLAuthority.com blog becoming the resource for everyone to learn new things.

SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video

January 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Every developer has a different habit. Some like to format the functions in upper case and some wants it in lower case. I often see developers listing the columns in SELECT clause in a different way. I have my own preference but I do respect the other developer’s preference as…

SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself

January 1, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

First of all, happy New Year to all of you – 2013 has started! Every year I make at least one resolution, some I do for the public on my blog. The reason is simple – if I declare something in front of all of you, there is a good…