Product has been added to your cart.

Posts by Erik Darling

Erik Darling
365 posts
Restoring tempdb since GETDATE(). Now blogging at ErikDarlingData.com.

And Party and Alt Shift

Erik Darling
SQL Server
53 Comments
This is a cool SSMS trick I picked up a while back Though not nearly as far back as I wish I had. It’s so cool I made a .gif of it in action. When you’re done putting your socks back on, I’ll tell you how it works. This .gif was brought to you by…
Read More

SELECT INTO and non-nullable columns

Erik Darling
SQL Server
22 Comments
SELECT…INTO  is one of my favorite SQL Server features. It’s great for creating table skeletons with false WHERE clauses (1=2), moving a real table to a staged/temp location for testing, etc. In SQL Server 2014 It acquired the ability to go parallel, which is pretty neat, but that’s not what we’re talking about here. It…
Read More

CTEs, Inline Views, and What They Do

Erik Darling
SQL Server
10 Comments
By now, you have probably heard of CTEs And you may have even heard them referred to as Inline Views. Really, an Inline View can be any type of derived table. It’s very easy to illustrate when one may turn into a performance problem with CTEs, if you aren’t careful. A lot of people think…
Read More

Erik Darling Joins Brent Ozar Unlimited

Erik Darling
SQL Server
37 Comments
Kendra here– we’re really excited to announce that we’ve hired Erik Darling on to join our team as a consultant. Erik’s first day is today. To introduce Erik, we’re sharing some of his answers to our call for job applications. We were so impressed, we knew we had to talk to him right away. What are…
Read More