I've never tested this with iTVFs, only with scaler functions, primaraly because this is where I've been called in to do performance tuning. The big issue is not normally the...

Welsh Corgi (8/1/2011)

---

Leo.Miller (8/1/2011)

---

Welsh Corgi (7/30/2011)

---

This is not neccesarily a good idea. I've worked in the banking environment most of my DBA career, and we almost never had the same...

It's not so much that it isn't using parallelism, but that for every row returned,...

The mail being sent just means it was put on the queue. Have you checked the db-mail error log? Also have you checked your Exchange server to see if the...

Welsh Corgi (7/30/2011)

---

You should have the same users in your Development Environment as your Production Environment.

That way your Development Environment mimics your Production Environment.

If that is not the case you...

Ignacio A. Salom Rangel (7/28/2011)

---

stephen.lappe (7/28/2011)

---

My organization has just started to transition to 2008 R2 and I have seen this error on a couple of our legacy databases.

I...

I did a quick test, a Standby/Read-Only databse can't have it's database owner changed, so there is definitely something being at least tested against the database.

If you recover the database...

No, unfortunately they aren't. The issue being that the database owner detail is stored in the master.sys.sysdatabases table, and not on the user database. There also isn't any way of...

GSquared (7/25/2011)

---

halifaxdal (7/25/2011)

---

I got this idea from Mark Armer, I agree that in some/or many cases SQL cannot be stopped however I still think his idea is surprised, unexpected and...

There's a good change this is some proces that is using the 'abc\mssqlsrv' account to connect to a database that has not yet been brought on line.

One hint is the...

Have you had a look at what MAP 6.0 can do?

MAP is the Microsoft Application and Plannng toolkit, downloadable free from Microsoft. It does a very good job of reporting...

If this is something you want to use going forward then avoid the sp_dboption and stick to the ALTER DATABASE version.

sp_dboption has been removed in SQL Denali.

Cheers

Leo

It sounds like this is a new implementation. I've found that with new Sharepoint installations users madly add their old documents and the database grows very quickly initially, but once...

To answer your original question: Should you upgrade to 2008 for the MERGE statement?

I'd have to say if that is the only reason you have for upgrading then probably not....

Also what version of Sharepoint are you using?

Leo