Data protection forms part of Information Lifecycle Management (ILM). ILM covers not just who should be able to access the information, but also how long the information should survive,...

It might be the 'right' answer but it is a bit simplistic.

Looking at the SELECT... If a column is not in the SELECT list or a WHERE predicate it...

If your queries need to sort and group data they will use space in tempdb. Basically you have 3 choices:

1) Rewrite your queries to avoid the sorting and grouping....

Your problem is because the syntax in the KB article is wrong.

During the SQL Server 2008 development process, the syntax for setup.exe was changed and all keywords must now start...

Non-compete clauses are a way for your employer to say you are worth more to the business than the value of your salary. This means we should be looking...

It is possible to get a good backup of SQL Server databases using block level copy, providing you do all the right things. If you miss something out, you...

Thanks for the clarification 🙂

My advise is to use whatever your organisation has the most skills in.

The first preference is to leave it in DB2, as moving it means you are paying...

I don't think that the question gives enough detail to say that limiting SQL Server memory to 512 MB is the right answer.

If you are trying to tune...

If xp_cmdshell or CmdExec are run by an account with sysadmin authority, they...

Cath has a good idea... Get the Windows admin folk to rename your login so it uses only upper case characters.

There are 2 parts in using SQL Server 2008, both of which will take some time getting used to:

* Using the database engine, AS, RS, etc

* Using the client tools

The...

"Customer Service" ..although there are some companies that DO know how to do this.

Copy Only backups should not be seen as a 'second class' backup. For large-scale OLTP shops they have an important role to play in maintaining availability. They are...

Leaving the services as not started is not relevant. The SQL Server install starts and stops the SQL services a number of times. The SP2 install also starts...