what do you want to return when a meeting spans over an hour segment...say for example 9.30am to 10.30am

MDB files are not split really. The data is segregated logically between MDB files so that the DB application user-interface knows exactly which MDB file to go for sequential or...

erichansen1836 (9/10/2015)

---

If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database, each MDB file containing 10...

a starter for you to consider

CREATE TABLE #NONAMETABLE(

ID INT

,column1 INT

);

INSERT INTO #NONAMETABLE(ID,column1) VALUES

(1,100.00)

,(2,60.00);

SELECT column1, column1 -...

see how this works to start with

SELECT Personelnumber, Name, LastName,

max(case when Description = 'BaseSalary' then 'basesalary' end ) ,

max(case when Description = 'BaseSalary' then amount end) ,

max(case...

We struggle with things which I feel are fairly basic such as returning a list of 5,000 students with their highest Maths, English and Science results (the organisation in question...

is this the guy?

http://www.linkedin.com/in/msjetdatabasedba

for other readers....seems a similar discussion is also here

https://social.msdn.microsoft.com/Forums/office/en-US/d768ffb9-08ad-4998-a71d-04b869c13ca8/ms-jet-red-database-engine-4x-capacity-testing-is-mssql-server-even-necessary?forum=accessdev

Sean Lange (9/10/2015)

---

robert.chipperfield (9/10/2015)

---

Sorry to hear that - we've not seen a repeat of the same packet loss we were seeing since it was fixed, so it feels like it...

deleted....poor explanation!

try this....using Luis code.....all I have done is put in sample data based on what you told us.

if this isnt right....please save yourself (and us trying to help you) ...

why dont you post some example data....would make it easier I am sure

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

TomThomson (9/4/2015)

---

Eirikur Eiriksson (9/3/2015)

---

TomThomson (9/3/2015)

---

Ed Wagner (9/3/2015)

---

I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

Those who have never heard of...

a test for comparisons on 1M rows

see http://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/

SELECT TOP 1000000

ID = IDENTITY(INT, 1, 1),

Amount = CAST(Rand(Checksum(Newid())) * 99 + 1 AS BIGINT),

Type ...

another idea

SELECT

t.ID

, SUM(t.AMOUNT) OVER(ORDER BY t.ID

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW) - T.AMOUNT AS rsum

FROM #temp AS t

WHERE(t.TYPE =...