Gijs,

I assumed that it was a data warehouse because of your description of the role-play dimension but I can understand how sometimes a full-blown data warehouse is too much to...

Interesting approach although I'm not sure I would have done it in the same way.

It looks like you're describing fact and dimension tables so you're looking at large fact tables....

Good article - I just have one tiny issue which I quote here: "We were lucky to have the backups of system and user databases available....:"

Having backups of your system...

Hi Terry,

You begin by saying "Finding records that exist between two dates can sometimes be slow". In my experience this has never been true when the table in question...

There is no standard I'm aware. Just use whatever makes sense to you and make sure you stick to that naming convention.

In my case I've always used .bak and...

All data types in the coalesce function must be the same.

Try converting the ProductID into a varchar which has a length equal to the larger of productclass and productcolor.

e.g.

Coalesce (ProductClass,ProductColor,convert(varhchar(100),...

Hi,

Actually the scale is only relevant when looking at the graph. So if you're looking at the graph and the value is 52 (for example) you should divide by...

Log shipping is relatively straight forward to troubleshoot.

I this case, no backup was restored to the secondary so:

1. Either the log backup failed on the primary.

2. The log backup failed...

DBCC SHRINKFILE

What error are...

Check BoL again. It's all there in one place. Just do a search for sp_configure and then look for the relvant link, which would be: http://technet.microsoft.com/en-us/library/ms189631.aspx

I'm pretty sure that this is possible as there's no restriction on restoring databases across different editions (save for situations were enterprise features would prevent this - for example, partition...

I don't quite understand.

Are you trying to backup the database across the network to a UNC path? If so, make sure that the SQL Server system account...

That made be sit up.

Have you...

begin tran

alter index <index_name> on <table_name> disable;

<CURSOR>???? -- check the various articles/threads on why you might not want to do this ;)

<UPDATE TABLE>

alter index <index_name> on <table_name> rebuild;

commit tran