Tip : Improve SQL Server 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 deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.

I had a "soft" post on the PASS Summit 2013 speaker feedback.

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

I share slide decks and sample code from SQLintersection in Las Vegas.

I reflect on PASS Summit 2013 in Charlotte.

Douglas McDowell (EVP Finance) takes the stage (no kilt), and talks numbers. PASS has an impressive $1MM in reserves as a "rainy day" fund. Last fiscal year they spent $7.6MM on community; 30% of...

Early morning start here in Charlotte. I'm going to try and keep this post updated as I have new information from the keynote to share, so refresh often! 8:24 AM Bill Graziano takes the...

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.

The SQLintersection conference is taking place at the MGM Grand in Las Vegas, the week of Hallowe'en (October 27th – 31st). While much of the hubbub this time of year surrounds the PASS Global...

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 SQL Server 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.

I gave two talks at the SQLintersection conference this week in Las Vegas. One was my Bad Habits & Best Practices session, and the other is a new one discussing advantages to upgrading to...