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

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

December 13, 2011

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

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…

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…