Previous link can be found here :

http://sqlserverpedia.com/wiki/Index_Selectivity_and_Column_Order

More info for R2 on http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

Franky

Maybe off-topic but this is an alternative.

Select top 1 myDate

from myTable

group by myDate desc

Hi JP,

When using the AS Deployment Wizard you specifiy 'retain existing roles' when deploying your cube solution to another server. Earlier defined roles on that other server will still exist...

Hi,

If you already have the two sets,

then you can 'union' them like this :

Union(Set1,Set2)

or

Set 1 + Set 2

or

{Set1,Set2}

Franky

Solved !

Apparently, the " SQLSTATE 01000 (Message 0) " is a generic error message from failing T-SQL scripts executed as a SQL Server Agent job step.

Approach : run the...

An update.

The SQLSTATE 01000 error does not occur anymore on the ALTER PARTITION SCHEME statements.

But, it still occurs on ALTER INDEX REBUID statements :

ALTER INDEX myIndex ON myTable...

You can increase the memory of your client,

or you should reduce the size of your report output :

- limit the nr of rows

- limit the nr of columns (remove 1...

Hi,

You can use the derived column task. In the select you can use the dateadd and datepart T-SQL functions to add your time to your date.

Hello,

SQL Server tries to read as much as possible from memory instead of disk. For that purpose it uses a part of the memory : the DBMS buffer cache.

Immediately...

Hi,

Before reprocessing the cube dimension, as mentioned previously, you can consider uploading new records for your dimension table.

Regards,

Franky

Hi Chris,

The DMV's collect real-time information. So, it makes sense for some of them to schedule a SSA job every 5 minutes to capture the necessary information.

Hi Vivien,

The best way is to restore from a backup to a certain point in time (in case of full recovery mode).

This keeps your data consistent across your tables.

In case...

Hi,

You should restart the SQL Server instance.

Grts,

F;

Hi Thatok,

You could also add each chart to a separate rectangle.

You can layout both rectangles as you like, just make sure the rectangles are large enough to fit enough chart...