Jeff Moden perhaps that is the reason why Option A is sometimes faster and why Option B is sometimes faster my knowledge of DBA aspects is not as deep as...

First I am still learning this forum so do not know how to properly quote messages but to answer Jeff Moden 2nd statement then 1st.

I concur with your Steps 1,...

Note I teach/tutor for free and have an online Discord server with 80 plus students at verying levels of expertise. My first motto is (and all my students know it)...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen.

The problem I see as Grant Fritchey allued to is that you have not defined what you mean by matching data.  I mean I can eyeball what you have presented...

We currently do 2 Week Sprints both for Application Development and Database Development/Management -- we have Epics which get broken down into smaller pieces the largest single project being 16...

Also another means of getting around all those WITH (NOLOCKS) is to set at the top of the stored procedure either:

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

-- OR --

SET TRANSACTION ISOLATION READ...

ScottPletcher that is not entirely true and that is not what I was talking to. I was looking at the bigger picture or the why are they creating these monthly...

To expand upon SSC Guru's question there are two types of Datetime data types and the second one is variable. The first data type being the now deprecated from Standard...

Dang that Edit feature is really picky, and to whomever just because I edit the post does not mean it is spam. I just like clean posts.

Okay I was asked...

Okay to comment on the (A) CREATE TABLE with INDEX then INSERT INTO versus the (B) SELECT INTO then create INDEX there is no set solution for which is better....

Okay not sure why my previous post was considered spam so I will try again, perhaps because I tweaked it too much.

There are many ways to handle this but what...