If you move master and/or mssqlssytemersource from their default location, do not be surprised if the next service pack install fails and leaves your SQL instance unuseable. You have...

My preference is to always use SQL native backup for master database. A restore of master is normally only done when things are broken, and at that stage I...

If your Prod environment is 64-bit, then your pre-production environment also needs to be 64-bit. Ideally everything from Dev onwards needs to be 64-bit - the last thing you...

I used to manage an application that needed its users to have db_ddladmin rights in tempdb.

I created a job that ran when Agent was started to create these rights. ...

If you want to set up a user in SQL Server 2005 or above so they can:

View all object definitions in all daabases (including SP source, etc)

View all data in...

Marios is right, I had forgotton this issue.

There is a documented process for moving master DB data and log files, and for moving the resource DB files. I had...

If you want to apply SP2 and a CU without rebooting, you must:

1) Stop all SQL Server services

2) Stop the .Net Optimization service (stop both the x86 and x64...

Bob,

Cool idea, but it would duplicate the systems our governments are already working on. If you have done or thought nothing wrong, what have you to fear 🙂

mofcomp is a system utility. It compiles the mof file that is in the location specified. One of the main uses of compiled mof files is to make...

Anyone who has used SQLServerFineBuild knows it aims to produce a best-practice install and configuration with a single click.

SQL Server 2008 brings many new features that would need to be...

sql.sanya,

What benefit is the server giving to your business? If it is helping the business earn money, then the business needs to pay money to keeps its assets working.

It...

On 64-bit SQL Server you need to set a maximum memory limit. Otherwise SQL Server adds the page file size to the actual server memory and tries to use...

Even with a development server, I would test your planned configuration on a Crash & Burn server first.

Also, when you do make the move to SQL Server 2008,...

My advice is report this to Microsoft PSS, they may be able to help even though you aer on an old OS.

The most likely cause of the problem is a...

If you are just looking at elapsed time, then doing just a DELETE will be faster. Also, if the DELETE will almost always find data to delete then this...