If the biztalk jobs are failing, you may need to set up a SQL Agent proxy for the biztalk account. See BOL for details of how to do this.

Move master and mssqlsystemresource if you wish, but be prepared for future Service Pack and even CU updates to fail. Also don't expect an upgrade in place to the...

A lot of the comments I have seen on this thread warn about the pitfalls of adding hints to T-SQL code. I agree that if you try to optimise...

At my place we have a specific Windows group and a set of authorities that provides 'read-only' type access to all server objects. As Database Architect I use these...

How did you get the data from SQL7 to SQL 2005? If you copied the mdf and ldf files, or if you did a restore, you need to rebuild...

I would agree that placement of master, mssqlsystemersource, and model does not matter. The main drivers for any type of DB placement are data security and performance, neither of...

My advice is to do this type of formatting in your application, not in SQL Server.

Although it can be done in SQL Server, application code does this task far more...

There is no documented process for changing the names of these groups. My strong recommendation is do not attempt to rename these groups or you could put yourself outside...

There is a LOT of mis-information given about the /3GB switch, and from your response some is now coming from Microsoft!

What happens without the /3GB switch:

This information only applies to...

This is the primary cause of your problems, and you need to stop SQL needing to produce this...

I have seen this behaviour at my old place on a Data Warehouse.

We start with many thousand pages in the bufferpool, and not much space allocated to locks....

Showing exactly why a SELECT * is bad is harder than it needs to be in the SQL Server world, partly due to lack of metrics.

Going back a decade when...

The more you read about how 32-bit Windows uses memory above the 4GB line, the more you will realise that the information quoted in your original post is correct. ...

When you do an update, SQL writes this to the log. SQL also makes an estimate of the amount of log space that would be required to backout the...

If your main experience is with Oracle, I thought you might welcome a summary of how MS support SQL Server.

While Microsoft are developing a product, they will often release specific...