Now that i tried to make the performance test, i have found out that i don't have profiler. My servers are 2005 and my laptops is express 2008.

Hi guys,

Thanks for the feedback.

You are right, the precision depends on the size of the tally table and the filter "Number BETWEEN 2 AND X". Increasing X and the...

Hi David,

This is the structure and the code to populate it:

CREATE TABLE [dbo].[Numbers](Number INT NOT NULL PRIMARY KEY)

INSERT INTO Numbers

SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY c.object_id) FROM sys.columns c CROSS...

Hi Nadrek,

I'm really sorry for responding so late. I looked your function andI liked it, I'm also interested in the performance comparison, I have the feeling mine will be slower,...

Interesting and very eclectic.

Thanks Mishaluba =)

archon99 (11/27/2013)

---

We had to solve the same problem in our business, and the first solution we adopted was as shown in the article, but the strain on the db and...

adrian.facio (11/27/2013)

---

lubork (11/26/2013)

---

Nice simple solution. Observe the Schedule table is fully updateable (e.g. you can change the EndDate value and

UPDATE Schedule SET EndDate = '2013-12-09 18:30' WHERE...

lubork (11/26/2013)

---

Nice simple solution. Observe the Schedule table is fully updateable (e.g. you can change the EndDate value and

UPDATE Schedule SET EndDate = '2013-12-09 18:30' WHERE Activity...

lubork (11/26/2013)

---

Nice simple solution. Observe the Schedule table is fully updateable (e.g. you can change the EndDate value and

UPDATE Schedule SET EndDate = '2013-12-09 18:30' WHERE Activity...

jjturner (11/26/2013)

---

This is a decent workaround for something SQL Server doesn't seem to adequately support (afaik): temporal awareness

Not to plug another rdbms, but the one starting with "p" has gone...

Nadrek (11/26/2013)

---

This is an interesting take on temporal constraints, but have you tested it with large sets, i.e. perhaps millions of rows of data where the time ranges are measured...

adrian.facio (11/26/2013)

---

Thanks =D, heheh i did not thought of that,...

taqveem45 (11/26/2013)

---

nbraasch (11/26/2013)

---

from the example, if I'm not mistaken, the statements that are being rolled back are direct inserts to the table, but the index on the view is what...

Thanks =D, heheh i did not thought of that, but...