I had the opportunity to host the T-SQL Tuesday #11 in October 2010 and am impressed with the number of posts for this edition. We have more than few new comers joining the bash and made it a huge success. The topic for T-SQL Tuesday was “Misconceptions in SQL Server” and the quality of posts was really impressive. Big thanks to all the participants who took the time to share their experience and knowledge on this topic.
Without much delay, here is the round up with no particular order or ranking.
Gail brings excellent narration and also very good information about Table variables myths. I admire the clarity in how she disects and presents the information.Excellent stuff and recommended read for developers as well as DBAs.
Kalen busts one of the oldest myth about TRUNCATE table that has been around in SQL Server for a long time. Kalen always brings deep technical content in her posts and this one is no surprise.
Kendra brings some light on the PRINT vs RAISERROR and explains why RAISERROR is the preferred way to send (debugging/troubleshooting) messages.
Gethyn brings one of the oldest myth about the full backups and Transaction log and in my previous life I was a victim of this myth.
Rob talks about SARGability and one of the myths that’s been around on the programming side of SQL Server. Good short post but I wish he had time for a lengthy post. His clarity in his presentation is very impressive.
Erin talks about the versions and editions and the problem of downgrading to a lower version where accidental dba’s run into soon after upgrading to a higher version.
Brandie explains the basic forms of backup types and the clears the misconception about incremental backups and transaction log backups.
Stuart talks about the most discussed and most debated topic around SQL Server whether to use only stored procedures or use parameterized queries for plan re-use. Good point but I lean towards using stored procedures. Source control and manageability comes to mind.
Raoull talks about one of the most frequently asked question on the forums about the number of data files per cpu/core. Good information and in the days where the number of cores are like 48 and higher, its always best to start with a low number of tempdb datafiles and watch out latch contention.
Steve talks about one of the oldest myth in SQL Server that taking a full backup clears the transaction log. Steve wishes that every one who is involved in SQL Server knew about this.
Michael talks about one of the myths around statistics in SQL Server. There are so many misconceptions around this topic. He talks about the effects of parameter sniffing and query hint options to control the plan re-use.
Bob shares good information about Lock pages in memory and AWE in SQL Server. These are definitely one of the most talked about myths in SQL Server.
Andy shares his own experience and explains the importance of clearly communicating to business users. When two different technical teams talk to each other unless both teams communicate at the same bandwidth there will be plenty of myths going around.
Oscar talks about the need to be watchful while upgrading from older versions to the newer versions as some of the functionalities may NOT be available.
Amit, a well known CSS Engineer in the community shares very good information around patching of SQL Server instances. Good information to read for all DBA’s especially for the accidental DBA’s.
Matt shares his own experience of noticing about the last ran DBCC CHECKDB date in the error log after a reboot. In fact this information is written to the error log from the boot page about the last ran clean DBCC CHECKDB date.
Thomas shares a myth that I have never heard before that databases doesn’t grow. It does sound a bit funny but Thomas shares a query on how this myth was busted.
Jason debunks one of the oldest myths in SQL Server that TRUNCATE is NOT logged with a simple script.
Robert, the lead author of “Pro Database Mirroring”, shares some very good information around Database Mirroring myths. Its a fun technologu that was introduced in SQL Server 2005 and optimized even more in SQL Server 2008.
Pinal talks about the intricacies of indexes used on the base table and indexed views. Good information.
Noel brings a clever approach to solve filtered index problem in SQL Server 2005 with the use of Indexed view.
MLaden posts the most geekiest post in T-SQL Tuesday series so far (IMO). It will sometime to go thru the nuts and bolts of it but it looks really scary. Very good work! Excellent post.
Kerry aka (Airborne Geek) talks about the misconceptions around Active/Active clustering. I am a complete n00b with clustering and something I am planning to change going into next year.
Paul had an extensive series in April and busted over hundreds of myths in a variety of topics all around SQL Server. I consider that is the list to check out when reading about misconceptions in SQL Server.
Jonathan is a triple poster for this edition and talks about data file physical reads doesn’t really correlate to the database engine wait stats and goes in great length to prove that. Very impressive stuff. The second post centers around the misconception that AWE should be enabled on 64 bit systems and Jonathan provides clarity & details why this isn’t true. The third post covers the number of VLFs in tempdb after restart.Jonathan is well known for his passion to provide impressive and very detail oriented posts and he has showed that again in all of his three posts.
And finally, I posted a concise and brief demo that ROWLOCK(s) aren’t always honoured by SQL Server. There are so many things misconceptions around this area and touched a small aspect of that.
My roundup post is delayed by a month for various reasons but it never crossed my mind that I will skip the post. It just took way longer than I thought. My sincere apologies to Adam, all participants and to all readers. If you are interested in knowing what happened please ping me offline SankarDOTReddyATgmailDOTcom.