I think this will work. I've only done it 3 levels deep, but the principle's there and you should be able to extend it to as many levels as you...

Hmmm, that's going to be one messy query.

Let me think about this....

Sum ignores nulls. If you sum a column that contains nulls, you'll get the total of the non-null values and a warning saying null values were eliminated due to aggregation.

The...

Ok, a bit better.

so...

z  a

x  z

y  x

if I ask x, I'll get a

if I ask y, I'll also get a

Is that right?

Is there any limit on how deep...

How do you define 'latest'? Do you have a date or timestamp somewhere in there or some other way to order the records?

If the table has

y  a

x  a

x  y

a  c

y ...

Can you post the table structure please, columns, constraints, current indexes. also if possible, the update statements that run.

Thanks

Why two columns? Tis a much better design to have a single column that stores the current datetime.

Getdate retuns the current date and time to an accuracy of 3 ms....

Remove builtin\Administrators from the sysadmin role. Make sure that you have another admin account before you do that. Make sure that the sa login has a strong password.

It won't stop him from...

I wouldn't personally think more than about 10-20% from just splitting the files. Now if you're moving to faster disks as well, you'll get an increase from that as well.

We're...

It depends on whether the data required for the join is in memory or on disk. If both tables are in memory, then there will be no gain (because no...

I forgot to mention, we've currently got three filegroups, clustered indexes in 1, nonclusters in the second and some of the tables text images in the third and we're looking...

Yup, I've got a system just like it. GUID primary keys all with clustered indexes. However I've got just over a thousand tables.

How I've approached it is to change the...

It is possible for anybody to copy the mdf and ldf files of a database, copy it on another machine and have complete access over it

If users have access to the...

I'm mostly working less than 5 years ago.

5 years ago I was a senior developer at a small development company. It was the norm to get in before 8,...

The only problem I have with the page peel is that from time to time it throws a flash error and crashes IE. Some days it takes 3 or 4...