theboreddba.com
What is a Key Lookup? - theBoredDBA.com
http://www.theboreddba.com/Categories/indexes/What-is-a-Key-Lookup.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. What is a Key Lookup? Published: 4th July 2015. I was asked this the other day and it’s actually something that I’m surprised hasn’t come up before as people all seem to know it’s a bad thing, but many people don’t know why and don’t even know what one is in the first place. Basically a Key Lookup i...
theboreddba.com
May 2015 Archive - theBoredDBA.com
http://www.theboreddba.com/Archive/May-2015.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Handy Trick in SSMS. This is a quick post about something I only found out recently and which has made my life so much easier in many circumstances. It’s something I also imagine you’ll soon use a lot too if you don’t already. Bug: Implementing Incremental Statistics. Online Partition Index Rebuild.
theboreddba.com
Single Column Indexes Rarely Work - theBoredDBA.com
http://www.theboreddba.com/Categories/indexes/Single-Column-Indexes-Rarely-Work.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Single Column Indexes Rarely Work. Published: 14th July 2015. Think of it this way unless you are avidly querying a table in order to return just one column (or the clustered key of course) and using just that one column in your WHERE clause, then a single column index is not for you. For just 1% of...
theboreddba.com
December 2013 Archive - theBoredDBA.com
http://www.theboreddba.com/Archive/December-2014.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Well, based on some relatively recent posts I’m pretty sure you can all guess what this will be it’s Christmas and therefore we need a Christmas drawing! Foreign Keys Are Allowed to be Null. Datepart DW Giving Inconsistent Results. Shrink Log Without Breaking a Backup Chain. This isn’t going to anyt...
theboreddba.com
November 2014 Archive - theBoredDBA.com
http://www.theboreddba.com/Archive/November-2014.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Transactions and Table Variables. Now, anyone who’s read enough of my blog will probably know that I’m not too fond of the Table Variable as I see it being used too often and generally in a way that it’s not designed. Well, this is yet another reason why I’m not a fan. Some Artwork Using SSMS. What ...
theboreddba.com
Performance Impact of a Key Lookup - theBoredDBA.com
http://www.theboreddba.com/Categories/indexes/Performance-Impact-of-a-Key-Lookup.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Performance Impact of a Key Lookup. Published: 9th July 2015. Following on from my last post about Key Lookups I wanted to emphasize the performance problems that you can get when these appear in your execution plans. AdventureWorks2012.person.address a. AdventureWorks2012.person.person p. So how ab...
theboreddba.com
March 2015 Archive - theBoredDBA.com
http://www.theboreddba.com/Archive/March-2015.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. At some point I will explain the nuances of the Columnstore index, how they work, when and where you should use them, and what they’re for but in the mean time I have recently had situations in which I have upgraded to SQL 2014 and have needed to Columnstore a table. Creating a Database Snapshot.
theboreddba.com
What Are Filegroups - theBoredDBA.com
http://www.theboreddba.com/Categories/Internals/What-Are-Filegroups.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Published: 24th June 2015. Well, let’s be honest here in a nutshell a Filegroup is wait for it a group of files. Bet you didn’t see that one coming. However, it’s their uses which are actually worth discussion because they provide some useful functionality as a whole. The way to do this is filegroups.
theboreddba.com
Blog - theBoredDBA.com
http://www.theboreddba.com/default.aspx
Just a Bored DBA. Trying to share some knowledge and experiences with the world. Script to Update Specific Stats. Only Update Stats You Need. How Inserted and Deleted Tables Work. SQL Server Trigger Examples. Script to Update Specific Stats. In my previous post I was stating that we need to be more intelligent with our stats updates rather than hitting a whole table with a sledgehammer and potentially suffering poor performance as a result. Only Update Stats You Need. I’ve seen situations in which you ha...