I actually initially did not want to continue in this thread because I do not see there are any fundamental differences between everyone's views (ie. making tempdb quicker is a...

@jeff Moden, the wish that all developers will be able to write high-quality code was, is and will still be a wish. But just because of the fact...

Actually putting tempdb totally in memory is a great idea in general.

10 years ago, we never imagine MS will have in-memory OLTP technology, so I bet in future, we will...

I...

In all honesty, it is a good product but it is also not that difficult to create it, I mean not difficult in the sense that to me, this product...

Mike, can you please correct the link of SP2 CU5, which points to SP2 CU6?

Hi Steve,

The link for SP2 CU5 is wrong (it links to SP2 CU6). The correct link should be http://support.microsoft.com/kb/2555408

Thanks,

Jeffrey

John Rowan (6/22/2009)

How can you say that you were a full time data modeler for more than a year and that you think normalization is theoretical nonsense? An answer...

I guess this argument is meaningless. We can create...

Michael Valentine Jones (6/22/2009)

jeffrey yao (6/22/2009)

I think "no primary keys, no constraints of any kind, no indexes, all columns were nullable, and dates were stored in varchar(8) instead of datetime."...

Michael Valentine Jones (6/22/2009)

steveb (6/22/2009)

Jeff Moden (6/22/2009)

jeffrey yao (6/20/2009)

Michael Valentine Jones (6/18/2009)

Just say that “normalization” is theoretical nonsense that so-called gurus...

Michael Valentine Jones (6/18/2009)

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko throw around to try...

Usually any "best" candidates will not be in the market looking for a job, or if they are, they will find jobs quickly, i.e. the time-window will be short for...

How about running this query

use distribution -- assuming this is your distribution db name

select name, total_space_MB=size/128.0, Used_space_MB= fileproperty(name, 'spaceused')/128.0

from sys.database_files

and please post back the results and we can diagnose...

Thanks for the update and appreciate your working attitude, i.e. never leave anything unsolved.