No - 2008 and 2008 R2 are essentially different versions entirely with a similar name.

Patches are for one or the other. There are no SPs for R2 yet.

You need explicit conversions on INT/Numeric/etc columns when concatenating to a varchar/nvarchar string, such as:

SELECT @lvc_log_string =

CONVERT(NVARCHAR, @pi_quarter_num) + ' ' +

CONVERT(NVARCHAR, @pvr_financial_year) + ' ' +...

I have never successfully edited a column type through the GUI..

Just do it via T-SQL

ALTER TABLE tablename

ALTER COLUMN columname VARCHAR(MAX)

exec sp_configure 'Show Advanced Options',1

reconfigure with override

exec sp_configure 'Max Degree of Parallelism',1

reconfigure with override

See if that helps at all. Downgrading from 4 cpus to 2 cpus is going to have...

Differential backups have nothing to do with log backups.

The method you're trying to implement is a million miles away from Best Practice actually. The root issue here is that the database is on Full recovery when there is...

Why are you using full if you don't plan on taking transaction log backups?

I realize you said it's a requirement, but why? That sounds like it was a rule written...

With only 2 procs, make sure your MAXDOP is set to 1. If SQL tries to run any kind of parallelism, it could take up both CPUs and then that...

Correct

Actually in Sql...

What is your reasoning for this?

You get the same execution plan either way (index scan + hash match)

Tara-1044200 (10/6/2010)

---

Sorry I am not clear with this, if i am adding a user to Administrators group on windows do you mean that user will not have sysadmin access on...

By default, in sql 2005, the builtin\administrators group (local windows admins) have sysadmin access to the sql server.

If you want to remove that and add users manually, remove the builtin\administrators...

You could install it on your sql server instead of your desktop, and then remove it when done.

Thanks - its also usable and easily understandable by the business people (color coded), developers, and anyone else who might need that info, but doesn't want to have a full...

I've used Spotlight, and later Idera..but now basically I just have my own reporting page that gives me at-a-glance info on every server (failed job list, long running jobs, replication...