I've seen other recommendations that say maxdop = number of numa nodes, but even that was caveated by knowing if your system was OLTP or OLAP. I spent quite...

Hi,

There's a very small performance difference between max and non-max varchar types. http://rusanu.com/2010/03/22/performance-comparison-of-varcharmax-vs-varcharn/

If you specify a 1000 limit, you'll get errors about data being truncated if you try and...

Hi,

There's a couple of upgrade options on the install wizard. Version upgrade and edition upgrade. These will achieve your goals in terms of upgrade.

Always backup your databases before...

Our production cluster is physical. All our test development environments are on VMWare, and we have a cluster in VWWare, too. So, I'd say yes.

Is the master database file (master.mdf) in this location: j:\PowerUserMasterdata\ ?

Check that the directory is accessible by the account running SQL Server sevices

If you create a view of a table with schemabinding, you cannot drop columns referenced in the view from the table without first changing the view. If you query...

how much RAM on the server? What's your max server memory setting? You probably want to throttle it back to leave room for VAS

IT researcher (8/2/2013)

---

adb2303 (8/2/2013)

---

Each differential will be all the changes since the last full backup, i.e. they're not incremental. They can get quite big if not managed properly...

Each differential will be all the changes since the last full backup, i.e. they're not incremental. They can get quite big if not managed properly - even bigger than...

regarding SQL Server database fragmentation, I'd use Ola Hallengren's utility:

http://ola.hallengren.com/

Hi,

I've done it before several times the way you described and not had any problems yet

in the failover cluster manager, check that the cluster disk for your backup drive is a dependency of the sql server resource

or event notification with service broker

Check your spn's, i.e.

setspn -L domain\serviceaccount

(if SQL Server's running under a domain account)

setspn -L computername

(if SQL Server's running under a local system account)

I presume there's something wrong...

Hi,

select OBJECT_NAME(object_id),* from linkedserver.master.sys.columns where name like '%%'