I usually prefer to a fresh install to be honest. Everyone is different...

Doing a side by side install you can keep the current instance running serving those that need it.

Yes that's your best bet. You can probably do an in-place upgrade from your 2008 instance to 2008R2. That's not to say i'd recommend it....

Depending on the size of the database you may well be able to get it restored on a SQL2008R2 express edition. That's limited to 10GB sized DB's though.

If your backup has come from a 10.50.x version that's SQL 2008R2. So you'll only be able to restore that on 2008R2 instance or later (2012).

If you only need the...

Thats a bit too deep to go into for a forum post.

http://en.wikipedia.org/wiki/Database_normalization

Read that. Look at section 3 Normal Forms. Each of those has a link to an explanation of each...

Further to that, here's the instructions to make the 2005 report pack work on 2008:

http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx

Hi,

The report you want for that is included in this reporting pack for SQL 2005.

SQL Server 2005 Performance Dashboard Reports

You can use google to find a 2008 version if you...

Hi,

When I was learning I used the MSDN tutorials found here:

http://msdn.microsoft.com/en-us/library/ms170208(v=sql.100).aspx

Also, this book is very good:

http://www.amazon.co.uk/Delivering-Business-Intelligence-Microsoft-Server/dp/0071549447/ref=sr_1_5?ie=UTF8&qid=1366621876&sr=8-5&keywords=ssas

Hope those help.

Thanks,

Simon

Remember to specify a length in you convert() for the varchar. Otherwise you will end up with some strange truncation errors.

DECLARE @table1 TABLE

(

ProductId INT

)

INSERT INTO @table1

SELECT 1

UNION ALL SELECT 2

UNION ALL SELECT 3

SELECT

'www.john.com/' + convert(varchar(50),productid)

FROM

@table1

Use the CONVERT() function or CAST()

Is ProductID a string type or an integer?

In that case yes, the SAN admin should be able to create volumes that are restricted to particular servers. But... I'd still favour clustering here over Always On.

No, just not worth doing in my opinion. If the storage is shared...

Looks and sounds like an interview question or homework to me. Which one do you think?

Hi,

You could use them with a shared disk but I don't know that I'd do that (you'd have to store two or more copies of the database on the shared...