You do need to check with your system admin that they aren't using anything like NetBackup's De-duplication technology when they make tape backups of the SQL backup files. The net...

bailifei2011 (10/14/2011)

---

For database, it is safer to choose one reliable tool to protect it. Trust backup software on the market, such as todo backup, nova, clonezilla, Acronis. Personally, I recommend...

I've just tested this and it works.

select replace('This -- is a sample --','--','')

Returning: This is a sample

Cheers

Leo

Are you by any chance using NOD32 Antivirus and firewall?

Leo

I have seen this happen when you have a domain account logged onto SQL and you change the domain account password. If you then try log on from another computer...

As long as DYNSA is a user in the database you can't make it the database owner. You will firts have to delete the user from the database, then run...

The answer depends on how you are licensed and what version of VMWare you have. VMWare ESX can support up to 8 virtual CPUs per VM. This is from the...

SQL doesn't allow you to let a database user become THE database owner, or for the database owner to be made an explicit database user. This is different to being...

Don't know about the US, but here in New Zealand I'd probably copy the file to tape and have it couriered the remote centre.

Cheers

Leo

Are you also rebuilding the clustered index?

Cheers

Leo

The primary issues I've experienced with this have been related to the renaming of the server. Yes, you can create a clone, SQL will start with only the system databases,...

Not sure why you would still be setting up Windows 2003 clusters, but you can do it.

Note that if you are installing both SSRS 2005 and SSRS 2008R2 you MUST...

If...

I've worked with this sort of scenario before and it can be worth while setting this up.

In the event of a planned failover, e.g. for maintenance, where you need to...

Also, it is commonly believed that one can't create an index on a table variable, however, this can be achieved by declaring a primary key like in the example below....