If you want to check the characters at the start of a string, you should use the LEFT function. "startswith" is not part of the syntax of the IIF...

If you are organised, a single DBA should be able to manage dozens of servers. I was the sole DBA at a site with about 50 servers in about...

The simple existence of a view (or even 1,000's of them) has absolutely no impact on the performance of your server. A view will only affect performance if someone...

I am pretty sure the answer is no. This is because Enterprise Manager uses SQL-DMO to access SQL Server instances and this does not support SQL 2005.

However, you are...

The commands you need are BACKUP and RESTORE.

BACKUP will take the entire contents of a database (table definitions, stored procs etc plus any data) and "save" it to a file....

You can't get the job name directly but you can get the job id which you can then use to lookup the name of the job (in msdb.dbo.sysjobs)

Have a look...

You certainly can limit the growth of tempdb however when it gets to that limit the query that is needing the space will fail.

A better option is to review the...

Can you add another log file on a different partition ? You could do this, run your history maintenance and then remove the log file you added

This sort of error usually happens because the dimension was not processed before the cube. If you have new records added to the tables in the dimension (in the...

I suggest that you check your logic. I suspect that you expect some code to conditionally execute but it doesn't because you are not using BEGIN/END blocks for the...

You need to either include Table2 in the FROM clause or use an alias

e.g.

UPDATE T

SET Col1 = Table2.ColumnA

from MyFirstTable T

inner join...

Your DBA is on the right path. You will need to have the appropriate SQL*Net software installed onto the server that you are running the SSIS packages from (and...

Not 100% sure from your example of exactly what you are needing but one possible answer is

With Member Measures.A as '.....'

select Measure.A on columns,

(dimension.DIM_1, dimension.DIM_2) on rows

from MYCUBE

I am afraid that the answer to each of your questions is no. In SQL 2008, there is some support this this sort of thing.

In my experience, this sort of issue happens because of the way the Jet OLEDB provider attempts to determine the datatype. What it does is examine the first "few"...