• SQL party

    Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One

      Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One I am a bit late to this party. I have seen this post from Grant’s blog now only. Thanks to Thomas LaRock such a great topic. Here is mine:   1. Too many indexes on a table Developers didn’t check their codes and an execution plan too. They just go and create the indexes (Duplicate indexes too).   2. Improper memory setting Improper min, max memory setting especially for 64-bit servers.   3. Improperly configured transaction log Whenever I got a new server, I have seen log backups are failing because, there is no current database backup. BACKUP LOG cannot be…