All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files

December 16, 2011

Recently I was exploring SQL Server Audit and found something very interesting. I found two enhancements in the SQL Server 2008 Create Audit Screen. SQL Server 2012 Create Audit Screen SQL Server 2008 Create Audit Screen On Audit Log Failure Options You can see that in SQL Server 2012 they…

SQLAuthority News – Online Session Practical Tricks and Tips to Speed up Database Queries Today

December 15, 2011

Pinal Dave

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

I am presenting on performance tuning topic again today at Virtual Tech Days. This time I am going to talk about lots of practical tips and will focus on what we can do immediately right after the session is over. During the session I have two things for you to…

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book

December 14, 2011

Pinal Dave

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

SQL Scripts, SQL Server

I was recently reading excellent Just Learned Tip regarding 3 part naming Cannot be used when dropping Views,Functions or Procedures. This is quite a well known tip however, every developer and DBA learns at sometime in their career with ‘hm…’ moment. To illustrate this further here is a simple case…

SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

December 13, 2011

Pinal Dave

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

SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of Tips and Tricks. For me, this is a very interesting subject. I perfectly enjoy a discussion when it is about performance tuning. I commonly get follow-up questions regarding this subject, but most of them do not give…

SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011

December 12, 2011

Pinal Dave

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

Performance tuning has been my favorite subject and any time when I have to present on this subject, this itself gives me tremendous pleasure as well. I am always excited to present something new on this topic. Virtual Tech Days is just here around the corner and I am going…

SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32

December 11, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Statistics

Earlier I wrote an article where I demonstrated that an index with more than 16 column is not possible. Here is the link to the article. After reading the same article I received email from user suggesting does it mean that statistics can be only created on only 16 columns.…

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 – 4 Saturdays to Go

December 10, 2011

Pinal Dave

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

Database, SQL Saturday

SQLSaturday 116 is now only 4 weeks away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. Schedule and Venue Event Date: January 7, 2012 Event Time: 10 AM to 6 PM Event Venue: Microsoft Singature Building, Domlur, Bangalore , Bangalore, India Important Links: Register for…

All Articles file-format-error-01-600x200

SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid

December 10, 2011

Pinal Dave

SQL Tips and Tricks

File format, SQL Error Messages, SQL Server

I recently had long email conversation with one of the blog reader who was struggling with installing SQL Server 2012 RC0 installation. I just thought I will publish what we have done and how we solved problem so if you are facing the same issue, you can avoid the same. In this blog post we will see how to fix setup error.

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

December 9, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Madhivanan is SQL Server MVP and very talented SQL expert. Here is one of the nugget he shared on Just Learned. He shared a tip where there were two interesting point to learn. Do not use keywords as an object name [read DHall’s excellent comment below] He has given excellent…

SQL SERVER – Error: Deleting Offline Database and Creating the Same Name

December 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Server Management Studio

Offline database is very interesting subject, and there are a couple of interesting details associated with it, which one must know. There are two common queries related to offline database: 1) My hard drive is getting full and I deleted my ‘offline’ databases. After deleting my offline databases, my hard…