Tip : Improve Efficiency by Switching to INSTEAD OF Triggers

I highlight a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.

After an initial look at in-memory TVPs at small scale proved promising, I take a closer look at trying to match more values against a much larger table.

I investigate a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.

I investigate a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.

Tip : Script to Set the SQL Server Database Default Schema For All Users

I discuss a common requirement, generating random numbers to serve as surrogate keys, and show how you can avoid the incremental cost of preventing collisions.

Tip : Generating Random Numbers in SQL Server Without Collisions

I investigate a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.

I discuss a case where assumptions can lead to a poorly-performing query and where exploring other options can pay off.

I reflect on the presentation I gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including responses to Q & A.

Tip : Use UNPIVOT to dynamically normalize output

Tip : Use UNPIVOT operator to help normalize output

I explore a few additional places to get information useful for decisions about creating new indexes that are suggested as "missing" by various tools.

Tip : Extend DDL Triggers for more functionality: Part 2

I talk about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.

Tip : Extending SQL Server DDL Triggers for more functionality: Part 1

I go into a little more detail about what happens to metadata when you use schema transfers behind the scenes.

I discuss some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped me isolate and solve the issues.

I explore a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items.

Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…

I discuss ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.

See how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.

I had a great time at the MVP Summit last week. Caught up with a lot of friends, tried some new foods, and took in some great technical sessions.

There is an important MERGE "wrong results" bug, involving indexed views, that could be affecting your queries right now.

Tip : Move all SQL Server indexed views to a new filegroup

In part 3, I shift focus to generating sequences of dates.

In this installment, I talk about the next level of scale: generating sets of 50,000 and 1,000,000 numbers.

I discuss ways to generate a contiguous set of numbers from 1 to 1,000.

I talk about some potential inefficiencies here that you might not notice on low volume sites but that will start to affect performance as your web volume ramps up.