There is no way to tell the exact number, but a rough estimation would be 3 times the size of the table, including all the indexes.

In case of 52GB table,...

chrisfradenburg (11/22/2016)

---

A reorg can only move pages withing the file that they're in. I would need to do a rebuild or drop and create to handle this. We're...

Ed Wagner (11/22/2016)

---

Sergiy (11/22/2016)

---

There isn't one. Anything about a person...

RonKyle (11/22/2016)

---

What is you natural key for "person" records?

The logic for UPDATE action is not so clear to me.

What outcome is expected after updates?

Does "last record" mean "last changed"?

I guess this trigger would do what you want to do:

CREATE TRIGGER dbo.trg_MakeLatestRecordActive ON dbo.Records

FOR INSERT, UPDATE

AS

UPDATE R

SET Active = CASE WHEN R.RecordID = i.LastRecordID THEN 1 ELSE 0...

Why do you need this part?

BEGIN

Update X_POPDateChange set NEWDATE=inserted.REQDATE

from inserted

END

I believe it can be simply removed.

Thanks everyone for positive feedbacks.

For myself I use a simple rule of thumb here:

table is a table, even if it's a temporary one, and within transactions it acts as a...

For couple of years I had a can of tuna in my drawer.

I did not put it there, I inherited it together with the drawer from a collegue who left...

Hugo Kornelis (11/10/2016)

---

Sergiy (11/10/2016)

---

ThomasRushton (11/10/2016)

---

ehh.... well, the CTPs for SQL2012 ("Denali") started in November 2010, and the RTM was Q1 2012, so it's possible to have over 4 years experience...

ThomasRushton (11/10/2016)

---

ehh.... well, the CTPs for SQL2012 ("Denali") started in November 2010, and the RTM was Q1 2012, so it's possible to have over 4 years experience with SQL Server...

Jeff Moden (11/6/2016)

---

Luis Cazares (11/2/2016)

---

I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

That said,...

Let's create a test table:

SELECT CONVERT(DATETIME, tg.N ) DT, CONVERT(DATETIME2, DATEADD(dd, N, '19000101')) DT2

INTO #Dates

FROM dbo.TallyGenerator(0,1000000, NULL, 1) tg

CREATE INDEX IX_DT ON #Dates(DT)

CREATE INDEX IX_DT2 ON #Dates(DT2)

Now run the performance...

SELECT CONVERT(DATETIME, 42335)

So convenient.

Especially when you need to generate a range of dates from a Tally table.

SELECT CONVERT(DATETIME2, 735930)

Ooops...

SELECT GETDATE() - 1

Easy.

SELECT SYSDATETIME() - 1

Ooops...

Well, if you love...

Jeff Moden (11/7/2016)

---

Or an overnight care package with a monster hard disk in it. 😀 Did that when...