There is some performance hit to running on a VM, but it is hard to predict exactly what it will be. You are sharing real hardware with other VMs,...

"My understanding is, a primary key should be not null and uniquely identify each row"

A primary key must be not null and must uniquely identify each row.

"Is there like a...

If you can, convert your ntext column to nvarchar(max), and you won't have to worry about updatetext or writetext. You can just use regular string functions and operators.

That is something being done by the remote email systems, so it is not under your control.

You might try contacting the admins of those emails systems to try to get...

A NATURAL JOIN is an inner join where the RDBMS automatically selects the join columns based on common columns names. Some RDBMS vendors, like Oracle but not SQL Server,...

I think the simple answer is supply and demand. It is easy enough to get someone who can click around in the tools and get stuff done without doing...

Angelindiego (11/10/2008)

---

Fair enough....I would like to re-write it, but I am not sure what '=*" means??

It is in this context in my query:

select

something s

from

...

Angelindiego (11/10/2008)

---

:hehe: I am in the process of trying to make db projects in VS2005 TFS. I am getting an error in one current project that says the...

Why don't you just use the NetBackup SQL Server Agent to do your backups?

Have you checked the creation date of the table to verify that it is not being dropped and re-created, instead of truncated?

You should not use NOLOCK hints.

Look into using SNAPSHOP isolation to prevent report queries from causing blocks or being blocked by other processes.

It is usually not necessary to re-index so often. Once per week or less is probably plenty.

You really have two different issues there, database backups and index rebuilds.

You should have some kind of backup happening on a regular schedule, along with transaction log backups if the...

You might want to read through this thread:

http://www.sqlservercentral.com/Forums/Topic583474-357-1.aspx

ROBOCOPY is good for moving files across a network. It has command line switch options for automatic retry and to resume a file copy at the point of failure,...