Thanks..

I have never heard of this vertical vs horizontal but I would use your first schema.

ME: I wasnt being technical, just using some colour to explain my point of...

Do you mean

C:\..\DBMyWebProject.mdf

What the code to use

DBCC SHRINKFILE

When its a database, or is it a log file ??

My Database name is : DBWebProject

So do I do this:

DBCC SHRINKFILE (DBWebProject,64);

Thanks:-)

I use the same code structure above, I have only 3.5 million records. So it takes about a 1 second. I can live with that.

The base table has an primary...

Thanks, I think I cracked it !

Thanks

phew...lucky I asked:w00t:

so I should

DBCC SHRINKFILE (MyDB,10);

ALTER INDEX ALL ON DIM_Data REBUILD

****ONLY on DOWNTIME, not automatically via job

QUESTION : MyDB bloats up from 500Mb, to 1000MB quickly after a...

Ooops I stuffed up the date selection, went forwardm should have gone backwards

Should be....

Format MM/dd/yyyy

01/01/XXXX

04/01/XXXX

07/01/XXXX

10/01/XXXX

Only the above dates can be returned.

When date is 02/20/2011, then I would want 01/01/2009

When...

Thanks Lutz :-):-D:-)

Awesome

Then I assume that the developer edition crosses many versions, and its just depends on what features I have used in the Dev edition as to if it will work...

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

From this link I assume I can take a DB from developer edition and isntall it into a web edition?

Thanks for this link

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

But I cant work out where to install it..

Do I install it on myDB (main database), or do I install it in a myTestDB and...

Thanks.

Ok I run the back up daily.

With what frequency do I run or should I at all run Integrity check and index optimization.

And what about this code that I run...

YES in the VPS you can..